Variable declared with variable keyword in sql plus(oracle 9i)?
Posted
by Vineet
on Stack Overflow
See other posts from Stack Overflow
or by Vineet
Published on 2010-04-03T08:34:56Z
Indexed on
2010/04/03
8:43 UTC
Read the original article
Hit count: 356
I am trying to declare g_num ,number data type with size it gives an error but in case of varchar2,char it does not.
variable g_name varchar2(5);//correct accept size for varchar 2
variable g_num number(23);//Gives an error
" VAR[IABLE] [ <variable> [ NUMBER | CHAR | CHAR (n [CHAR|BYTE]) |
VARCHAR2 (n [CHAR|BYTE]) | NCHAR | NCHAR (n) |
NVARCHAR2 (n) | CLOB | NCLOB | REFCURSOR ] ]"
Please suggest!
© Stack Overflow or respective owner
