Beginner SQL [message #373425] |
Mon, 16 April 2001 12:22 |
SGahlman
Messages: 2 Registered: April 2001
|
Junior Member |
|
|
I am working with SQL7.0. I am working with multiple tables within a database.
What I want to do is modify/ create my own table with the specs from the already defined tables. HOWEVER- I want to modify the column size. Is this possible? If so, how?
Thanks for your patience...
|
|
|
|
|
Re: Beginner SQL [message #373442 is a reply to message #373425] |
Tue, 17 April 2001 12:39 |
Cindy
Messages: 88 Registered: November 1999
|
Member |
|
|
Yes, it is possible, use the ALTER TABLE statement.
example:
ALTER TABLE dept30
MODIFY (ename VARCHAR2 (15));
Hope this help.
-- Cindy
|
|
|
Re: Beginner SQL [message #373574 is a reply to message #373427] |
Tue, 24 April 2001 05:34 |
lp
Messages: 8 Registered: April 2001
|
Junior Member |
|
|
if smaller, then the column should be empty, otherwise it will give error message as follows
"ORA-01441: column to be modified must be empty to decrease column length".
if larger, then no problem.
|
|
|