Home » RDBMS Server » Server Administration » Re: Help please!!!!!
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;
Previous Topic: Re: Selecting numerics from an alphanumeric field
Next Topic: Re: sql+
Goto Forum:
  


Current Time: Fri Mar 29 00:30:15 CDT 2024