Are you limited by the export functionality of DDE or export templates and looking for a more powerful way to do exports? Do you ever look at custom pages and wonder what the tlist_sql stuff is and how to modify it? This session will introduce you to SQL, also known as Structured Query Language. You'll learn how to use it with Oracle SQL Developer to get around the limits of PS exports, and get a basic understanding of how it works for use in custom pages and reporting engine reports.
We will cover SQL from bottom to top:
What is SQL?
Oracle SQL Developer/Navicat
What tables are
The SELECT statement
AND and OR
ORDER BY clause
String functions (concat, substr, search)
IS [NOT] NULL operator
Other functions (case, nvl, len)
Aggregation (GROUP BY and sum, avg, max, min functions)