<<Previous Next>>
Oracle - What is the BFILE
datatypes? - Feb 07, 2010 at 14:20 PM by Shuchi
Gauri
What is the BFILE
datatypes?
It refers to an external binary file and its
size is limited by the operating
system.
Oracle - What
is the BFILE datatypes? - April 10, 2009
at 11:00 AM
What is the BFILE
datatypes?
The BFILE datatype is used to store
unstructured binary data outside the database. The column of BFILE
type stores file locator that points the OS file which actually
stores data.
Define Bfile datatypes.
Oracle provides Bfile datatypes to store unstructured binary
data. The actual data is stored outside the database in the
operating system files. A bfile column stores file locator that
points to an external file containing data. Bfiles are read-only,
one can’t modify them.
Also read
Explain the differences between char and varchar2 data types,
Explain BLOB, CLOB, NCLOB and BFILE, Explain ROWID in oracle, What
is a LOB data type?...........
How do you increase the performance of %LIKE operator?, What is a
standby database? Difference between Physical and logical standby
databases, What is Cache Fusion Technology?, What is simple
replication and advance replication?.............
Both CLOB and NCLOB are used to store huge character data in the
database, CLOBs store single-byte character set data.............
|