How to find string or key value using pl/sql code?
Answer Posted / kumarvijay
var=1; --var='a'
select to_number(var) from dual;
if variable holds string it will through exception else it
will execute.
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Which operator is used in query for pattern matching?
What is spool?
What type of database is cloud sql?
How do I audit the sql sent to the server?
How do sql triggers work?
Describe different types of general function used in sql?
What does fetching a cursor do?
define join and explain different type of joins? : Sql dba
How can you view the errors encountered in a trigger?
Write a sql query to find the names of employees that begin with ‘a’?
Why commit is not used in triggers?
what is sql profiler? : Sql dba
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What are the topics in pl sql?
what is 'mysqld'? : Sql dba