OracleµÄ³õʼ»¯²ÎÊýÎļþ
oracleʵÀýÆô¶¯Ê±¶ÁÈ¡pfile²ÎÊýÎļþ£¬ÐÞ¸Äpfile³õʼ»¯²ÎÊýÎļþºó£¬±ØÐëÖØÐÂÆô¶¯ÊµÀý²ÅÄÜÉúЧ¡£
pfile²ÎÊýÎļþÓëspfile²ÎÊýÎļþ¶¼ÊÇÓÃÀ´´æ·Å³õʼ»¯²ÎÊýµÄÎïÀíÎļþ£¬pfileÒÔÎı¾ÎļþµÄÐÎʽ´æ´¢£¬ÓŵãÊÇÒ×Óڲ鿴ÓëÐ޸ģ»spfileÒÔ¶þ½øÖƵÄÐÎʽ´æ´¢£¬ËäÈ»ÄÜʵÏÖÒÔʵÀý²ÎÊýµÄ¶¯Ì¬Ð޸ģ¬µ«²»ÄÜÖ±½ÓÐ޸ģ¬Ö±½ÓÐ޸ĻáËð»µspfile²ÎÊýÎļþ£¬´Ó¶øÒýÆðʵÀýÆô¶¯Ê§°Ü¡£
pfileÎļþµÄĬÈÏÃû³ÆΪ init<SID>.ora
spfileÎļþµÄĬÈÏÃû³ÆΪ spfile<SID>.ora
Á©ÎļþµÄλÖÃÔÚ <$oracle_home>/product/10.2.1/db_1/dbs/
³õʼ»¯²ÎÊýÎļþµÄÓÅÏȼ¶Îª spfile<sid>.ora ----> spfile.ora ----> init<SID>.ora
¿ÉÒÔʹÓà show parameter spfile ²é¿´µ±Ç°¿´ÕýÔÚʹÓõijõʼ»¯²ÎÊýÎļþÊÇÄĸö
spfileÓëpfileµÄ»¥Ïàͬ²½
create pfile from spfile »ò
create pfile = <pfilename> from spfile = <spfilename>
create spfile from pfile »ò
create spfile = <spfilename> from pfile = <pfilename>
Ö»ÄÜÔÚÊý¾Ý¿â¹Ø±ÕµÄÇé¿öϽøÐÐcreate spfile²Ù×÷£¬ÇÒÎļþÃû²»ÄÜÓëÕýÔÚʹÓõÄÊý¾Ý¿âµÄspfileÏàͬ£¬·ñÔò»á´´½¨Ê§°Ü¡£
Ïà¹ØÎĵµ£º
rownum ÕæµÄÊǺܺõĶ«Î÷£¬ÏÖÔÚ´ó¶àÊýÓÃÓÚ´æ´¢¹ý³Ì·ÖÒ³. µ«ÔõôÓÃÄØ£¿Õâ¾ÍÀ´Ñо¿Ò»Ï¡£ ºÙºÙ
--- ÒÔÏÂΪתÔØÖ®´¦£¬½ö¹©Ñ§Ï°
¶ÔÓÚrownumÀ´ËµËüÊÇoracleϵͳ˳Ðò·ÖÅäΪ´Ó²éѯ·µ»ØµÄÐеıàºÅ£¬·µ»ØµÄµÚÒ»ÐзÖÅäµÄÊÇ1£¬µÚ¶þÐÐÊÇ2£¬ÒÀ´ËÀàÍÆ£¬Õâ¸öα×ֶοÉÒÔÓÃÓÚÏÞÖƲéѯ·µ»ØµÄ×ÜÐÐÊý£¬¶øÇÒrownum²»ÄÜÒÔÈκαíµÄà ......
ÓÃ;: <1>Ä£¿é»¯
<Àý×Ó> --¹«Ë¾µÄÔ±¹¤µÄ¹ÜÀí
1.Ôö¼ÓÒ»¸öÔ±¹¤
2.Ô±¹¤ÀëÖ°
Óô洢¹ý³ÌºÍº¯ÊýÀ´ÊµÏÖ
1.Ôö¼ÓÒ»¸öÔ±¹¤
create sequence seq1 start with 7935;
create or replace function insert ......
ORACLEÊý¾Ý¿âÀï±íµ¼ÈëSQL ServerÊý¾Ý¿â
1¡¢ÔÚÄ¿µÄSQL ServerÊý¾Ý¿â·þÎñÆ÷ÉÏ°²×°ORACLE ClientÈí¼þ»òÕßORACLE ODBC Driver.
ÔÚ$ORACLE_HOME\network\admin\tnsnames.oraÀïÅäÖÃORACLEÊý¾Ý¿âµÄ±ðÃû(service name)¡£
2¡¢ÔÚWIN2000»òÕßwin200 ......
Oracle µÄ´úÂë±íʾ¼°ÊÂÀý
1. select + xxx + from + xxx //²éѯÓï¾ä xxx ±íʾһ¸ö±í
Select * from + xxx // * ±íʾһ¸öÁбíÖÐËùÓеÄÄÚÈÝ
Àࣺ 1£©// select * from country
  ......
OracleºÍTomcat¶Ë¿Ú³åÍ»
ÔÒò:
Oracle 9i¿ªÊ¼£¬´´½¨Êý¾Ý¿âʱĬÈÏ°üº¬ÁËXDBÌØÐÔ¡£Ò»µ©Æô¶¯ÁËÊý¾Ý¿âºÍListener£¬Oracle XDBµÄhttp·þÎñ¾ÍÕ¼ÓÃ8080¶Ë¿Ú£¬¸ÕºÃºÍJBoss¡¢TomcatµÈĬÈ϶˿ڳåÍ»¡£
½â¾ö·½·¨
1¡¢¸Ä¶¯tomcat¶Ë¿Ú£¬
´ò¿ªD:\Tomcat5\conf\server.xml£¬²éÕÒÈçÏÂÎı¾Î»Öãº
<!-- Def ......