Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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