Home » SQL & PL/SQL » SQL & PL/SQL » default length
default length [message #243428] Thu, 07 June 2007 04:57 Go to next message
pavuluri
Messages: 247
Registered: January 2007
Senior Member
Hi,
datatype:
default length of number is 1.
is it correct?
Thanks,
Srinivas

[Updated on: Thu, 07 June 2007 04:58]

Report message to a moderator

Re: default length [message #243434 is a reply to message #243428] Thu, 07 June 2007 05:22 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
pavuluri wrote on Thu, 07 June 2007 11:57
Hi,
datatype:
default length of number is 1.
is it correct?
No it is not. Go on. Don't be afraid. Read those manuals. "The absence of precision and scale designators specifies the maximum range and precision for an Oracle number."

http://www.orafaq.com/forum/fa/448/0/

MHE
Re: default length [message #243479 is a reply to message #243428] Thu, 07 June 2007 08:10 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Download an Express Edition (= FREE) version of the Oracle database software and install it on your computer.
Now you can go ahead and test everything you ask here. Believe me, you will learn a great deal more from that!

SQL> connect scott/tiger@xe
Connected.
SQL> create table test_number
  2  ( my_number number
  3  );

Table created.

SQL> insert into test_number values (10);

1 row created.


This simple test would have shown you that the default is not number(1).
Previous Topic: extract program
Next Topic: How to get back deleted procedure from package
Goto Forum:
  


Current Time: Thu Dec 08 00:17:41 CST 2016

Total time taken to generate the page: 0.10677 seconds