I have doubt regarding ref cursor and plsql tables ?
these are the two topics which i could not get into my mind ? i have read and
searched for many materials and books ? non of them could easily put it into my brain ? can someone help me with simple explanation with simple example ? how and where these topics could be used ?
actual to begin with, i have no idea of object types in oracle ?
how could i imagine
for example :-
type xyz as record of tablename%rowtype
type xxx as table of tablename indexed by binary_integer
Why doesn't the Oracle optimizer use my index?
Querying too much data
Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table.
So, the obvious side…
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.