SYNTAXES IN SQL

1.SYNTAX to DROP a TABLE TEMPORARLY:DROP   TABLE   <TABLE_NAME>
2.SYNTAX to RETRIEVE the DROPPED TABLE FROM RECYCLE BIN:

      FLASHBACK   TABLE   <TABLE_NAME>   TO   BEFORE   DROP;

3.SYNTAX TO DROP TABLE PERMANENTLY FROM DATABASE:

      DROP   TABLE   <TABLE_NAME>  PURGE;

4.SYNTAX TO DROP TABLE PERMANENTLY FROM RECYCLEBIN:

      PURGE   TABLE   <TABLE_NAME>;

5.SYNTAX TO DROP ALL THE TABLES AT A TIME FROM RECYCLEBIN:

      PURGE  RECYCLEBIN;

6.SYNTAX TO SEE ALL THE LIST OF TABLES:SELECT * FROM TAB/CAT;

7.SYNTAX TO SEE ALL THE LIST OF TABLES IN RECYCLEBIN:

      SELECT  *  FROM  RECYCLEBIN;

SOME DATA DICTIONARY TABLES USE IN ABOVE SYNTAXES ARE:

                                                                               1.TAB

                                                                               2.CAT

                                                                               3.RECYCLEBIN