Book Image

Oracle APEX 4.2 Reporting

By : Vishal Pathak
Book Image

Oracle APEX 4.2 Reporting

By: Vishal Pathak

Overview of this book

<p>The biggest challenge in the reporting world is to reduce the overall project cost by picking a tool that minimizes effort and time and to ensure an enriching user experience. Oracle APEX, a 4GL technology, with its unique features such as low implementation time and flexibility, aids us in creating performance-tuned applications with minimum hassle. <br /><br />"Oracle APEX 4.2 Reporting" is a unique blend of fascinating solutions and intriguing integrations which gives you a 360 degree view of the reporting solutions available to you on the market. It showcases advanced APEX solutions that will empower you to fulfill all kinds of tricky requirements of the reporting world. Live applications support the discussions in the text, enabling you to perform your own experiments on prebuilt applications to take your learning to new heights.<br /><br />"Oracle APEX 4.2 Reporting" will help you build a well-founded understanding of Oracle APEX along with most of the reporting technologies used today. It is written with the idea of being as practical as possible so that you reap the benefits from day one.<br /><br />Starting with a brief introduction to the architecture of APEX and installation to enable you to see the applications provided with the book in action, we then move on to the uses of Classic and Interactive reports and explore the advanced features of APEX. We will also explore the most widely used reporting solutions, which is then followed by a brief discussion on BPEL, which is like the glue that can gel any number of tools together. Oracle 4.2 APEX Reporting concludes with several ways of tuning an APEX application, as good performance is the heart of customer satisfaction.</p>
Table of Contents (17 chapters)
Oracle APEX 4.2 Reporting
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

A pessimist's view of APEX


Let's check out some of the most valid criticisms in the following sections.

Cap of 200 page items

As discussed in the Decoding the APEX page submissions section previously, only 200 page items are possible on an APEX page.

SQL Injection

This works like a charm. The only problem is that the charm does not work in your favor.

SQL Injection is PL/SQL hacking and can be stopped to a large extent if proper coding practices are followed. The attack is easy if your PL/SQL code contains dynamic SQL, and the code is generated by concatenating variables to the dynamic SQL string. Again, if your code assumes some implicit conversions and formats, then an experienced hacker can change those assumed formats and demolish your security like it was a deck of cards.

SQL Injection is of two types. Refer to SQL Injection section of the Appendix to see a discussion about both of these types with a working example of one of the types of SQL Injection and various ways to combat SQL Injection.

Cross-site scripting

Cross-site scripting is an attack by which hackers can bypass access controls such as same origin policy of the target server, and hence access sensitive data using client-side scripting such as JavaScript. Check out the Cross Site Scripting section of the Appendix to see the same origin policy in action. You will find a piece of code to use client-side scripting to access vital web resources of the same domain. Cross-site scripting also uses similar code but the attack is from a different domain.