Write a sql to print only character form the below string. @So&*CIE%$TE@GEN

Write a sql to print only character form the below string.
@So&*CIE%$TE@GEN!@RAL

Question Posted / narendrareddy

1 Answers
2880 Views
Societe Generale, I also Faced
E-Mail Answers

Write a sql to print only character form the below string. @So&*CIE%$TE@GEN!@RAL..

Answer / 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

More SQL PLSQL Interview Questions

What are advantages of Stored Procedures?

3 Answers Satyam,

What is the difference between execution of triggers and stored procedures?

0 Answers

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2 Answers

Can we rollback delete command?

0 Answers

what is bcp? When does it used? : Sql dba

0 Answers

how can we destroy the cookie? : Sql dba

0 Answers

How can we optimize a sql query?

0 Answers

What are different types of keys?

0 Answers

What is the use of index in hive?