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
- 7043 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
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
What is the benefit of foreign key?
what is oracle database ? : Sql dba
What does pragma mean?
What is varray in pl sql?
How to pipe multiline string to isql?
What is pl sql block in dbms?
What does the hierarchical profiler does?
Define implicit and explicit cursors.
How do I add a primary key to a table?
Can a commit statement be executed as part of a trigger?
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...
How many sql statements are used? Define them.
define sql insert statement ? : Sql dba
Name the different types of indexes in sql and define them.
