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

Do prepared statements prevent sql injection?

0 Answers  

When you have to use a default "rollback to" savepoint of plvlog?

0 Answers  

how to return query output in html format? : Sql dba

0 Answers  

How do you delete data from a table?

0 Answers  

How do I create a sql database?

0 Answers  

explain commit and rollback in mysql : sql dba

0 Answers  

Is the primary key an index?

0 Answers  

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

0 Answers  

how to check myisam tables for errors? : Sql dba

0 Answers  

can we create index on index?

7 Answers   iFlex, Symphony,

I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column and value, how can is possible

9 Answers  

What is gpt format?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories