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

Oracle ʵÏÖÐÐÁÐת»»

SQL> DESC TEST  ²âÊÔ±í:        Name    Type            Nullable    Default Comments
       ----     ------------         --------      -------     --------
       A        NUMBER           Y                        
       B        VARCHAR2(20) Y          SQL> select * from test;                  A B
       ---------- --------------------
                 1 a
                 1 b
                 1 c
                 1 d
                 1 e
                 2 a
                 2 b
                 3 a
         


Ïà¹ØÎĵµ£º

ά»¤Oracle³£ÓÃSQLÓï¾ä

       ÈçºÎÔ¶³ÌÅжÏOracleÊý¾Ý¿âµÄ°²×°Æ½Ì¨
¡¡¡¡select * from v$version;
¡¡¡¡²é¿´±í¿Õ¼äµÄʹÓÃÇé¿ö
¡¡¡¡select sum(bytes)/(1024*1024) as free_space,tablespace_name
¡¡¡¡from dba_free_space
¡¡¡¡group by tablespace_name;
¡¡¡¡SELECT A.TABLESPACE_NAME,A.BYTES TOTAL,B.BYTES ......

Oracle TNSLSNR Full Client

Most of admins neglect setting password on TNSlsnr Clients for Oracle databases. Oracle ensures that you can either connect to TNSlsnr on a localhost or through mapping to a remote Oracle database using .ora files.
This is not the case anymore Based on Jwa perl client.
This client is a FULL clie ......

Oracle¶¯Ì¬ÐÔÄÜÊÓͼѧϰ֮ V$ROLLSTAT

À´Ô´ÓÚhttp://hi.baidu.com/edeed/blog/item/33576327d1b73d00918f9dd4.html
±¾ÊÓͼ×ÔÆô¶¯¼´±£³Ö²¢¼Ç¼¸÷»Ø¹ö¶Îͳ¼ÆÏî¡£ÔÚѧϰ±¾ÊÓͼ֮ǰ£¬ÎÒÃÇÏÈÀ´Á˽âһϻعö¶Î(rollback segment)µÄÏà¹Ø¸ÅÄ
»Ø¹ö¶Î¸ÅÊö
»Ø¹ö¶ÎÓÃÓÚ´æ·ÅÊý¾ÝÐÞ¸Ä֮ǰµÄÖµ£¨°üÀ¨Êý¾ÝÐÞ¸Ä֮ǰµÄλÖúÍÖµ£©¡£»Ø¹ö¶ÎµÄÍ·²¿°üº¬ÕýÔÚʹÓõĸûعö¶ÎÊÂÎñµÄÐ ......

Oracle ¼¸¸ö¹Ø¼ü×ÖÀí½â

/*
--DML´¥·¢Æ÷ÀàÐÍ:
·ÖΪÓï¾ä¼¶´¥·¢Æ÷ºÍÐм¶´¥·¢Æ÷.
Óï¾ä¼¶´¥·¢Æ÷²»ÐèÒª¼Ófor each row¹Ø¼ü×Ö,²¢ÇÒ²»ÄÜʹÓÃ:new ºÍ :old¹Ø¼ü×Ö.¶ÔÕû¸ösqlÓï¾äÖ»Ö´ÐÐÒ»´Î´¥·¢Æ÷.
Ðм¶´¥·¢Æ÷ÐèÒª¼Ófor each row¹Ø¼ü×Ö,¿ÉÒÔʹÓÃ:newºÍ:old¹Ø¼ü×Ö,¶ÔÕû¸ösqlÓï¾äÓ°Ïìµ½µÄÿһÐж¼Ö´ÐÐÒ»´Î´¥·¢Æ÷.
--:newºÍ:old¹Ø¼ü×Ö×ܽá
:newÖ¸µÄÊǵ±Ç°D ......

OracleÓÃimpµ¼ÈëÓû§±íʱѡÔñ±í¿Õ¼äµÄÎÊÌâ

×Ô¼º¾õµÃ¶ÔOracle»¹ÕÆÎյò»´í£¬²»¹ý×òÌì¸ô±ÚʵÑéÊÒµÄͬѧÎÊÁËÎÒÒ»¸öÎÊÌâÈÃÎÒÓôÃÆÁËÒ»°Ñ¡£ËýÔÚÒ»¸öÊý¾Ý¿âÀï°ÑÒ»¸öÓû§AµÄÔÚ±í¿Õ¼äAAÉϵıí
ÓÃexpµ¼³öµ½exp.dmpÎļþÖУ¬ÔÙ°ÑËüµ¼Èëµ½Áíһ̨»úÆ÷ÉϵÄÊý¾Ý¿âÀÕâʱËýÓõÄÊÇÓû§B£¬Ä¬Èϱí¿Õ¼äÊÇBB£¬µ«ÊÇÓÃimpµ¼ÈëʱÎÒÃÇ·¢ÏÖ±íÊǵ¼Èë
µ½ÁËBÓû§Ï£¬µ«ÊÇ»¹ÊÇ´æÔÚÁËAA±í¿Õ¼äÀïÃæ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ