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

ORACLEÖн¨Á¢×ÔÔö×Ö¶Î

OracleÖв»ÏñÆäËûÈçmysqlµÈÊý¾Ý¿âµÄÓÐ×ÔÔö×ֶΣ¬Èç¹ûÐèÒªÔòÐèÒª½èÖúÐòÁкʹ¥·¢Æ÷
Ê×ÏȽ¨±í
½¨Á¢ÐòÁÐ
½¨´¥·¢Æ÷
For example£º
create table SYS_MESSAGE
(
ID NUMBER not null PRIMARY KEY,
M_TYPE VARCHAR2(10) not null,
TITLE VARCHAR2(200),
CONTENT LONG,
M_TIME VARCHAR2(50),
AUTHOR VARCHAR2(20)
);
CREATE SEQUENCE SYS_MESSAGE_ID_SEQ
INCREMENT BY 1
START WITH 1
NOMAXVALUE
MINVALUE 1
CACHE 50
;

CREATE OR REPLACE TRIGGER SYS_MESSAGE_ID_TRIGGER
BEFORE INSERT ON SYS_MESSAGE
FOR EACH ROW
WHEN (NEW.ID IS NULL)
BEGIN
SELECT SYS_MESSAGE_ID_SEQ.NEXTVAL INTO:NEW.ID from DUAL;
END;


Ïà¹ØÎĵµ£º

OracleÊý¾Ý¿âµÄÓÅ»¯Éè¼Æ

[ÕªÒª]Ö÷Òª´Ó´óÐÍÊý¾Ý¿âORACLE»·¾³Ëĸö²»Í¬¼¶±ðµÄµ÷Õû·ÖÎöÈëÊÖ£¬·ÖÎöORACLEµÄϵͳ½á¹¹ºÍ¹¤×÷»úÀí£¬´Ó²»Í¬·½Ãæ½ÏÈ«ÃæµØ×ܽáORACLEÊý¾Ý¿âµÄÓÅ»¯µ÷Õû·½°¸¡£
[¹Ø¼ü´Ê]ORACLEÊý¾Ý¿â¡¢»·¾³µ÷Õû¡¢ÓÅ»¯Éè¼Æ¡¢·½°¸
ÖÐͼ·ÖÀàºÅ£ºTP3 ÎÄÏ×±êʶÂ룺A ÎÄÕ±àºÅ£º1671£­7597(2008)0720043£­01
¡¡¡¡
¡¡¡¡ORACLEÊý¾Ý¿âÖÐÊý¾Ý´æÈ¡ÐÔÄ ......

28.5 OracleͼÐλ¯¹ÜÀí¹¤¾ß——OEM

28.5  OracleͼÐλ¯¹ÜÀí¹¤¾ß——OEM
OracleÆóÒµ¹ÜÀíÆ÷£¨Oracle Enterprise Manager£¬OEM£©ÊÇOracleÌṩµÄÒ»¸ö»ùÓÚWebµÄͼÐλ¯Êý¾Ý¿â¹ÜÀí¹¤¾ß¡£Í¨¹ýOEM£¬Óû§¿ÉÒÔÍê³É¼¸ºõËùÓеÄÔ­À´Ö»ÄÜͨ¹ýÃüÁîÐз½Ê½Íê³ÉµÄ¹¤×÷£¬°üÀ¨Êý¾Ý¿â¶ÔÏó¡¢Óû§È¨ÏÞ¡¢Êý¾ÝÎļþ¡¢¶¨Ê±ÈÎÎñµÄ¹ÜÀí£¬Êý¾Ý¿â²ÎÊýµÄÅäÖ㬱¸·ÝÓë»Ö¸´£¬ÐÔÄÜ ......

oracleµÄ·ÖÎöº¯Êýover ¼°¿ª´°º¯Êý


oracleµÄ·ÖÎöº¯Êýover ¼°¿ª´°º¯Êý
Ò»£º·ÖÎöº¯Êýover
Oracle´Ó8.1.6¿ªÊ¼Ìṩ·ÖÎöº¯Êý£¬·ÖÎöº¯ÊýÓÃÓÚ¼ÆËã»ùÓÚ×éµÄijÖÖ¾ÛºÏÖµ£¬ËüºÍ¾ÛºÏº¯ÊýµÄ²»Í¬Ö®´¦ÊÇ
¶ÔÓÚÿ¸ö×é·µ»Ø¶àÐУ¬¶ø¾ÛºÏº¯Êý¶ÔÓÚÿ¸ö×éÖ»·µ»ØÒ»ÐС£
ÏÂÃæÍ¨¹ý¼¸¸öÀý×ÓÀ´ËµÃ÷ÆäÓ¦Óᣠ          &nb ......

28.6 Oracle³£¼ûÎÊÌâ´¦Àí

28.6  Oracle³£¼ûÎÊÌâ´¦Àí
±¾½Ú½éÉÜÔÚRed Hat Enterprise Linux 5.2Éϰ²×°¼°ÅäÖÃOracleÊý¾Ý¿â·þÎñÆ÷ÖУ¬³£¼ûµÄÎÊÌâ¼°½â¾ö·½·¨£¬°üÀ¨ÈçºÎ»ñµÃÊý¾Ý¿â´´½¨¹ý³ÌÖеÄÏêϸÐÅÏ¢£¬·ÃÎÊOEM³öÏÖ“°²È«Á¬½Óʧ°Ü£¬Ê¹ÓÃÁËÎÞЧµÄ°²È«Ö¤Êé”´íÎóÒÔ¼°Íü¼ÇsysÓû§¿ÚÁîºóµÄ´¦Àí·½·¨µÈ¡£ ......

Oracle ѧϰ±Ê¼Ç: SYSDBAµÇ½ȨÏÞÎÊÌâ

±¾ÎÄ»·¾³ÅäÖãºOracle10gR2£¬Windows XP
OracleµÄÓû§ÐÅÏ¢Ò»°ãÀ´ËµÊDZ£´æÔÚÊý¾Ý×ÖµäÀïµÄ£¬ËùÒÔ³£¹æÓû§ÔÚOracleÊý¾Ý¿âûÓÐÆô¶¯µÄʱºòÊÇÎÞ·¨µÇ½µÄ¡£µ«ÓÐÁ½ÀàÓû§ÀýÍ⣬Õâ¾ÍÊǾßÓÐsysdba»òÕßsysoperȨÏÞµÄÓû§¡£Oracle sysdba»òÕßsysoperÓû§µÄµÇ½ÓÐÁ½ÖÖ·½Ê½£ºÒ»ÊÇͨ¹ýOSÈÏÖ¤£¬¶þÊÇͨ¹ýÃÜÂëÎļþÑéÖ¤¡£
¾¿¾¹Ê¹ÓÃÄÄÒ»ÖÖÑéÖ¤ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ