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

What is record type in pl sql?

935

What is embedded sql in db2?

956

Describe types of sql statements?

990

Can we call dml statement in function?

978

what is an extent ? : Sql dba

1018

Which is better stored procedure or query?

918

What is sql exception?

913

What is the use of index in hive?

958

What is data modelling in sql?

962

Is it possible for a table to have more than one foreign key?

976

What is the meaning of disabling a trigger?

1111

Define concurrency control. : Transact sql

1103

Why do we use sql constraints? Which constraints we can use while creating database in sql?

972

When is the explicit cursor used ?

977

what is a tablespace? : Sql dba

1004