Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Stored Outlines For Queries In PL/SQL Stored Procs
On 5 Dec 2002 05:54:29 -0800, yitbsal_at_yahoo.com (Salaam Yitbarek)
wrote:
>Hi,
>
>Oracle 8.1.7.3
>SunOS 5.7
>
>I would like to know how to create stored outlines for some queries I
>have in stored procedures. The queries may be explicit or implicit.
>For example:
>
>DECLARE
> TYPE VectorId_Type IS TABLE OF
> cii_array_vector.vector_id%TYPE INDEX BY NATURAL;
> var_VectorIds VectorId_Type;
> varcur_datapoint cur_datapoint%ROWTYPE;
>
> CURSOR cur_datapoint IS
> SELECT b.*
> FROM ciiw_array_vector a, datapoint b
> WHERE a.array_id = ArrayId_in
> AND a.vector_id = b.vector_id
> AND b.version = pdII.cWorkingVersion
> AND a.vector_id NOT IN (SELECT vector_id FROM matrix_vector);
>
>BEGIN
> FOR varcur_datapoint IN cur_datapoint LOOP
> ...
> END LOOP;
>
> SELECT ciiw_array_vector.vector_id
> BULK COLLECT INTO var_VectorIds
> FROM ciiw_array_vector, vector
> WHERE ciiw_array_vector.array_id = ArrayId_in
> AND ciiw_array_vector.vector_id = vector.vector_id
> AND vector.version = pdII.cWorkingVersion;
>END;
>
>Thanks,
>Salaam
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76992/outlines.htm#13165
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address Received on Thu Dec 05 2002 - 10:11:07 CST