oplaTech About Teaching Archive
Oplatek's external memory

Oracle cheat sheet



  1. List tables


    You should set the column width

    COL table_name FORMAT a30;
    COL table_type FORMAT a30;

    Show the tables

    SELECT * FROM cat;



  2. imple table with primary key

    CREATE TABLE test (keydate smallint NOT NULL, PRIMARY KEY (keydate));




  3. Show schema of a table
    desc advert_date;




  4. set autotrace traceonly explain