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

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

Question Posted / narendrareddy

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

Answer / santosh

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

Is This Answer Correct ?

3 Yes

0 No

More SQL PLSQL Interview Questions

How many commands are there in sql?

There are 5 records in a table and we have implemented two triggers that are :pre_query and post_query how many times these triggers will fire.

how to increment dates by 1 in mysql? : Sql dba

How do I find duplicates in the same column?

What is the difference between Union and Union all. Which is faster.

what is 'mysqladmin' in mysql? : Sql dba

What is anonymous block in sql?

What is difference between rank () row_number () and dense_rank () in sql?

package specification-3 procedures package body-2 procedures will is execute

How to download oracle sql developer?

Is truncate ddl or dml?

sql query to get zero records from a table having n no of records

For more SQL PLSQL Interview Questions Click Here