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 a constraint? Tell me about its various levels.
How to connect a sql*plus session to an oracle server?
Which normal form is best?
Can we create foreign key without primary key?
What is difference between sql and oracle?
What is a unique key?
What are the disadvantages of not performing database normalization?
How can you get sql*loader to commit only at the end of the load file? : aql loader
How can you know that statistics should be updated?
how many sql ddl commands are supported by 'mysql'? : Sql dba
Is a view faster than a stored procedure?
How to return multiple rows from the stored procedure?
What are the operators used in select statements?
What is the difference between left and left outer join?
List the various privileges that a user can grant to another user?