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

Explain ddl statements in pl/sql?

1009

What is the difference between view and stored procedure?

959

what is the difference between truncate and drop statements? : Sql dba

1124

how to analyze tables with 'mysqlcheck'? : Sql dba

1013

How to fetch alternate records from a table?

1244

What is loop in pl sql?

1038

When sql appeared?

1101

what is error ora-03113: end-of-file on communication channel?

1165

What is compound trigger?

1036

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1060

how to check myisam tables for errors? : Sql dba

1321

Can I call a procedure inside a function?

1011

what are all the common sql function? : Sql dba

1057

Why is nosql good?

1025

How do you optimize a query?

999