Re: commit for triggers

Perhaps I got it wrong, but, John - are you saying that the entries are part of the rollback, i.e. if the transaction that caused the audit trail entries to be created is rolled back, the audit trail enries are rolled back as well? The auditing entry is NOT part of the transaction, it's created

RE: commit for triggers

Mark - Thanks for the correction. When I looked at what I said about the transaction before a DDL command a second time, I myself wondered if I'd gotten it right. If you've tested it, and the transaction is always committed, I'll take your word for it. Arup - I don't normally use Oracle's

is this possible ?

i hv to write an sql query in which i hv to fetch all the tables frm the database having a column say EMPNO and where the value of this empno column is say 9 and this should be thru a single sql query is this possible ? Thanks and Regds, Rohan

Re: is this possible ?

What are you trying to get? Column values or (TABLE,COLUMN) combination? You could probably use a function like this: create or replace function trickery(T varchar2,C varchar2, V number) return number deterministic as qry varchar2(2048); cnt number:=0; begin qry='select count(*) from '||T||' where

<    1   2