Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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;


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

oracleË÷ÒýÏê½â

Ô­ÎĵØÖ·£ºhttp://fandayrockworld.javaeye.com/blog/540509 
»Ø¹Ë£º
Ò»¡¢ ROWIDµÄ¸ÅÄî
¡¡¡¡´æ´¢ÁËrowÔÚÊý¾ÝÎļþÖеľßÌåλÖãº64λ±àÂëµÄÊý¾Ý£¬A-Z, a-z, 0-9, +, ºÍ /£¬
¡¡¡¡rowÔÚÊý¾Ý¿éÖеĴ洢·½Ê½
¡¡¡¡SELECT ROWID, last_name from hr.employees WHERE department_id = 20;
¡¡¡¡±ÈÈ磺OOOOOOFFFBBBBBBRRR ......

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

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

Tomcat4.0ÓëOracleÔõô½¨Á¢Á¬½Ó³Ø£¿½¨ºÃºóÔõô²âÊÔ£¿


  
 
  
   
Tomcat4.0ÓëOracleÔõô½¨Á¢Á¬½Ó³Ø£¿½¨ºÃºóÔõô²âÊÔ£¿
×÷Õߣºdorawo    2003Äê11ÔÂ07ÈÕ 10:01    ½øÈëÂÛ̳  
 
Ïà¹ØÌÖÂÛ:oracle Á¬½Ó³Øweblogic½¨Á¢Á¬½Ó³ØÁ¬½Ó³Øtomcat Á¬½Ó³Øjava Á¬½Ó³Øhibernate Á¬½Ó³Ømys ......

²é¿´oracleµÄϵͳÎļþÄÚÈÝ

ÔÚÃüÁî¸ñʽÏ£¬½øÈësqlplusµÄ±à¼­×´Ì¬ÖÐ
 
£¨1£©²é¿´¿ØÖÆÎļþµÄÄÚÈÝ£º
SQL> DESC v$controlfile
 Ãû³Æ                               &n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ