How to check whether Column of BLOB is null or not null?
wyfwongNov 6 2006 — edited Nov 6 2006I have create the following schema to store documents on the database in DOC column of the table BIN_DOCS.
CREATE TABLE BIN_DOCS
( DOC_ID NUMBER(5) PRIMARY KEY,
NAME VARCHAR2(128),
DOC BLOB);
I have created a Form to upload and download DOC from the table BIN_DOCS. Some DOC has nothing in BLOB. How can I detect DOC is null or not null?
If I want to insert a new document file into the table BIN_DOCS using SQL Plus, e.g. a file called "abc.doc" into DOC of BIN_DOCS, what is the INSERT statement.
If I want to download the document file using SQL Plus, what is the corresponding command?
Thanks in advance.