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

What are different types of sql commands?

1095

Is sql a backend language?

1076

how to start mysql server? : Sql dba

1182

What is data types in sql?

983

What is partition in sql query?

983

Differentiate between % rowtype and type record.

1278

How exception handling is done in advance pl/sql?

966

What are sql procedures?

1006

What is the difference between clustered and non-clustered indexes?

1074

Does execute immediate commit?

1196

How can we store rows in PL/SQL using array?

1203

What is bulk compiling in pl/sql.?

1110

What is a ddl command?

1069

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1145

What are inbuilt functions in sql?

1028