Long Vs Lob Data Type

What is difference between LONG and LOB data types?

Differences between LONG and LOB data type are listed below:
LOB
 1) The maximum size is 4GB.
 2) LOBs (except NCLOB) can be attributes of an object type.
 3) LOBs support random access to data.
 4) Multiple LOB columns per table or LOB attributes in an object type.

LONG
 1) The maximum size is 2GB.
 2) LONGs cannot.
 3) LONGs support only sequential access.
 4) Only one LONG column was allowed in a table
at
Labels:

DBMS_XPLAN

One more way we can see the Explain Plan by using DBMS_XPLAN package. DBMS_XPLAN automatically queries the last plan in PLAN_TABLE. It u...

  • Difference Between Collection and Record
    What is the difference between Collection and Records? Collection Record The internal components always have the same data type, ...
  • DBMS_XPLAN.DISPLAY_CURSOR
    DBMS_XPLAN.DISPLAY_CURSOR show actual execution plan from dynamic performance views. DBMS_XPLAN:   The DBMS_XPLAN package provides an eas...
  • Question For Collections
    PL/SQL Interview Question  for Collections. What is Collection? How many type of collection? Why or when we will use collection? What i...