1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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 / manojkumar

Answers were Sorted based on User's Feedback



Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. R..

Answer / 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

Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. R..

Answer / lince

select substring(NAME,1,charindex(' ',NAME))+' '+
replace(substring(NAME,charindex(' ',NAME),len(NAME)),' ','')
as NAME from test

Is This Answer Correct ?    1 Yes 0 No

Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. R..

Answer / kalyan

update test set NAME=regexp_replace(NAME,'( ){2,}', ' ')

Is This Answer Correct ?    1 Yes 0 No

Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. R..

Answer / manojkumar

Thanks to Kavitha and Lince.
Both answers are correct in oracle and in Sql Server.
Excellent
Thanks a lot

Is This Answer Correct ?    0 Yes 0 No

Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. R..

Answer / swastik

select substr(name,1,instr(name,' ',1)-1)||substr(name,instr(name,' ',-1),length(name)) from spacename

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What schema means?

0 Answers  

how to use myisamchk to check or repair myisam tables? : Sql dba

0 Answers  

Where the sql database files are stored?

0 Answers  

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

0 Answers  

Is drop table faster than truncate?

0 Answers  




Can we perform dml in function?

0 Answers  

What is clause in sql?

0 Answers  

What is the difference between count 1 and count (*) in a sql query?

0 Answers  

What is sqlexception in java?

0 Answers  

overloading of stored procedure is possible in oracle?

3 Answers   Nelco,

What is difference between ms sql and mysql?

0 Answers  

How would you reference column values before and after you have inserted and deleted triggers?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories