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 clustered and nonclustered index in sql?

504

What can I use instead of union in sql?

520

how to convert character strings to numeric values? : Sql dba

581

What is the usage of the distinct keyword?

694

Is null operator in sql?

610

What are the different types of a subquery?

526

How do I get sql certification?

533

How do I make my sql query run faster?

472

Is not null in sql?

566

What is sql injection owasp?

556

What are string functions in sql?

685

What is full form of rtm?

539

Which certification is best for sql?

546

What is a string data type in sql?

521

What is rollback?

592