Hi,
I have 2 tables defined exactly the same...is there a way I can use
the %rowtype to facilitate this process?
- define record type
--
R_ccc_1 CCC_1%ROWTYPE;
--
- insert this customer in to CCC_2 from CCC_1
--
SELECT(*) -- I need all the fields from here can I cheat and
not put all fields in a list?
INTO
R_ccc_1
from CCC_1
WHERE CCC_1.CUSTOMER_NUMBER = V_CUST_NUMBER;
--
- then insert in to the ccc_2 table
--
INSERT INTO
CCC_2
VALUES
(R_CCC_1); -- can this be done?
Received on Wed Sep 10 2003 - 12:42:56 CDT
