i am new to PL/SQL. I am confused with the difference between following.
DECLARE name Varchar2(20);
VARIABLE name Varchar2(20);
DEFINE name = 'myname';
Thanks in advance.
DECLARE
starts a pl/sql block.
DEFINE
substitute values.
Regarding VARIABLE
take a look on Oracle Documentation.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With