I'm creating an AFTER CREATE ddl trigger:
CREATE OR REPLACE TRIGGER after_create_trg
after create
on lwdev.schema
begin
if sys.dictionary_obj_type='TABLE'
OR sys.dictionary_obj_type='SEQUENCE'
then
begin
dbms_output.put_line ('TEST');
:08 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:AFTER CREATE trigger help, please
I'm creating an AFTER CREATE ddl trigger:
CREATE OR REPLACE TRIGGER after_create_trg
after create
on lwdev.schema
:08 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:AFTER CREATE trigger help, please
I'm creating an AFTER CREATE ddl trigger:
CREATE OR REPLACE TRIGGER after_create_trg
after create
on lwdev.schema
CREATE trigger help, please
I'm creating an AFTER CREATE ddl trigger:
CREATE OR REPLACE TRIGGER after_create_trg
after create
on lwdev.schema
begin
if sys.dictionary_obj_type='TABLE'
OR sys.dictionary_obj_type='SEQUENCE'
then
begin
PROTECTED]' [EMAIL PROTECTED]
cc:
Subject:RE: AFTER CREATE trigger help, please
Actually...
SQL create or replace trigger test
2 after insert on test_table
3 begin
4 dbms_output.put_line ('Hello from trigger!!!');
5 end;
6 /
Trigger created.
Elapsed: 00:00
To: '[EMAIL PROTECTED]' [EMAIL PROTECTED],
'[EMAIL PROTECTED]' [EMAIL PROTECTED],
'[EMAIL PROTECTED]' [EMAIL PROTECTED]
cc:
Subject:RE: AFTER CREATE trigger help, please
Actually...
SQL create or replace trigger test
2 after insert on test_table
3 begin
Dear DBA Gurus,
I have a table with two fields name and status. What I want to do is once
the current system date rolls over from 30th to 31st the status should be
entered as closed other wise from 1st to 30th the status should be entered
as open. How do I do this using trigger or any