Re: PL/SQL functions in SQL where clauses

From: Michael Bialik <bialik_at_isdn.net.il>
Date: 17 Feb 2002 11:31:23 -0800
Message-ID: <969f8022.0202171131.5df971aa_at_posting.google.com>

AFAIK the "AND" conditions are processed Bottom-Up (right to left). Can you try changing the order in WHERE: select <something>
from <some tables>
where permission_p(:current_user_id, object_id, 'access')='t' AND <some where clauses>;

HTH. Michael Received on Sun Feb 17 2002 - 20:31:23 CET

This message: [ Message body ]
Next message: Keld Nielsen: "Re: PL/SQL functions in SQL where clauses"
Previous message: Ashish Mittal: "Re: how can i find out the second maximum value from a table by sql"
Maybe in reply to: Dirk Gomez: "PL/SQL functions in SQL where clauses"
Next in thread: Keld Nielsen: "Re: PL/SQL functions in SQL where clauses"
Reply: Keld Nielsen: "Re: PL/SQL functions in SQL where clauses"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message