-
Hi :
I have a table that has 5 fields of which the 5th field is status and is default 'ACTIVE' when inserted. But when someone deletes, I want the row to be there and make it inactive for status. I hope I am clear.
How would you write the trigger..
SQL> desc tbl_applist
Name Null? Type
----------------------------------------- -------- ----------------------------
APPLICATION_ID NOT NULL VARCHAR2(10)
BWPERSEC NUMBER(5)
APPLICATION_IP VARCHAR2(23)
APPLICATION_PORT NUMBER(5)
STATUS VARCHAR2(10)
SQL> select * from tbl_applist;
APPLICATIO BWPERSEC APPLICATION_IP APPLICATION_PORT STATUS
---------- ---------- ----------------------- ---------------- ----------
3 2 ACTIVE
4 2 ACTIVE
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|