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?
ODBC
Oracle SQL Developer/Navicat
Data types
What tables are
The SELECT statement
WHERE clause
AND and OR
ORDER BY clause
DISTINCT
String functions (concat, substr, search)
IS [NOT] NULL operator
Math functions
Other functions (case, nvl, len)
LIKE operator
IN operator
Dates
INNER JOIN
OUTER JOIN
Subqueries
Aggregation (GROUP BY and sum, avg, max, min functions)
HAVING clause
LISTAGG
