Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: PL/SQL Question after migrating from 7.3.4 to 8.1.7

Re: PL/SQL Question after migrating from 7.3.4 to 8.1.7

From: <JRicard982_at_aol.com>
Date: Fri, 27 Jul 2001 11:47:40 -0700
Message-ID: <F001.00357A0E.20010727110958@fatcity.com>

Deen,

If you want a table with the structure of a row in your uc9_correspondence, use THE '%ROWTYPE'as follows:

   TYPE tb_uc9_corres_type IS TABLE OF uc9_correspondence%ROWTYPE

        INDEX BY BINARY_INTEGER; Rick
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: JRicard982_at_aol.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Jul 27 2001 - 13:47:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US