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 is cursor and why it is required?

1190

What is the difference between cluster and non-cluster index?

1113

Can a varchar be a primary key?

1018

What are the three pl sql block types?

1016

What does sign mean sql?

1121

What is sqlcontext?

1091

How does a covering index work?

971

What are the advantages of sql? Explain

1113

What is trigger types in sql?

1004

What is exit statement?

1020

What is sqlite used for?

1008

How to raise user-defined exception with custom sqlerrm ?

1138

what is the different between now() and current_date()? : Sql dba

1030

What are the constraints available in sql?

1054

Can you call pl/sql package functions from within a fast formula?

1048