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: PL/SQL Cursor : Is this the best way?

Re: PL/SQL Cursor : Is this the best way?

From: Altitude <rawatd_at_logica.com>
Date: Fri, 18 Jun 1999 10:09:19 +0100
Message-ID: <376A0CBF.A96AD660@logica.com>


Thanks for the help.

Altitude wrote:

> Hi,
>
> I'm writing an integrity checker for our system at work which basically
> scans the database tables for any discrepant pieces of data that should
> not be there. Anyway, there's one rule which is as follows :
>
> (I've changed the names of tables and columns)
>
> For all names in table_a whose status is 'P', a record should exist in
> table_b. I want a list of all names and corresponding status which DO
> NOT meet this rule.
> I've come up with the following cursor in PL/SQL (Oracle 7.3.3) :
>
> CURSOR rule_cursor IS
> SELECT a.name, a.status
> FROM table_a a
> WHERE a.status = 'P'
> AND a.name NOT IN
> (SELECT b.name
> FROM table_a a,
> table_b b
> WHERE a.name = b.name);
>
> My question is this ... is there an easier, more efficient way of doing
> this? I'm fairly new to PL/SQL, and to me, it seems an awful amount of
> work to be done for something which seems straight forward. I've tried
> more "simpler" SELECTS, but all come back with incorrect results.
>
> Any help will be greatly appreciated.
> Thanks in advance.
Received on Fri Jun 18 1999 - 04:09:19 CDT

Original text of this message

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