Oracle Indexes - August
28, 2008 at 15:00 PM by Amit Satpute
What is INDEX_BY_BINARY_INTEGER?
Answer
BINARY_INTEGER is a PL/SQL data type defined as a subtype of INTEGER
in the STANDARD package and is used for storing signed integers.
It can take values between -2,147,483,647 and 2,147,483,647
Oracle Indexes - Nov 17, 2008 at 15:00 PM by Nishant Kunmar
What are the objects in oracle?
Answer - Table, Views, Index, Synonym and Sequence are the
objects of oracle.
What is an Index?
Answer - Index in oracle helps to trace the information faster
just like an index in a book. Index entries keep information about the columns
that are part of the index in a sorted order. If you query data with an index,
the data retrieval is much faster.
|