Re: Suppress SQL

Mark D Powell wrote:
> Jim Kennedy wrote:
> > "nasa" <nasa.ora_at_gmail.com> wrote in message
> > news:1158320092.867412.155530_at_d34g2000cwd.googlegroups.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,

.. Received on Fri Sep 15 2006 - 08:48:15 CDT