Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Stored Outlines For Queries In PL/SQL Stored Procs

Re: Stored Outlines For Queries In PL/SQL Stored Procs

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Thu, 05 Dec 2002 17:11:07 +0100
Message-ID: <lguuuukpmfjvuu62ashub9ot8tqurp2oks@4ax.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US