Like shown below i have 3 columns(Name,No,Address). The
values in name column i want to modity.
Requirement : Keep only once space between two words
(Fname,Lname) in the Name column.
For this what is the query? Please answer me. Advance
Thanks.
Name No Address Reference
manoj kumar
kumar raja
vinzay kumar
rajendra prasad
gowri nath -- -- --
Answer Posted / kavitha n
SELECT NAME,
( SUBSTR (NAME, 1, (INSTR (NAME, ' ', 1)))
|| ''
|| SUBSTR (NAME, INSTR (NAME, ' ', -1), LENGTH (NAME))
) output
FROM test;
Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
How is pl sql different from sql?
Why is nosql good?
Explain polymorphism in pl/sql.
What is sap sql anywhere?
What are the parts of a sql statement?
Is left join faster than inner join?
How much does sqlite cost?
When should I use nosql database?
What is pl sql quora?
Is pl sql a scripting language?
Are subqueries better than joins?
how to include numeric values in sql statements? : Sql dba
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
What is a data manipulation language?
What is pessimistic concurrency control? : Transact sql