VARIABLE declaration in SQL*Plus [message #10708] |
Wed, 11 February 2004 07:32 |
Valli
Messages: 2 Registered: September 2002
|
Junior Member |
|
|
Hi,
Can someone explain why NUMBER data type VARIABLE declaration in SQL*PLus doesn't allow size specification with it? For example, I can declare a NUMBER column while creating a table as in
Create table mytable (a NUMBER(5,2));
where as I receive an error while declaring a variable through SQL*Plus as in
VARIABLE n NUMBER(5,2)
My intention is to use n for a bind variable in pl/sql block.
Thanks,
Valli
|
|
|