Re: How to save PL/SQL structure data into ORACLE DB

From: Ken-ming Wang <kenming_at_email.gcn.net.tw>
Date: 1997/11/24
Message-ID: <347932fb.24520378@news.seed.net.tw>#1/1

On Sun, 23 Nov 1997 15:25:56 -0500, "Breuss Rene" <106564.41_at_compuserve.com> wrote:

>Is there a way, to store a complex user defined structure datatype into one
>table-column or is there only the way to store each single structure
>element in a separate column ?

For PL/SQL , you can use composite data type, like pl/sql table or record.
For SQL, you just only use the scalar data type.

Slight Heart, Thousand Miles. Ken-ming Wang ***
MCSE & CNE/CNI Certified Sys. Engineer *** FROM
LGS 3d*/Administrator On LGS Go Server ***
Welcome to LGS. http://www.lgs.hinet.net *** R.O.C

Received on Mon Nov 24 1997 - 00:00:00 CST