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's the procedure?
What are the ways on commenting in a pl/sql code?
Does pdo prevent sql injection?
What is scope of pl sql developer in future?
Are subqueries faster than joins?
how view used for security purposes?
What is before trigger?
How is indexing done in search engines?
I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman
What is nosql db?
what are the differences among rownum, rank and dense_rank? : Sql dba
What is use of package in pl sql?