Drop Command (DDL) in SQL Oracle With Implementation

 Drop Command (DDL) in SQL Oracle With Implementation

For Explanation Watch Video::

Drop Command

Used to delete  table (rows X columns)

EX:::

1)Create table

SQL> create table emp01(fname varchar2(15),sal Number(10));

Table created.

2)Describe table

SQL> desc emp01;

 Name                                      Null?    Type

 ----------------------------------------- -------- ----------------------------

 FNAME                                              VARCHAR2(15)

 SAL                                                NUMBER(10)

SQL> select * from emp01;

no rows selected

3)Insert values into table

SQL> insert into emp01 values('smith',500000);

1 row created.

4)Drop the table

SQL> drop table emp01;

Table dropped.

5)TO see columns deleted again describe table

SQL> desc emp01;

ERROR:

ORA-04043: object emp01 does not exist

6_to see data deleted

SQL> select * from emp01;

select * from emp01

              *

ERROR at line 1:

ORA-00942: table or view does not exist