Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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 are tables and fields in the database?

0 Answers  

What is sql in oracle?

0 Answers  

Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...

1 Answers  

SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/

1 Answers   Accenture,

What is primary key in db?

0 Answers  

what is the difference between truncate and drop statements? : Sql dba

0 Answers  

what is explain plan?

4 Answers  

what is offset-fetch filter in tsql? : Transact sql

0 Answers  

What is hibernate and its relation to sql?

0 Answers  

What is an intersect?

0 Answers  

What are different clauses used in sql?

0 Answers  

Which is the correct statement about truncate and delete?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories