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: 363

Filed under:
|

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

Related posts about Oracle

Related posts about oracle9i