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

What packages(if any) has oracle provided for use by developers?

5785

Does truncate release storage space?

1060

What does := mean in pl sql?

1030

Can %notfound return null after a fetch?

1040

what is a materialized view? : Sql dba

1048

Is crud a cuss word?

1015

What is the difference between python and sql?

973

How would you reference column values before and after you have inserted and deleted triggers?

1050

What is a record in pl/sql?

1127

What is the difference between local and global temporary table?

1025

what are null values? : Sql dba

937

Can we update views in sql?

925

What is insert command in sql?

1107

How do I start sql from command line?

1002

What is the difference between left and left outer join?

938