Re: filter on return results

Daniel Morgan wrote:
> Jean-Max Reymond wrote:
>
>

>>to enforce confidentiality of the informations in my oracle database, I
>>am looking for a way to return informations ONLY if conditions are OK.
>>for example, on a SELECT request, return rows only if there at least 3
>>rows selected, otherise nothing is returned.
>>request are going from ODBc connections or sqlplus tool.

Oracle 8 or 9

> 2. The front-end software application

no specifics applications. it may be ODBC drivers (Businness Object, Cognos, ...) sqlplus or API's

> 3. Whether the SELECTs are direct to tables or to procedures

The Select's are direct to tables.
the most useful solution will be a "post SELECT" trigger to filter returned rows but unfortunately, it seems that this feature does not exist. Another solution will be to overrule the original SELECT with a customized SELECT but is it possible ?

>
> That should be enough to give us some kind of hint. Also include a sample
> of one of the SQL statements that might reasonably be issued and need to
> meet this criterion.
>
> Daniel Morgan
>

for example:

SELECT username from users where username like 'jmax%' return normally 2 rows
SELECT username from users return normally 100 users

with my modified SELECT, I want that
SELECT username from users where username like 'jmax%' return 0 rows because my SELECT does not return any rows if the numer of rows < 5 rows SELECT username from users return 100 users: no filter Received on Thu Jul 18 2002 - 04:37:09 CDT