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 -- -- --
- 5 Answers
- 6390 Views
- I also Faced
- E-Mail Answers
Answer Posted / swastik
select substr(name,1,instr(name,' ',1)-1)||substr(name,instr(name,' ',-1),length(name)) from spacename
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is difference between primary and secondary key?
Write a unique difference between a function and a stored procedure.
how to get @@error and @@rowcount at the same time? : Sql dba
What is sorting in sql?
How to write a query to show the details of a student from students table whose
Why is pl sql used?
What does truncate mean in sql?
What is a trigger in sql?
How can I delete duplicate rows?
What is offset and limit in sql?
What is forward declaration in pl sql?
What is identity column in sql server?
What is sql injection vulnerability?
Does sql*plus have a pl/sql engine?
Write the command to remove all players named sachin from the players table.
