Recent Articles at Exforsys (XML Storage and 11g Analytic Enhancements)

Hope you all are liking the book and my wish that it reaches my readers. I am satisfied with the good response of the readers. The fact that the book features into Oracle magazine (July-August 2012) issue and Oracle ACE newsletter has already overwhelmed me with joy and excitement.

Once again, thanks to Exforsys for publishing my two articles recently.

First article deals with the XML storage concepts in Oracle. The concepts have been theoretically explained within the scope of the article. Read the complete story at the below link

Second article explains the aggregate and analytic enhancements in Oracle 11g database. The article explains the newly inducted LISTAGG and NTH_VALUE functions with examples. Read the complete article at the below link

Hope you all will like it. Do post your feedback, observations or suggestions.

Thanks to all,



Oracle Community: Partner News & Book Beat [Oracle Magazine July/August 2012 issue]

After ACE newsletter, the book makes into Oracle Magazine Book Beat section…great feeling and satisfaction that it reaches its readers…

Community: Partner News & Book Beat.

Win a Free Copy of Packt’s Oracle book

Gladly I would like to announce that Packt publishing has arranged a GiveAway contest for “Oracle Advanced PL/SQL Developer Professional Guide” especially and exclusively for the readers.

It’s easy to participate and walk away with your copy. All you need to do is just comment below the post and win a free copy of Oracle Advanced PL/SQL Developer Professional Guide  . Three lucky winners stand a chance to win an e-copy of the book. Keep reading to find out how you can be one of the Lucky One.

Overview of Oracle Advanced PL/SQL Developer Professional Guide

  • Blitz the 1Z0-146 exam
  • The Oracle Advanced PL/SQL Developer Professional Guide helps you to master the advanced PL/SQL concepts in Oracle 11g. The book is recommended for the Associate level Oracle professionals aspiring for Professional level. The topics covered and demonstrated are in line with the Oracle University prescription for Oracle Professional certification, which justify the version updates to be advanced and not complex.

  • Master the advanced features of PL/SQL to design and optimize code using real-time demonstrations
  • The book aims to cover the advanced features of PL/SQL which are required to design and optimize the PL/SQL code. The recapitulation of PL/SQL programming and advanced features like collections, external procedures, server side result caching, implementing VPD to enforce row level security, handling large objects and SecureFiles build up a concrete platform for a PL/SQL professional. Apart from the programming, the book makes instrumental recommendations on the usage of development tool SQL Developer, employing best practices in database environments and safeguarding the vulnerable areas in PL/SQL code to avoid code injection.

    Read more about this book and download free Sample Chapter:

    How to Enter?
    All you need to do is head on over to this page and look through the product description of the book and drop a line via the comments to this blog post below to let us know what interests you the most about these books. It’s that simple

    The contest is open for a limited period and will close on 3rd July, 2012. Winners will be contacted by email, so ensure that you give real and correct email address when you comment!

    Enjoy reading, bye