Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎÊ´ð£º

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

oracle °²×° 01092 ´íÎó - Oracle / »ù´¡ºÍ¹ÜÀí

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 / ......

Oracle ¸ßÊÖ½ø - Java / Java EE

SELECT * from (SELECT A.*, ROWNUM RN from (SELECT * from t_out_logon) A WHERE ROWNUM <= 30)WHERE RN >= 21
SELECT A.* from (SELECT t.*,rownum rn from t_out_logon t WHERE ROWNUM <= 30) A WHERE ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ