Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ʹÓÃ×Ó²éѯ²åÈëºÍÐÞ¸ÄÊý¾Ý

ʹÓÃ×Ó²éѯ²åÈëÊý¾Ý£º
ʾÀýÒ»£ºinsert into employee (empno,ename,sal,deptno)
           select empno,ename,sal,deptno from emp
          where deptno=20;
ʾÀý¶þ£ºinsert /*+APPEND*/ into employee (empno,e ......

Oracle session×ܽá

  ´ÓÉÏÖÜÆð£¬·þÎñÆ÷OracleÊý¾Ý¿â³öÏÖÎÊÌ⣬Óò»µ½°ëÌ죬¾Í»á±¨maxsession£¨150£©µÄÎÊÌ⣬¿Ï¶¨ÊÇÊý¾Ý¿âµÄ»á»°³¬¹ý×î´óÊýÁË¡£
  ÓÉÓÚ·þÎñÆ÷ÅܵÄÊÇÎļþ´«ÊäÓ¦Óã¬Õ¼ÓõÄÇëÇóºÍ»á»°¿Ï¶¨ºÜ´ó£¬Òò´ËÓû§Êý²»´ó¾ÍÒѾ­ÈÃoracleµÄ»á»°Êý´ïµ½×î´óÖµ¡£
  ´¦Àí·½Ê½²»ÍâºõÁ½ÖÖ£ºÀ©´óoracle×î´ósessionÊýÒÔ¼°Çå³ýinact ......

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


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

ÈçºÎ²éѯSQL Server±¸·Ý»¹Ô­ÀúÊ·¼Ç¼

SQL ServerÔÚmsdbÊý¾ÝÖÐά»¤ÁËһϵÁÐ±í£¬ÓÃÀ´´æ´¢Ö´ÐÐËùÓб¸·ÝºÍ»¹Ô­µÄϸ½ÚÐÅÏ¢¡£¼´Ê¹ÄãÕýÔÚʹÓõÚÈý·½µÄ±¸·ÝÓ¦ÓóÌÐò£¬Ö»ÒªÕâ¸öÓ¦ÓóÌÐòʹÓÃSQL ServerµÄÐéÄâÉ豸½Ó¿Ú(Virtual Device Interface---VDI)À´Ö´Ðб¸·ÝºÍ»¹Ô­Ö´ÐУ¬ÄÇôִÐÐϸ½ÚÒÀÈ»±»´æ´¢ÔÚÕâһϵÁбíÖС£
´æ´¢Ï¸½ÚµÄ±í°üÀ¨£º
backupset 
backupfile&n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ