Re: [PL/SQL] Objects

From: bhogak <bhogak_no_spam_at_comcast.net>
Date: Tue, 12 Aug 2003 23:33:21 GMT
Message-ID: <5Pe_a.130893$YN5.87477@sccrnsc01>

Object Types are perfect for XML output from the database, especially if you have multi-level nested elements. I also find it useful when I want to store same type of information, say Address information in different tables. This way, if I need to increase the Street Name from VARCHAR2(60) to VARCHAR2(80), it is easy to modify the type definition instead of changing it in all the tables.

It is true that it is little different to query object tables, but you can create a view on top of this table to flatten the attributes. Also note that certain tools like free TOAD (atleast the version I have) do not support Object Types.

hth
bhogak

"gszalach" <member34649_at_dbforums.com> wrote in message news:3228075.1060674884_at_dbforums.com...
>
> Hi,
>
> I consider to use object types in my database. I would like to know
> what advantages and disadvantages of using objects instead of using
> some more columns are. My object would be a group of three fields
> without any methods.
>
> Thank you for any ideas.
> Szalas
>
> --
> Posted via http://dbforums.com
Received on Tue Aug 12 2003 - 18:33:21 CDT