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 rdbms? : Sql dba

1063

What are conditional predicates?

1121

explain primary keys and auto increment fields in mysql : sql dba

1016

Does asenumerable execute the query?

1096

What is a ddl command?

1154

How much ram can sql express use?

1040

Are null values same as that of zero or a blank space?

1065

Explain how can you save or place your msg in a table?

1075

How to combine two stored procedures in sql?

1324

what is the use of friend function? : Sql dba

1058

What is left join in postgresql?

1091

Why do we need view in sql?

1037

what is 'mysqldump'? : Sql dba

1166

what is the difference between primary key and unique key? : Sql dba

1085

What is dml statement?

999