how to include record deleted date into trigger? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

how to include record deleted date into trigger?

how to include record deleted date into trigger?# Database - 数据库

h*r2002-04-29 07:04

1 楼

Professor's requirements: Create a database trigger that stores deleted
customer records in an archive table. The archive table should also include
the DATE the customer record was deleted from the customer table.
I know how to create the trigger,but don't know how to include the date the
customer record was deleted. Anyone can give me some hlep? Thanks
BEFORE DELETE ON borrower_t
FOR EACH ROW
BEGIN
INSERT INTO borrowerarchive
VALUES(:Old.borrower_ssn, :Old.Borrower_Firstname, :Old.Borrower_Last

b*e2002-04-29 07:04

2 楼

why don't you just create a column in the archive table that has
default set to sysdate?

【在 h****r 的大作中提到】

: Professor's requirements: Create a database trigger that stores deleted
: customer records in an archive table. The archive table should also include
: the DATE the customer record was deleted from the customer table.
: I know how to create the trigger,but don't know how to include the date the
: customer record was deleted. Anyone can give me some hlep? Thanks
: BEFORE DELETE ON borrower_t
: FOR EACH ROW
: BEGIN
: INSERT INTO borrowerarchive
: VALUES(:Old.borrower_ssn, :Old.Borrower_Firstname, :Old.Borrower_Last

h*r2002-04-29 07:04

3 楼

could you give me a simple sample of how to do that. sorry newer to oracle.
thanks

include
the

【在 b****e 的大作中提到】

: why don't you just create a column in the archive table that has
: default set to sysdate?

b*e2002-04-29 07:04

4 楼

alter table borrowerarchive add (delete_date date default sysdate)

【在 h****r 的大作中提到】

: could you give me a simple sample of how to do that. sorry newer to oracle.
: thanks
:
: include
: the

h*r2002-04-29 07:04

5 楼

Thanks a lot

oracle.

【在 b****e 的大作中提到】

: alter table borrowerarchive add (delete_date date default sysdate)