Re: Silly questions , pl. help me !

Question 1

If the optimizer decide to use the index the result of your query is already sorted. If not (the index is not efficient enough) the result is sorted in order of the appearance of the records in the database. You can force sorting by using the ORDER BY clause in the query or by passing a hint to the query (something very oracle specific, select /*+index (tablename indexname) */ column_list from ...)

Question 2

Yes, the argument must be of the same type as the table.

In article <6fcil0$i11$1_at_nnrp1.dejanews.com>,   sambavan_at_mail.utexas.edu wrote:
>
> Hi
> I'm new to this field, and have few of silly questions
>
> Question 1
>
> If we were to create an index on a table using a perticular column and
 later
> if we were to query the table using that
> index column, will I be able to retrive the data in a sorted order?
>
> Question 2.
>
> Is it possible to pass the PL/SQL table as an argument? If so, what will
 be
> the argument type?
>
> Please help me
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri Mar 27 1998 - 00:00:00 CST