Nested Records in PL/SQL
From: Max <max_stout_at_hotmail.com>
Date: Tue, 05 Sep 2000 10:22:55 -0400
Message-ID: <39B501BF.5388CDD0_at_hotmail.com>
Date: Tue, 05 Sep 2000 10:22:55 -0400
Message-ID: <39B501BF.5388CDD0_at_hotmail.com>
I am writing a procedure. I select all the fields from a temporary Oracle table. If some of the fields are different from the ones already in the production database, then I insert a new record, otherwise I just overwrite the other fields (the ones that do not require creation of a new record).
What I would like to do is have my record defined in 3 different ways: the whole record, the fields requiring creation of a new record and the other fields. Can this be done using the %TYPE format?
Thanks. Received on Tue Sep 05 2000 - 16:22:55 CEST