Re: Copy a record from 1-table to another

You don't need to bother with PL/SQL. Just create a table with what you want in it with the CTAS syntax, and then insert into the final table. Don't use select *, of course, specify the columns. I'm sure there are more trick ways to do this, but think on it:

SQL> desc t0

 Name                                      Null?    Type
 ----------------------------------------- --------


----------------------------

 C                                                  VARCHAR2(30)

SQL> desc t1
 Name                                      Null?    Type
 ----------------------------------------- --------


----------------------------

 OWNER                                     NOT NULL VARCHAR2(30)
 OBJECT_NAME                               NOT NULL VARCHAR2(30)
 SUBOBJECT_NAME                                     VARCHAR2(30)
 OBJECT_ID                                 NOT NULL NUMBER
 DATA_OBJECT_ID                                     NUMBER
 OBJECT_TYPE                                        VARCHAR2(18)
 CREATED                                   NOT NULL DATE
 LAST_DDL_TIME                             NOT NULL DATE
 TIMESTAMP                                          VARCHAR2(19)
 STATUS                                             VARCHAR2(7)
 TEMPORARY                                          VARCHAR2(1)
 GENERATED                                          VARCHAR2(1)
 SECONDARY                                          VARCHAR2(1)

SQL> create table jjj as select * from t0,t1;

Table created.

SQL> desc jjj

 Name                                      Null?    Type
 ----------------------------------------- --------


----------------------------

 C                                                  VARCHAR2(30)
 OWNER                                     NOT NULL VARCHAR2(30)
 OBJECT_NAME                               NOT NULL VARCHAR2(30)
 SUBOBJECT_NAME                                     VARCHAR2(30)
 OBJECT_ID                                 NOT NULL NUMBER
 DATA_OBJECT_ID                                     NUMBER
 OBJECT_TYPE                                        VARCHAR2(18)
 CREATED                                   NOT NULL DATE
 LAST_DDL_TIME                             NOT NULL DATE
 TIMESTAMP                                          VARCHAR2(19)
 STATUS                                             VARCHAR2(7)
 TEMPORARY                                          VARCHAR2(1)
 GENERATED                                          VARCHAR2(1)
 SECONDARY                                          VARCHAR2(1)

SQL> jg

--
@home.com is bogus.
Hate to admit it, but I'm with Bush on this one:
http://www.signonsandiego.com/uniontrib/20051214/news_1n14congress.html