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

Explain the difference between triggers and constraints?

967

What are the benefits of triggers?

1164

How many tables can a sql database have?

970

How long it takes to learn pl sql?

1003

How do I remove sql developer from windows 10?

1098

What are the two virtual tables available at the time of database trigger execution?

1215

What is the use of procedures?

970

how can we know the number of days between two given dates using mysql? : Sql dba

1041

what is a stored procedure? : Sql dba

1121

When is the update_statistics command used?

1105

what are string data types? : Sql dba

1036

Can delete statement be rollbacked?

980

Can we join 3 tables in sql?

1026

What are the ways on commenting in a pl/sql code?

1124

Is primary key always clustered index?

1011