In end, results matter: gimme the data, quickly and efficiently. However, there are lots of improvements both in pl/sql and in the sql language that are tremendously helpful in writing pl/sql, particularly with objects, analytical functions (partition by ), and with the introduction of ANSI sql-which old timers hated! I don't remember all the versions, so some of this was clearly part of 10g, but you get the point. Much of the core language is the same, so if you are now writing stuff for 8i or 10g then the basics are the same (logic, cursors, loops). Among other things, there is a version by version breakdown of the functions available per release (google it it's like 2k pages), so you can see what's been introduced since 8i or 10g (not clear if you are on both or just 8i). If the goal is to learn pl/sql, then you should get a copy of Steven Feuerstein's book, which is probably the best pl/sql book available.
0 kommentar(er)
