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
What is function and procedure in pl sql?
What can you do with pl sql?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
Explain the difference between drop and truncate commands in sql?
How do I find duplicates in sql?
What are pl sql data types?
how would you get the current date in mysql? : Sql dba
Explain what is a database?
What are the popular database management systems in the it industry?
Explain the difference between rename and alias?
What is set serveroutput on in pl sql?
What is the purpose of a sql?
Explain what is an index?
Explain what is a column in a table?
explain the advantages and disadvantages of stored procedure? : Sql dba