SELECT NAME, ( SUBSTR (NAME, 1, (INSTR (NAME, ' ', 1)))

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 -- -- --

Question Posted / kavitha n

5 Answers
7950 Views
I also Faced
E-Mail Answers

Answer Posted / kavitha n

SELECT NAME,
( SUBSTR (NAME, 1, (INSTR (NAME, ' ', 1)))
|| ''
|| SUBSTR (NAME, INSTR (NAME, ' ', -1), LENGTH (NAME))
) output
FROM test;

Is This Answer Correct ?

5 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How many indexes can be created on a table in sql?

1050

What is native sql query?

1014

What is data modelling in sql?

1014

How do I delete a trigger?

961

How do you drop a trigger?

984

What does data normalization mean?

950

how to use like conditions? : Sql dba

1105

What is the difference between function and procedure in pl/sql?

1078

What are sql constraints?

1172

What is foreign key and example?

931

What is the difference between the implicit and explicit cursors?

1046

How to fix oracle error ora-00942: table or view does not exist

1011

Which are the different character-manipulation functions in sql?

1060

How do I create an index in word?

1027

Which table is left in left join?

1011