Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Post New Answer

More SQL PLSQL Interview Questions

what is the order of pre-defined exceptions.

6 Answers   TCS,

I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?

2 Answers   HSBC,

How many sql core licenses do I need?

0 Answers  

What is the primary key?

0 Answers  

select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?

2 Answers  




What is the difference between database trigger and stored procedure?

0 Answers  

What is procedure and function in sql?

0 Answers  

What are the syntax and use of the coalesce function?

0 Answers  

How do you identify a primary key?

0 Answers  

what are the different tables present in mysql? : Sql dba

0 Answers  

How do you update a sql procedure?

0 Answers  

What are different categories of sql commands?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories