Write a sql to print only character form the below string.
@So&*CIE%$TE@GEN!@RAL
Answer Posted / 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 View All Answers
Can we use loop in sql?
How to revise and re-run the last sql command?
What is an ndf file?
What is procedure and function in sql?
Does varchar need length?
how to dump a table to a file with 'mysqldump'? : Sql dba
What is offset and limit in sql?
What is sqlite used for?
Explain what is a column in a table?
What are the types of index in sql?
How does an execution block start and end in pl sql?
What is Histogram?
What mean sql?
How do you break a loop in pl sql?
What is sql exception?