Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Syntax Error?
Message
From
23/09/2004 08:32:38
 
 
To
23/09/2004 07:58:01
General information
Forum:
Oracle
Category:
Packages
Title:
Miscellaneous
Thread ID:
00943079
Message ID:
00945323
Views:
17
Hi,
Actually its a good question. I honestly dont know why varchar2 must have its length specified but numbers do not.

Possibly this is why:

CREATE TABLE X(
Y NUMBER,
X VARCHAR2(10))

select * from user_tab_columns where table_name='X';

Notice that the number variable gets a length of 22 (the max size possible).

Whereas I can imagine setting the varchar2 to the max possible (4000)
would waste a lot of space..

I usually just specify a length for both as a general good practice.

BR
Tim
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform