|
|
| Re: inserting data from other table. [message #370995 is a reply to message #370993] |
Wed, 02 August 2000 04:52  |
Vjeko
Messages: 15
Registered: August 2000
|
Junior Member |
|
|
Example:
You have two tables:
Table1 (a number(2),
b varchar2(10))
Table2 (a number(1),
b varchar2(8))
and you want to insert data from Table1 to Table2. If Table1.a and Table1.b data are to big to fit in Table2 columns you must enlarge size of Table2 columns.
ALTER Table2
modify (a number(2),b varchar2(19));
It won't change any of old data in Table2.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
