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

Oracle data types

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?...........

Oracle DBA

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?.............

Define CLOB and NCLOB datatypes.

Both CLOB and NCLOB are used to store huge character data in the database, CLOBs store single-byte character set data.............

<<Previous  Next>>

Write your comment - Share Knowledge and Experience Discussion Board Oracle, PL/SQL Developer jobs needed at Chennai location Currently i am looking for Oracle, PL/SQL jobs. If anything is available then you will update/call me back through Telephonic. Thanks. Fathima 07-25-2018 05:39 AM