Answer / kavitha n

SELECT NAME,
( SUBSTR (NAME, 1, (INSTR (NAME, ' ', 1)))
|| ''
|| SUBSTR (NAME, INSTR (NAME, ' ', -1), LENGTH (NAME))
) output
FROM test;

Answer / lince

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

Answer / kalyan

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

Answer / manojkumar

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

Answer / swastik

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

suppose u hav 1 book with set...page 1-100 n 101 -200 now print page from 2-100 n 102 -200... how we will do..?

6 Answers  

Which is the best place to learn hadoop?

1 Answers  

What is the best free sql database?

0 Answers  

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

0 Answers  

What does desc stand for?

0 Answers  

what is difference b/w pravite procedures and public procedures?

3 Answers   Steria, Wipro, Zensar,

What are all the different normalization?

0 Answers  

How to use boolean type in select statement?

0 Answers  

I have a package in which a table was used in a procedure and compiled later i have dropped the table used in the package what would be the status of package specification and body

1 Answers   TCS,

how can we find the select statement is indexed or not?

3 Answers   CTS,

Is oracel sql developer written in java?

0 Answers  

what is transaction? : Sql dba

0 Answers