Variable declared with variable keyword in sql plus(oracle 9i)?

Question

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!

Peter Lang · Accepted Answer · 2010-04-03 14:18:52Z

4

The answer is already in your error message: NUMBER does not allow a precision in SQL*Plus.

VARIABLE g_num NUMBER;

works.

Here is a list with valid variable declarations in SQL*Plus.

The documentation says:

NUMBER
Creates a variable of type NUMBER with fixed length.

Unfortunately I don't know why you can't specify precision with SQL*Plus, but I have been able to store 1.0E+125 with my tests.

What do you need precision for?

edited Apr 3, 2010 at 14:18

answered Apr 3, 2010 at 8:52

Peter Lang

55.7k29 gold badges153 silver badges165 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Variable declared with variable keyword in sql plus(oracle 9i)?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related