Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6 Answers
- 10466 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is varray in pl sql?
What is pl/sql language case sensitive?
Could you please provide oca (oracle 10g) dumps for my certification ?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
How would you reference column values before and after you have inserted and deleted triggers?
What is a pragma statement?
what is self join and what is the requirement of self join? : Sql dba
How to run pl/sql statements in sql*plus?
Can we create a trigger on view?
what is online transaction processing (oltp)? : Sql dba
Mention what is the use of function "module procedure" in pl/sql?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
What is sql trigger example?
Write a sql query to get the third highest salary of an employee from employee_table?
How do I run pl sql in sql developer?
