select regexp_replace('@So&*CIE%$TE@GEN!@RAL','[^a-zA-Z]

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

Question Posted / santosh

Answer Posted / santosh

select regexp_replace('@So&*CIE%$TE@GEN!@RAL','[^a-zA-Z]') from dual

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can there be 2 primary keys in a table?

993

What is a primary key sql?

1039

How do I truncate a sql log file?

1062

What is pls integer?

1026

Define select, insert, create, delete, update, drop keywords

1038

Explain the significance of the & and && operators in pl sql.

1002

What is output spooling in sql*plus?

1025

How do you respond to dementia behavior?

963

How do you remove duplicate records from a table?

936

what is the difference between char_length and length? : Sql dba

1037

Define tables and fields in a database

1124

Which sql statement is used to return only different values?

997

What is the benefit of foreign key?

1019

Is primary key an index?

989

What is varray in pl sql?

1067