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
- 7035 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
Is primary key a clustered index?
Is record in oracle pl sql?
What is trigger types in sql?
What are %type and %rowtype for?
Is sql low level language?
What are the triggers associated with image items?
What is substitution variable in pl sql?
What is the basic structure of an sql?
What does select * from mean in sql?
Does pdo prevent sql injection?
What is an oracle stored procedure?
How does a self join work?
What is a dynamic query?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
Explain constraints in sql?
