Oracle9i PL/SQL: A Developers Guide is intended for both intermediate-level Oracle developers who are designing or coding applications in SQL and PL/SQL and for advanced PL/SQL programmers who need to learn new PL/SQL 9ifeatures. In addition to providing developers with detailed coverage of the PL/SQL 9i language itself, author Bulusu Lakshman covers the techniques of using PL/SQL 9i for server-side applications and provides the methodology for implementing robust applications. Lakshman also mentors developers in implementing effective techniques for real-world and code-centric Oracle applications that, in the long run, will save them time and energy. Oracle9i PL/SQL: A Developers Guide is a solid source for the development of Oracle9i PL/SQL applications. Developers incorporating these technologies into new applications and those migrating from earlier versions will both find Lakshman's expert treatment of the topic beneficial.For example, to simulate a complex mathematical function in a way similar to a built-in operator, you can use a ... Traditionally, when you create a function to use within SQL, ita#39;s placed in a package with a RESTRICT REFERENCES PRAGMA. ... If you want to create a reusable component whose status as either an Oracle built-in or a custom package is seamless to the developer (for example, as part of aanbsp;...
|Publisher||:||Apress - 2002-11-14|