Write a sql to print only character form the below string.
@So&*CIE%$TE@GEN!@RAL
- 1 Answers
- 3033 Views
- Societe Generale, I also Faced
- E-Mail Answers
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 |
More SQL PLSQL Interview Questions
How is data stored in sql?
what is the difference between delete and truncate statement in sql? : Sql dba
What is sql deadlock?
What is an example of translating a date into julian format?
How does postgresql compare to mysql?
Why query optimization is needed?
What is relationship? How many types of relationship are there?
how to check server status with 'mysqladmin'? : Sql dba
What is the need of a partition key?
Define union, minus, union all, intersect ?
What are all different types of collation sensitivity?
How do I copy a table in sql?
Categories
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
