DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Object_relational features

  1. #1
    Join Date
    Jan 2004
    Posts
    9

    Object_relational features

    I want to try the object-relational features with Oracle 9i. But I am not sure what are the gains and losses. Who has ever been working on such issues, please advise me.

    Thank you.

  2. #2
    Join Date
    Jan 2004
    Posts
    15
    You can create object types, object tables, methods
    and all that stuff you must be familiar with if ever worked with Object Oriented methodology...

    Foe example, a very simple example: (dont remember the sintaxis exactly)
    create type address_type
    street varchar2(39),
    num number(2),
    zip number(5)

    after that,
    create table employee
    ( name varchar2(30),
    salary numbre(18,2),
    adreess address_type)

    you can use your address_type uniformly within your whole database.
    This is a very simple example and suggest dont pay atention to the sintax.
    Best luck

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width