Oracle PL/SQL Programming

Steven Feuerstein, Bill Pribyl

Mentioned 2

This book is the definitive reference on PL/SQL, considered throughout the database community to be the best Oracle programming book available. Like its predecessors, this fifth edition of Oracle PL/SQL Programming covers language fundamentals, advanced coding techniques, and best practices for using Oracle's powerful procedural language. Thoroughly updated for Oracle Database 11g Release 2, this edition reveals new PL/SQL features and provides extensive code samples, ranging from simple examples to complex and complete applications, in the book and on the companion website. This indispensable reference for both novices and experienced Oracle programmers will help you: Get PL/SQL programs up and running quickly, with clear instructions for executing, tracing, testing, debugging, and managing PL/SQL code Optimize PL/SQL performance with the aid of a brand-new chapter in the fifth edition Explore datatypes, conditional and sequential control statements, loops, exception handling, security features, globalization and localization issues, and the PL/SQL architecture Understand and use new Oracle Database 11g features, including the edition-based redefinition capability, the function result cache, the new CONTINUE statement, fine-grained dependency tracking, sequences in PL/SQL expressions, supertype invocation from subtypes, and enhancements to native compilation, triggers, and dynamic SQL Use new Oracle Database 11g tools and techniques such as PL/Scope, the PL/SQL hierarchical profiler, and the SecureFiles technology for large objects Build modular PL/SQL applications using procedures, functions, triggers, and packages

More on

Mentioned in questions and answers.

Are there any Manuals available,which cater to the needs of SQL and PLSQL developers in the industry. I tried to search,but I found nothing like that of of equal to PHP's manual quality in .chm Format.

So, can anyone give me or share their useful material direct links to PLSQL and SQL manuals in .chm format, for Quick development and learning along the way.

In terms of learning SQL from a beginners standpoint I cannot recommend "Learning SQL" by O'Reilly enough.

Another great learning tool / reference is W3 School's SQL tutorials found here:

And for PLSQL look no further then "Oracle PL/SQL Programming".

Please suggest some Freeware both for Client and server side. This is to learn every thing about PL/SQL..

You can use Oracle XE database and Oracle SQL Developer. Both are free.
Add a good book on PL/SQL. I'd suggest Steven's book.

Oracle products can be used for learning for free.

Realated tags