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
7726 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 is %type in sql?

917

Why join is faster than subquery?

1042

What is a trigger in sql?

1156

What is the difference between a primary key and a unique key?

998

How do I count records in sql?

942

What is the difference between pl and sql?

1034

What is rank () in sql?

882

What are the two types of cursors in pl sql?

1001

what is a database? : Sql dba

1097

Can we use insert statement in function?

940

How to add new employee details in an employee_details table with the following details

1043

What is sqlexception in java?

939

How do you write a complex sql query?

1007

describe mysql connection using mysql binary. : Sql dba

993

What is the difference among union, minus and intersect?

949