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

how to see the create table statement of an existing table? : Sql dba

1019

How do you update a value in sql?

1047

What is the difference between partitioning and sharding?

1008

How do I count records in sql?

1013

Can we create foreign key without primary key?

987

how to delete an existing column in a table? : Sql dba

1007

Where is all the data on the internet stored?

1015

Does pl sql work in mysql?

986

what is dbms? : Sql dba

1000

What is character functions?

1064

What is rownum in sql?

1046

What is consistency?

1130

How do I remove duplicates in two columns?

1073

How many scalar data types are supported in pl/sql?

1057

What is rank function in sql?

1030