SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to find the data type of data in variable

BommiMar 30 2022

Hi Experts,
I declared 3 variables as VARCHAR2(100). Now, in first variable I gave '31-MAR-2022' and in second variable, I gave value '100' and in third variable I gave 'Dummy'.
Now, through SQL or PLSQL I want to figure out what type of data is stored in those variables.
Can anyone please help me on this.

Thanks,
Bommi

Added on Mar 30 2022

#plsql, #sql

11 comments

4,485 views

1 mention