Home » RDBMS Server » Server Administration » inserting data from other table.
inserting data from other table. [message #370993] Tue, 01 August 2000 06:13 Go to next message
kkumar123
Messages: 1
Registered: August 2000
Location: Hyderabad
Junior Member
I want to insert data from other table with same data type and different in size. Pl. suggest me.
Re: inserting data from other table. [message #370995 is a reply to message #370993] Wed, 02 August 2000 04:52 Go to previous message
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.
Previous Topic: Random numbers in Oracle?
Next Topic: dba-admin-password
Goto Forum:
  


Current Time: Sat Oct 24 04:40:37 CDT 2020