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

Why are aggregate functions called so?

1012

Is sql a microsoft product?

994

Why self join is used in sql?

1028

what is heap table? : Sql dba

1136

what is cross join? : Sql dba

1046

What is a clob in sql?

1063

is mysql query is case sensitive? : Sql dba

1162

What is the use of desc in sql?

1017

What is set serveroutput on in pl sql?

1358

Can we perform dml in function?

1130

How is data stored on a disk?

1082

what are integrity rules?

1091

What is linq to sql?

1178

What are sql commands?

1066

How can I delete duplicate rows?

1062