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
- 10457 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sreenivasulu sangatipalli
SELECT regexp_replace('A...B..C.D......E....F', '[.]+', '.') FROM DUAL;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Does oracle roll back the transaction on an error?
Why is partition used in sql?
how do you know the version of your mysql server? : Sql dba
what are the performance and scalability characteristics of mysql? : Sql dba
Can we use loop in sql?
What is the difference between count 1 and count (*) in a sql query?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
What type of database is cloud sql?
what is text? : Sql dba
What is acid property in a database?
What is a primary key? Explain
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What are hotfixes and patches?
How can we debug in PL/SQL?
What is varchar used for?
