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 / manojkumar
Thanks to Kavitha and Lince.
Both answers are correct in oracle and in Sql Server.
Excellent
Thanks a lot
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain aggregate functions are available there in sql?
Why is normalization important?
What is scalar data type in pl sql?
What is the difference between inner join and natural join?
what does the t-sql command ident_incr does? : Transact sql
Explian rowid, rownum? What are the psoducolumns we have?
Mention what are the benefits of pl/sql packages?
What are different types of tables in sql?
What sql does db2 use?
What is a crud api?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
how many ways we can we find the current date using mysql? : Sql dba
Is sql a backend?
What are %type and %rowtype for?
What is sql performance tuning?