| Re: Help please!!!!! [message #370231] |
Tue, 09 March 1999 08:33 |
hmg
Messages: 40
Registered: March 1999
|
Member |
|
|
Example:
create table tab_to (
col1 number(8),
col2 varchar2(10),
col3 number(3),
col4 varchar2(10) );
create table tab_from (
col1 number(8),
col2 varchar2(10));
insert into tab_from values (1,'first');
insert into tab_from values (2,'second');
insert into tab_from values (3,'third');
commit;
-- Copy Values from tab_from to tab_to
insert into tab_to
select col1, col2, 1, 'dummy' from tab_from;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
