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 |
Which language is used in sql?
What is output spooling in sql*plus?
Can we interchange parameters in procedure while calling
How to sort the rows in sql.
how to get @@error and @@rowcount at the same time? : Sql dba
what is self join and how it works??
What is difference between my sql and sql?
if we give update table_name set column_name= default. what will happen? its given in pl sql block.what will hapen?
explain normalization concept? : Sql dba
What is a temp table?
Explain what is a field in a database and record in a database?
Why procedure is used in sql?
Oracle (3253)
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)