Mark D Powell wrote:
> Jim Kennedy wrote:
> > "nasa" <nasa.ora@gmail.com> wrote in message
> > news:1158320092.867412.155530@d34g2000cwd.googlegr oups.com...
> > > Like DB2, oracle has Suppress SQL?
> > >
> > > Thx
> > >
> > > Cheers
> > >
> > I don't think so. I have never heard of it.
> > Jim
>
> Nasa, the majority of readers on this board are not going to know what
> Suppress SQL in DB2 is so you should explain what this feature does so
> that board readers have a chance to recongize the nearest Oracle
> equilivents and respond.
>
> If you are trying to suppress the showing of the SQL statement in
> output via SQLPlus you use "set echo off". If you are trying to
> suppress printing query resutls on the screen but just want to spool
> them to a file then look up "set termout off" in the SQLPlus manual.
> Otherwise I have no idea.
>
> HTH -- Mark D Powell --


Hi All,

Suppress SQL - Querying a table by suppressing the rows based on
fields' value.

Eg.,

Table name: tbDemo
Fields are: f1,f2,f3,f4,f5

Query: Select * from tbDemo;

Where tbDemo has reference table to validate criteria before it process
querying. If two different users executing the same Select statement
the results will be different based on user's log-in id.


Cheers,








...