Results 1 to 2 of 2

Thread: Oracle OBJECTs

  1. #1
    Join Date
    Jan 2002
    Location
    Toronto
    Posts
    21

    Unanswered: Oracle OBJECTs

    Hello,

    Has any one used object-oriented features of PL/SQL?

    I know you can do something like the following.

    CREATE TYPE employee AS OBJECT (...)

    My biggest concern is performance: Do the objects in Oracle negatively affect performance? Anything else I should be aware of?

    Thanks in advance,
    Edward

  2. #2
    Join Date
    Jul 2001
    Location
    Germany
    Posts
    189

    Thumbs up

    Hello Edward,

    when you use TYPE for accessing or handling datas the performance will not change. That´s what we find out in our projects.
    The benefit of using types is accesing complex datas very handy and often with one select.

    Regards

    Manfred Peter
    (Alligator Company)
    http://www.alligatorsql.com

Posting Permissions

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