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 |
what is datawarehouse? : Sql dba
What is function and procedure?
What is cte?
What is cursor and why it is required?
What is the use of double ampersand (&&) in sql queries? Give an example
select 1,col1,col2 from table1. output?
What is user in sql?
what are the features and advantages of object-oriented programming? : Sql dba
What is the difference between clustered and non-clustered indexes?
When can we use the where clause and the having clause?
Why do we need databases?
What is cold data?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)