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 / 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
How can I change database name in sql?
What is the difference between local variables and global variables?
Explain the uses of database trigger.
What is the difference between view and stored procedure?
Can primary key be changed?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is a left inner join?
Does sap use sql?
In pl/sql, what is bulk binding, and when/how would it help performance?
What is a data manipulation language?
What is a parameter query?
What are expressions?
What is data type in database?
What does cursor do in sql?
difference between anonymous blocks and sub-programs.