-
Trim Sql Not Getting It
thanks in advance
MY SQL QUERY OUTPUT SHOWS LIKE THIS
NAME
---------
GAJANAN KINI
PRASHANT KINI
AJAY KINI
i want the output to be like this
NAME
--------------
GAJANANKINI
PRASHANTKINI
AJAYKINI
i tried but not getting this output. can someone advise me
-
So, what is the query that you are trying to run?
you could try
select replace (name,'') from table;
-
SQL> select replace('abcd xyz',' ','') from dual ;
REPLACE
-------
abcdxyz
Tamil
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|