Write a sql to print only character form the below string.
@So&*CIE%$TE@GEN!@RAL
- 1 Answers
- 3192 Views
- Societe Generale, I also Faced
- E-Mail Answers
Answer Posted / santosh
select regexp_replace('@So&*CIE%$TE@GEN!@RAL','[^a-zA-Z]') from dual
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is difference between table and view?
What is auto increment feature in sql?
Which is faster view or stored procedure?
What is sql profiler in oracle?
what are all the different normalizations? : Sql dba
How to display Row Number with Records in Oracle SQL Plus?
What is spool?
Which is faster truncate or drop?
How do you update f as m and m as f from the below table testtable?
What is difference between pl and sql?
what are rollup and cube in t-sql? : Transact sql
How does join work in sql?
what is heap table? : Sql dba
Is sql microsoft?
What is clustered index sql?
