var=1; --var='a' select to_number(var) from dual; if variab

How to find string or key value using pl/sql code?

Question Posted / kumarvijay

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

Please Help Members By Posting Answers For Below Questions

Which is faster union or join?

1021

Is sqlite free?

1019

List the ways to get the count of records in a table?

940

How is a PL/SQL code compiled?

1279

What is pivot table in sql?

1164

What is the execution plan in sql?

1066

What is user defined functions?

1024

Why is a primary key important?

1099

What is a column in a table?

1182

What is the difference between delete and truncate statement in sql?

1117

What is the difference between function, procedure and package in pl/sql?

1342

Does db2 use sql?

1004

Can we create clustered index without primary key?

996

What is sequence in sql?

1074

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1177