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

Suppose There is a string
A.B....C.......D.........E........F In this string dots (.)
are not having fixed count in between of string. I want the
output to have string with one dot between. I.e.
A.B.C.D.E.F

Question Posted / parli jain

Answers were Sorted based on User's Feedback



Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not h..

Answer / oddabout.com

SELECT replace(replace(replace('A.B....C.......D.........E........F','.',' @'),'@ ',''),' @','.') FROM dual

Is This Answer Correct ?    8 Yes 1 No

Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not h..

Answer / dilip kumar

SELECT REGEXP_REPLACE (
Replace ('A.B....C.......D.........E........F', '.', ' '),
'( ){1,}',
'.')
FROM DUAL;

Is This Answer Correct ?    3 Yes 2 No

Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not h..

Answer / sreenivasulu sangatipalli

SELECT regexp_replace('A...B..C.D......E....F', '[.]+', '.') FROM DUAL;

Is This Answer Correct ?    0 Yes 0 No

Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not h..

Answer / anuradha

SELECT REGEXP_REPLACE (
REPLACE ('A.B....C.......D.........E........F', '.', ' '),
'( ){2,}',
'.')
FROM DUAL;

Is This Answer Correct ?    3 Yes 5 No

Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not h..

Answer / sunaksha

select  REGEXP_REPLACE ('A.B....C.......D.........E........F','.{1,}',
'.') FROM DUAL; 

Is This Answer Correct ?    0 Yes 3 No

Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not h..

Answer / sandeep kumar

select replace(regexp_replace(replace
('A.B....C.......D.........E........F','.',' '),'( )
{2,}',' '),' ','.') from dual

Is This Answer Correct ?    1 Yes 13 No

Post New Answer

More SQL PLSQL Interview Questions

how to concatenate two character strings? : Sql dba

0 Answers  

what is bcp? When does it used? : Sql dba

0 Answers  

Define SQL and state the differences between SQL and other conventional programming Languages?

0 Answers  

What is schema in sql?

0 Answers  

What is the difference between explicit and implicit cursors in oracle?

0 Answers  

Is left join and outer join same?

0 Answers  

----> There is a table T with two columns C1 and C2. The data is as below: C1 C2 1 4 2 5 3 6

4 Answers   ICICI,

which types of join is used in sql widely? : Sql dba

0 Answers  

Sql technical questions

0 Answers  

how can stop the sequence with mention the max value and with out mention the max value

1 Answers   Zensar,

How do you use collections in procedure to return the resultset?

0 Answers  

what will be the output: select 1 from emp union all select 2 from emp;

2 Answers   iNautix,

For more SQL PLSQL Interview Questions Click Here
Categories