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 compilation error in pl sql?

957

What are the indexing methods?

1026

How do I find duplicates in the same column?

1055

What is sql resultset?

969

What are string functions in sql?

1219

What is a file delimiter?

1068

What is sql trigger example?

1029

What is difference between group by and partition by?

1039

What sql does db2 use?

962

How many sql statements are used?

998

What is the best partition size for windows 10?

986

Is sql a scripting language?

972

Explain select statements in sql?

1040

Explain what is an index?

1034

Explain the commit statement.

1138