Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7965 Views
- I also Faced
- E-Mail Answers
Answer Posted / kalyan
update test set NAME=regexp_replace(NAME,'( ){2,}', ' ')
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many types of privileges are available in sql?
What can sql server reporting services do?
how to select first 5 records from a table? : Sql dba
What is difference between procedure and trigger?
Can you join views in sql?
Is like operator in sql case sensitive?
What is group function in sql?
Differentiate between sga and pga.
What is server name sql?
How many types of primary keys are there?
What is scope of pl sql developer in future?
What is the difference between having and a where in sql?
Explain locks? : Transact sql
What is Histogram?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
