DROP TABLE: Simple

View All Scripts Login to Run Script

Script Name DROP TABLE: Simple
Description Create a table, insert data into it, and then drop the table.
Area SQL General / SQL Query
Contributor Oracle
Created Monday October 05, 2015

Statement 1

CREATE TABLE print_media_ad_h  
    ( product_id        NUMBER(6)  
    , ad_id             NUMBER(6)  
    , ad_composite      CLOB  
    , ad_sourcetext     CLOB  
    , ad_finaltext      CLOB  
     )

Table created.

Statement 2

INSERT INTO print_media_ad_h (product_id, ad_id) VALUES (1, 101)

1 row(s) inserted.

Statement 3

select * from print_media_ad_h

 
PRODUCT_ID AD_ID AD_COMPOSITE AD_SOURCETEXT AD_FINALTEXT
1 101 [unsupported data type]  -  -

PRODUCT_ID	AD_ID	AD_COMPOSITE	AD_SOURCETEXT	AD_FINALTEXT
1	101	[unsupported data type]	-	-

Statement 4

drop TABLE print_media_ad_h

Table dropped.

Statement 5

INSERT INTO print_media_ad_h (product_id, ad_id) VALUES (1, 101)

1 row(s) inserted.

Statement 6

select * from print_media_ad_h

 
PRODUCT_ID AD_ID AD_COMPOSITE AD_SOURCETEXT AD_FINALTEXT
1 101  -  -  -

PRODUCT_ID	AD_ID	AD_COMPOSITE	AD_SOURCETEXT	AD_FINALTEXT
1	101	-	-	-

Statement 7

drop TABLE print_media_ad_h

Table dropped.

Statement 8

select * from print_media_ad_h

 
PRODUCT_ID AD_ID AD_COMPOSITE AD_SOURCETEXT AD_FINALTEXT
1 101  -  -  -

PRODUCT_ID	AD_ID	AD_COMPOSITE	AD_SOURCETEXT	AD_FINALTEXT
1	101	-	-	-

Additional Information

Database on OTN SQL and PL/SQL Discussion forums
Oracle Database
Download Oracle Database