SQL: Structured Query Language - Oracle 10g Database Administration Concepts and Implementation Made Simple - page 50

The Binary Large Object is a field that
holds unstructured binary data. Max 4 GB.

BLOB

The Character Large Object is a field that
holds single byte character data. Max 4
GB.

CLOB

An external binary file. The maximum size
for this file is 4 GB. The size is also limited
by the operating system.

BFILE

Base 64 string representing the unique
address of a record/row in the table.

ROWID

Example:

CREATE TABLE album(
id NUMBER(6),
title VARCHAR2(100),
artist VARCHAR2(100),
activity DATE
);

Once you write this statement in SQL*Plus or iSQL after
logging in, a table with the name “album” will get created having
four columns viz., id, title, artist and activity. In the last column
we will insert the date when the record got submitted. You can
create as many tables you want and they all will be under your
schema. No one else beside DBA can have access to them unless
you or DBA grant access explicitly.

Example:

CREATE TABLE emp_dept
AS SELECT *
FROM scott.emp
WHERE deptno = 10;

This is another way of creating table. Not only the structure but
the data will get copied too in the emp_dept table.