Like DB2, oracle has Suppress SQL?

Thx

Cheers

"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 schrieb:
> Like DB2, oracle has Suppress SQL?
What is "suppress sql"?
Maybe it's just called different for oracle databases?

Lots of Greetings!
Volker
--
For email replies, please substitute the obvious.

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 --

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,








...

nasa wrote:
> 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,
>
>
>
>
>
>
>
>
> ..

Oracle has VPD (Virtual Private Database) or Fine Grained Access
control, allowing you to set up a policy which is automagically
appended to every statement. Whether you filter on the users login-id
or attributes can be set in the policy.

--
Sybrand Bakker
Senior Oracle DBA

nasa wrote:
> 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.
>

What do you mean by "reference table".

It sounds like you are perhaps talking about a feature in oracle
implemented by VPD ( virtual private database ).

Why don't you take a look at the 10g concepts manual (
http://tahiti.oracle.com ) and do some reading there then come back to
us with specific questions.

"nasa" <nasa.ora@gmail.com> wrote in message
news:1158328095.760047.201470@m73g2000cwd.googlegr oups.com...
>
> 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,

You could look at the docs for fine grained access control. That sounds
like the closest feature. It allows you to set up statements to add to the
where clause depending upon who loggs in. (so select * from mytable becomes
select * from mytable where ....)
Jim

nasa wrote:
> Like DB2, oracle has Suppress SQL?
>
> Thx
>
> Cheers

I am not aware of anything in DB2 named "Suppress SQL."
Google isn't either.

What is it you are referring to.
--
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group

DA Morgan wrote:
> nasa wrote:
>> Like DB2, oracle has Suppress SQL?
>>
>> Thx
>>
>> Cheers
>
> I am not aware of anything in DB2 named "Suppress SQL."
> Google isn't either.
>
> What is it you are referring to.

Maybe Serge can lend us a hand.

Cheers,
Brian

--
================================================== =================

Brian Peasland
dba@nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown