SQL> EXPLAIN PLAN FOR
  2  select job from emp where deptno = 20
  3  MINUS ALL
  4  select job from emp where deptno = 10;
Explained.

SQL> select * from table(dbms_xplan.display);

PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
----------------------------------------------------------------------------------------------------
Plan hash value: 261732639
 
---------------------------------------------------------------------------------------------------
| Id  | Operation                            | Name       | Rows  | Bytes | Cost (%CPU)| Time     |
---------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                     |            |     5 |    88 |     6  (34)| 00:00:01 |
|   1 |  MINUS ALL HASH                      |            |       |       |            |          |
|   2 |   TABLE ACCESS BY INDEX ROWID BATCHED| EMP        |     5 |    55 |     2   (0)| 00:00:01 |
|*  3 |    INDEX RANGE SCAN                  | EMP#R#DEPT |     5 |       |     1   (0)| 00:00:01 |
|   4 |   TABLE ACCESS BY INDEX ROWID BATCHED| EMP        |     3 |    33 |     2   (0)| 00:00:01 |
|*  5 |    INDEX RANGE SCAN                  | EMP#R#DEPT |     3 |       |     1   (0)| 00:00:01 |

PLAN_TABLE_OUTPUT                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
----------------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   3 - access("DEPTNO"=20)
   5 - access("DEPTNO"=10)

SQL> --SQL Macros - Scalar Valued Macros: Examples
SQL> --Print Hello <name>
SQL> --A PL/SQL function greet is defined as a scalar SQL Macro that returns the string
SQL> --'Hello, <name>! ' when called from a SQL SELECT statement.
SQL> create or replace function greet(name varchar2 default 'World')
  2  return varchar2 SQL_MACRO(Scalar) is
  3  begin
  4     return q'{ 'Hello, ' || name || '!' }';
  5  end;
  6  /
Function GREET compiled

SQL> SELECT greet from dual;

GREET        
-------------
Hello, World!

SQL> SELECT greet('uncle Bob') from dual;

GREET('UNCLEBOB')
-----------------
Hello, uncle Bob!

SQL> --SQL Macros - Table Valued Macros: Examples
SQL> --The macro function budget computes the amount of each department's budget for a given job. 
SQL> -- It returns the number of employees in each department with the specified job title.
SQL> create or replace function budget(job varchar2) return varchar2 SQL_MACRO is
  2  begin
  3  return q'{
  4  select deptno, sum(sal) AS budget
  5  from emp
  6  where job = budget.job
  7  group by deptno
  8  }';
  9  end;
 10  /

Function BUDGET compiled

SQL> SELECT * FROM budget ('MANAGER');

    DEPTNO     BUDGET
---------- ----------
        20       2975
        30       2850
        10       2450

...
 48  s 
 49  from t where id>=0;

         S
----------
      4001

............
44  )
 45  select 
 46    substr(listagg(n ON OVERFLOW TRUNCATE '>' WITH /*OUT*/ COUNT) WITHIN GROUP (ORDER BY id ),-50 ) s, 
 47    length (listagg(n ON OVERFLOW TRUNCATE '>' WITH /*OUT*/ COUNT) WITHIN GROUP (ORDER BY id ) ) len 
 48  from t where id>=0;

S                                                         LEN
-------------------------------------------------- ----------
------------------------------------------^12>(35)      32744