System Packages Oracle PLSQL Tutorial

SQL>
SQL> create table employee_job (
  2  id                             number                         not null,
  3  worker_id                      number                         not null,
  4  logical_workplace_id           number                         not null,
  5  active_date                    date          default SYSDATE  not null,
  6  inactive_date                  date )
  7  tablespace USERS pctfree 20
  8  storage (initial 10K next 10K pctincrease 0);
Table created.
SQL>
SQL> execute SYS.DBMS_STATS.gather_table_stats(USER, 'employee_job');
PL/SQL procedure successfully completed.
SQL>
SQL> drop table employee_job;
Table dropped.