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 DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
28.2.4 °²×°Oracle 11g
Oracle 11gÌṩÁËͼÐλ¯µÄ°²×°½çÃæ£¬Óû§¿Éͨ¹ýÒÆ¶¯ºÍµ¥»÷Êó±êÍê³É°²×°¹ý³Ì¡£¾ßÌå°²×°²½ÖèÈçÏÂËùʾ¡£
£¨1£©½âѹOracle 11g°²×°°üÎļþ¡£
unzip linux_11gR1_database_1013.zip
Îļþ½«»á±»½âѹµ½linux_11gR1_database_1013Ŀ¼Ï£¬ÈçÏÂËùʾ¡£
# ls
doc inst ......
28.4.3 ¼ì²âOracleÊý¾Ý¿â״̬
OracleÆô¶¯ºó£¬Îª¼ì²âOracle·þÎñµÄÔËÐÐÊÇ·ñÕý³££¬¿ÉÒÔÖ´ÐÐpsÃüÁî¼ì²éÏà¹ØµÄOracle·þÎñ½ø³Ì£¬Ò²¿ÉÒÔͨ¹ýOracleËùÌṩµÄÃüÁî½øÐмì²é¡£¾ßÌå½éÉÜÈçÏÂËùʾ¡£
£¨1£©Ö´ÐÐpsÃüÁî²é¿´Êý¾Ý¿â½ø³ÌÇé¿ö¡£
ps -ef | grep oracle
£¨2£©ÔÚsqlplusÖÐÖ´ÐÐÃüÁî²é¿´Êý¾Ý¿â״̬¡£
&nbs ......
Tomcat4.0ÓëOracleÔõô½¨Á¢Á¬½Ó³Ø£¿½¨ºÃºóÔõô²âÊÔ£¿
×÷Õߣºdorawo 2003Äê11ÔÂ07ÈÕ 10:01 ½øÈëÂÛ̳
Ïà¹ØÌÖÂÛ:oracle Á¬½Ó³Øweblogic½¨Á¢Á¬½Ó³ØÁ¬½Ó³Øtomcat Á¬½Ó³Øjava Á¬½Ó³Øhibernate Á¬½Ó³Ømys ......