Category Archives: Beyond the basic select statement
Beyond the basic select statement: Using the WITH clause inline SUBQUERY
We looked at the with statement with embedded PL/SQL, now lets look at another use of the with statement. This time we are going to use it with embedded subqueries. Query A This query searches a stocks table, returns the … Continue reading
Beyond the basic select statement: Using the WITH clause inline PL/SQL
For years I used the basic select statement: SELECT A.C1, A.C2, B.C1, B.C2, <…> FROM TAB1 A, TAB2 B WHERE A.C1 = B.C1; Sometimes this basic select statement would not answer my question. You can make a select statement quite … Continue reading