oracle 外键约束加触发器问题？ - Oracle / 高级技术
SQL code:
create table user_file (
userID int not null,
userName VARCHAR2(10),
userPwd VARCHAR2(10),
primary key (userID)
);
create table articletype (
magazineType int not null,
magazienTypeName VARCHAR2(20) not null,
primary key (magazineType)
);
create table article (
authorID int not null,
artcleName VARCHAR2(20) not null,
reportDate DATE,
magazine VARCHAR2(20),
magazineType int,
authorOrder int,
extend VARCHAR2(100),
foreign key (authorID) references user_file(userID)on delete
cascade,
foreign key (magazineType) references articletype(magazineType) on
delete cascade
);
create table log_file (
userID int not null,
operater VARCHAR2(10),
operaterDest VARCHAR2(20),
operaterDate DATE,
foreign key (userID) references user_file(userID)
);
前面是我建的表，下面是我建的触发器
SQL code:
--论文更新触发器
CREATE OR REPLACE TRIGGER article_log_file
BEFORE INSER
相关问答：
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
oracle 11g 安装 01092 错误,
日志信息：
[oracle@linux trace]$ vi alert_orcl.log
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......
看到有一个SUN的元老从Oracle公司辞职，而且是Java创始人——大名鼎鼎的James Gosling，
心中相当受打击！很悲痛！
Orable这是怎么了，难道这就是所谓的融合（肢解，分化，消失）吗？
SUN的一帮老员工� ......
--建立一个包以定义一个游标
create or replace package PK_test
as
type cur_test is ref cursor;
end PK_test;
--建立一个过程,通过输入JOBID，返回一个表记录（游标）!
create or replace ......
