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

Does pl sql work in mysql?

983

Explain the advantages and disadvantages of stored procedure?

1150

What is a system versioned table?

987

Can we use join in subquery?

1096

What is on delete set null?

1090

Why sql query is slow?

1001

what are the authentication modes in sql server? How can it be changed? : Sql dba

1434

Can I create table without primary key?

998

How do I run sql?

1187

Explain what is sql*plus?

1146

Explain the structure of pl/sql in brief.

1095

what are the differences among rownum, rank and dense_rank? : Sql dba

1040

How to combine two stored procedures in sql?

1237

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

1091

What do you understand by pl/sql cursors?

1088