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

Explain the methods used to protect source code of pl/sql.

548

Does user triggers have entry for trigger with compilation errors?

602

Can we create table in function?

574

Define concurrency control. : Transact sql

587

What is sqlerrd?

528

What are % type and % rowtype?

578

what is sql server agent? : Sql dba

605

What are sql objects?

546

What is sql and db2?

537

What is function and procedure in pl sql?

523

What is Collation Sensitivity ? What are the various type ?

501

Does sql support programming?

557

What is sap sql anywhere?

535

Could you please provide oca (oracle 10g) dumps for my certification ?

4515

What are different types of triggers?

565