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

°²×°Oracle 10g inistant clientºóÊÇPL/SQL³öÏÖÂÒÂë

ÏëʹÓÃPL/SQL¿ª·¢¹¤¾ß£¬µ«²»Ïë°²×°ÄǸö¼¸°ÙÕ×µÄoracle¿Í»§¶Ë£¬ÓÚÊǰ²×°ÁËoracle 10g inistant client£¬40¶àM°É¡£
°²×°ºóPL/SQL¿ÉÒÔÓÃÁË£¬µ«ÊDzéѯ³ö¼Ç¼ÀïÃæµÄÖÐÎÄÈ´ÊÇÂÒÂë¡£ÕÛÌÚÁ˺þòÅÕÒ³ö½â¾ö·½·¨£º
ÉèÖû·¾³±äÁ¿£ºNLS_LANG£¬ÖµÎªOracleÊý¾Ý¿âÉèÖõÄ×Ö·û¼¯£¬ÔÚÎÒµÄϵͳÀïÃæÉèÖÃÊÇ£ºSIMPLIFIED CHINESE_CHINA.ZHS16GBK
PS: Oralce×Ô¼ºµÄ¿ª·¢¹¤¾ßSQL DeveloperÔÚÕâÖÖÇé¿öÏÂûÓÐÂÒÂëµÄÇé¿ö£¬¶øÇÒÒ²²»ÐèÒª°²×°oracleµÄ¿Í»§¶Ë£¬´ó²¿·ÖÇé¿öÏ»¹Êǹ»Óõġ£


Ïà¹ØÎĵµ£º

oracleÊý¾Ý¿âµ¼Èëµ¼³ö

¸ù¾ÝÓû§µ¼³öÓï¾ä£º
1.Êý¾Ý¿âµ¼³ö
exp system/jade@JADE_166.111.134.26 file=d:\jade.dmp statistics=none
˵Ã÷£º
systeÊÇÓû§Ãû
jadeÊÇÃÜÂë
JADE_166.111.134.26ÊÇSID±êʾ
file=d:\jade.dmp Êǵ¼³öÎļþµÄ·¾¶¼°ÎļþÃû
2.Êý¾Ý¿âµ¼Èë
imp system/jade@JADE_166.111.134.26  file=d:\jade.dmp fromuser=syst ......

oracleÊÂÎñ´¦Àí

1.»ØÍËÊÂÎñ
×îºÃÉèÖÃÒ»¸ö±£´æµã£¬Àýsavepoint a,»òÕßÖ´ÐÐ exec dbms_transaction.savepoint('a')(Ö´ÐÐǰÐèÒªÖ´ÐÐset serveroutput onÓï¾ä)£»È¡Ïû²¿·ÖÊÂÎñ¾Í¿ÉÒÔʹÓÃrollback to a,»òÕßÖ´ÐÐexec dbms_transaction.rollback_savepoint('a');È¡ÏûÈ«²¿ÊÂÎñ¿ÉÒÔÖ´ÐÐrollback,»òÕßexec dbms_transaction.rollback;
2.Ö»¶ÁÊÂÎñ
......

OracleµÄWindow·þÎñÆô¶¯Ê±²¢²»Æô¶¯ÊµÀý

ÔÚwindow·þÎñÆô¶¯Ê±²¢²»Æô¶¯ÊµÀýµÄÁ½ÖÖ·½·¨:
¡¡¡¡(1)ͨ¹ýoradim startup ²ÎÊýÉ趨,ÈçÏÂ:
¡¡¡¡a.²é¿´oradim°ïÖú
C:Documents and SettingsAdministrator>oradim help
DIM-00002: ÓÐЧµÄÃüÁî°üÀ¨: -DELETE, -EDIT, -NEW, -STARTUP ºÍ -SHUTDOWN
¡¡¡¡ÇëÊäÈëÒÔÏÂÃüÁîÖ®Ò»:
¡¡¡¡Í¨¹ýÖ¸¶¨ÒÔϲÎÊý´´½¨Àý³Ì:
-NEW - ......

Íü¼ÇSQL ServerµÄSAÓû§ÃÜÂë½â¾ö·½·¨


×÷Õß:ÍøÂ·ÓÎÏÀ@youxia.org
·¢²¼Ê±¼ä:2005-9-25 11:48:18 ÎÄÕÂÀ´Ô´:youxia.org
̨ʽ»úºÍ±¾±¾·Ö±ð°²×°ÁËMS SQL Server£¬·½±ã×ö²âÊÔÓÃ
½á¹ûʱ¼ä³¤ÁË£¬
̨ʽ»úSQL ServerµÄÃÜÂëÍü¼ÇÁË……
ÄѵÀ……ûÓа취ÁËÂ𣿗—No£¡
¾­¹ýÒ»Õó×ÓÓôÃÆ£¬ÓÎÏÀÔÚ°Ù¶ÈËѵ½ÁË·½·¨£º
ÏÖÔÚÄãµÄ
ÆóÒ ......

SQLÖ´ÐÐ˳Ðò

Ò»¡¢sqlÓï¾äµÄÖ´Ðв½Ö裺
1£©Óï·¨·ÖÎö£¬·ÖÎöÓï¾äµÄÓï·¨ÊÇ·ñ·ûºÏ¹æ·¶£¬ºâÁ¿Óï¾äÖи÷±í´ïʽµÄÒâÒå¡£
2£© ÓïÒå·ÖÎö£¬¼ì²éÓï¾äÖÐÉæ¼°µÄËùÓÐÊý¾Ý¿â¶ÔÏóÊÇ·ñ´æÔÚ£¬ÇÒÓû§ÓÐÏàÓ¦µÄȨÏÞ¡£
3£©ÊÓͼת»»£¬½«Éæ¼°ÊÓͼµÄ²éѯÓï¾äת»»ÎªÏàÓ¦µÄ¶Ô»ù±í²éѯÓï¾ä¡£
4£©±í´ïʽת»»£¬ ½«¸´Ô SQL ±í´ïʽת»»Îª½Ï¼òµ¥µÄµÈЧÁ¬½Ó±í´ïʽ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ