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 retrieve last tree records from table? select *from emp where rownum > (select count(*)-3 from emp); i am using this query to get last three records from table but its not giving any output, so please tell me what is the error in this query.

16 Answers  

Is pl sql useful?

0 Answers  

What is Materialized View? In What Scenario we Use Materialized View?

2 Answers   Dinesh, Marlabs,

What do we need to check in database testing?

0 Answers  

Explain the insert into statements in sql?

0 Answers  

select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?

2 Answers  

What are the two parts of a procedure ?

6 Answers   Hi Caliber IT,

What is difference between stored procedure and trigger?

0 Answers  

What is varchar used for?

0 Answers  

Why we use joins in sql?

0 Answers  

What is the difference between database trigger and stored procedure?

0 Answers  

What are the default Oracle triggers??

3 Answers   CGI, Tech Mahindra,

For more SQL PLSQL Interview Questions Click Here
Categories