How to get nth record from index by table?

vadivelraju

• Feb 17th, 2019

We can get like collection(n).column [Ex. emp(3).empno]

Answer Question  Select Best Answer

apiplani

 Profile Answers by apiplani Questions by apiplani

• Feb 14th, 2006

There are a number of things you can add to checklist while setting up DBMS and the checklist will depend on which kind of organisation is it. I am assuming you are a DBA setting up DBMS for software ...

Answer Question  Select Best Answer

DIPTENDU HUI

• Jan 28th, 2006

For Indexes you can use :DBA_INDEXESALL_INDEXESUSER_INDEXESFor Constraint you can use :DBA_CONSTRAINTSALL_CONSTRAINTSUSER_CONSTRAINTSFor index upon which table and which column you can query on:DBA_CONS_COLUMNSALL_CONS_COLUMNSUSER_CONS_COLUMNS

Answer Question  Select Best Answer

Kajal Pancholi

• Mar 16th, 2006

I think that this is not possible in the ORACLE. 

Answer Question  Select Best Answer

opbang

 Profile Answers by opbang Questions by opbang

• Sep 23rd, 2006

A  Hash index stores key value pairs based on a pseudo randomizing function called hash functionA B+- Tree is a balanced tree whose leaves contain a sequence of key pointer pairs.- Use a hash index for point queries only. Use a B- Tree if multipoint queries or range queries are used.

Answer Question  Select Best Answer