IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New Gracious
"Oracle PL/SQL Best Practices", from the same author as "Oracle PL/SQL Programming".
Purchased it earlier today. Fortunately, this is one of the more reasonably priced O'Reilly books. Hard to swallow those $40, $50, and $60 titles. This one at $20 is more to my liking.

9i doesn't seem terribly different to me. There are some additions to the object stuff (inheritance, mainly).
Great. Means the older books should be useful (and cheap).

Just because it was easy, here's the [link|http://www.angelfire.com/tx4/cus/shapes/plsql.html|PL/SQL shapes]. Probably won't be using inheritance and OO soon in PL/SQL, but I did notice several quirks. First, you have to drop all the subtypes manually before you can recompile a base type. Second, the constructor mechanism seems kind of flimsy - relying on declaration order within the types. Third, SELF is optional for accessing member properties and functions but is required for access to the same in the superclass.

TOra.
Looks good. Downloaded but haven't had time to do much exploring.


New OO in Oracle is a pain in 9, a nightmare in 8
The constructors in 8 are required. So if you have an object with say 40 fields, you have a constructor with 40 parameters. We use a perl script to generate the object code from the table schema. :-)

I didn't know that about dropping the subtypes. Nasty. Fortunately we have a SQL loader program that does all that stuff for us.
Regards,

-scott anderson

"Welcome to Rivendell, Mr. Anderson..."
     Oracle questions - (ChrisR) - (8)
         Re: Oracle questions - (admin) - (3)
             Tora looks pretty slick - (SpiceWare)
             Gracious - (ChrisR) - (1)
                 OO in Oracle is a pain in 9, a nightmare in 8 - (admin)
         I'm in a similar boat re: going to Oracle - (Meerkat) - (1)
             Lots of TOADs here too - (admin)
         Application perspective? - (broomberg) - (1)
             HR & Finance Applications - (ChrisR)

Too late, some of us have already taken offense.
153 ms