DBMB_LOB

 

CREATE TABLE view_sites_info     
(
        site_id NUMBER(3),
       audio BLOB DEFAULT   empty_blob(),
       document CLOB DEFAULT   empty_clob(),
       video_file BFILE DEFAULT   NULL,
       CONSTRAINT PK_TAB_view_sites_info PRIMARY KEY (site_id)     
)