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

oracle×¢ÊÍ£ºcomment onµÄÖØÒªÒâÒå

ÎÞÒÉ×¢ÊÍÏÖÔÚ¶¼±»´ó¼Ò½ÓÊܺÍÈϿɣ¬ÔÚ´ó¼Ò±à³ÌÓõÄIDEÖж¼Ìṩ»òÓеÚÈý·½²å¼þÀ´Ö§³ÖÌáȡעÊÍÄÚÈÝʵÏÖ
¿ìËÙÁ˽â½á¹¹µÄ¹¦ÄÜ¡£µ«ÔÚÊý¾Ý¿âµÄ½Å±¾±àд·½ÃæÎÒÒ²ÊǾ­ÀúÁ˰ٰãÕÛÄ¥ºó×ܽáÁËһЩ¶«Î÷·¢À´Óë´ó¼ÒÇд衣
ÏÂÃæÀ´¿´Ò»¸öOracle½¨±íµÄ·½Ê½¡£
create table ctable_name
(
       field1 varchar2(20), --×¢Ê͵ÄÄÚÈÝ1
       field2 number,       --×¢Ê͵ÄÄÚÈÝ2
       field3 char(2),      --×¢Ê͵ÄÄÚÈÝ3
       field4 date          /*×¢Ê͵ÄÄÚÈÝ4*/
)
֮ǰһֱ¶¼ÊÇÕâÑùÀ´½¨±í£¬¾õµÃ¿ìËÙÒ²ºÃÀí½â£¬ÆäʵÊý¾Ý¿â½á¹¹²»¸´ÔÓµÄÇé¿öÏÂÎÒҲϲ»¶ÕâÖÖ·½Ê½£¬µ«µ±Êý¾Ý¿â½á¹¹ºÜ¸´ÔÓµÄʱºòά»¤ÆðÀ´¾ÍºÜÍ·ÌÛ£¬Ò»¸öSQL¼¸°ÙK£¬¿´µÄÄãÑÛ¶¼»¨ÁË£¬¶øÇÒÓÐN¸öÕâÑùµÄSQLÎļþ£¬ÄÇôÔÚ¶Ô²»Á˽âµÄ¸´ÔÓµÄÊý¾Ý¿â½á¹¹ÊµÏÖ¿ìËÙ±à³Ì·½Ã棬ΪÁËÁ˽â½á¹¹²éÕÒ×¢Ê͵Ť×÷Á¿Ò²ºÜ´ó¡£
ÓÈÆä¹«Ë¾ÏîÄ¿ÒѾ­×öÁË5ÄêÁË£¬ºÃ¶àSQL½Å±¾¶¼Ã»ÁË£¬ÄÇôÊý¾Ý½á¹¹Ö»ÄÜÎÊÀϵÄͬÊ£¬µ«¶ÔÓÚÈËÔ±¸üÌæÆµ·±µÄ¹«Ë¾µ±ÀϳÌͬʶ¼»»Á˼¸Åú£¬¶¼²»ÔÚÁË£¬Ã»ÈË¿ÉÎÊ£¬ÄÇôά»¤ÈËÔ±»òºóÐø¿ª·¢ÈËÔ±¾Íµô½øÁËÎÞ¾¡µÄÍ´¿àÖУ¬ºÃ¶àÎÊÌâ¶¼ÊdzöÔÚÕâÉÏÃæ¡£ºóÆÚͶÈë³É±¾Ò²ÊǺܾ޴óµÄ¡£Èç¹ûÊý¾Ý¿â½á¹¹ÃüÃûʲôµÄ±È½Ï¹æ·¶»¹ºÃ£¬¿ÉÒÔÆ¾×ÖÃæÒâ˼ȷ¶¨´ó¸ÅÓÃ;£¬·´Ö®ÕæÊµ¿à²»¿°ÑÔ¡£¶øÇÒ֪ʶµÄ´«µÝµ±ÖÐÊÇÓÐÈËΪÒòËØµ¼ÖµÄȱʧµÄ¡£¾ÙÀýÀ´Ëµ¾ÍÊÇÒ»°ãÔ±¹¤À뿪¹«Ë¾Ö®Ç°»áÓÃÒ»¸öÔµÄʱ¼äÀ´½»½Ó£¬µ«´ó²¿·Ö¶¼ÊÇÓÃ
Ò»ÖÜ×óÓÒµÄʱ¼äÀ´½»½Ó¹¤×÷£¬ÄÇô½»½ÓµÄ×ÔÈ»»áÓÐÒâʶµÄºöÂÔһЩСµÄ»òÑÚ¸ÇһЩÓÐÎÊÌâµÄµØ·½Ö»ËµÖ÷ÒªºÃʹµÄµØ·½£¬Èç¹û½»½ÓµÄÊÇÒ»¸ö¶Ô½á¹¹Á˽âµÄͬÊ»¹ºÃ£¬¸ù¾ÝÏàÓ¦µÄ¾­Ñ飬³Ð½Ó²»ÊÇÎÊÌ⣬µ«Èç¹û½»½Ó¸øÐµÄͬÊ£¬ÐÂͬÊÂ½ÓÆðÀ´ºÜ·Ñ¾¢£¬¶øÒª×ßµÄͬÊÂÒª½øµÄ¹«Ë¾»¹´ßËûËٶȰìÀëÖ°£¬ÄÇôȱʧµÄ²¿·Ö¾ÍÒªÐÂͬÊÂÀ´ÃÖ²¹£¬µ±È»Èç¹ûËûÊǸö¸ºÔðµÄÈ˵±Ëû·¢ÏÖËäÈ»ÏîÄ¿¿ÉÒÔ½øÐлò˵³ÌÐò¿ÉÒÔÅÜÆðÀ´µ«ÓÐЩ¶«Î÷£¬Ò»°ãÊÇϸ½ÚµÄ¶«Î÷Ëû»¹²»Á˽âÐèÒª´òµç»°¸øÔ­À´µÄͬÊÂÀ´ÅªÇå³þ£¬ÄÇôҲ²»»áÓÐʲôÎÊÌ⣬µ«ÎÒ˵µÄÊÇÈç¹û£¬Ò»°ãµÄÈËÔÚ¿´µ½ÏîÄ¿Äܹ»½øÐУ¨³ÌÐòÄÜÅÜÆðÀ´£©ÊDz»»áȥŪÄÇЩ¶«Î÷µÄ£¬ÕâÑùÑ­»·ÏÂÈ¥£¬×îºóά»¤Õâ¸ö³ÌÐò»òºóÐø¿ª·¢µÄµ¹Ã¹µ°¾ÍÓеĿà³ÔÁË£¬ÎÒÌå»


Ïà¹ØÎĵµ£º

Using Oracle Trace Analyzer (trcanlzr.sql)


Using Oracle Trace Analyzer (trcanlzr.sql)
Dave Moore:  Author of Oracle Utilities
Oracle has provided another utility initially designed for performance tuning Oracle Applications.  Trace Analyzer is provided in the form of a PL/SQL package (TRCA$ ).  The Trace Analyzer utility i ......

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

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

ORACLE ³£ÓÃ×Ö·ûº¯Êý


1.LOWER(str) Ç¿ÖÆÐ¡Ð´
2.UPPER(str) Ç¿ÖÆ´óд
3.INITCAP(str) ÿ¸öµ¥´ÊÊ××Öĸ´óд
ʾÀý£º
SQL> select initcap('my_boy') from dual; --·µ»Ø"My_Boy"
×¢Ò⣺µ¥´ÊÖ®¼äÓÃÏ»®Ïߣ¨"_"£©·Ö¸î
4.CONCAT(str1,str2£©Á¬½Óº¯Êý,Á¬½Óstr1ºÍstr2×Ö·û´®
5.SUBSTR(string,a[,b])·µ»ØstringµÄÒ»²¿·Ö£¬aºÍbÒÔ×Ö·ûΪµ¥Î»¡£´Ó× ......

ÔÚ Linux x86 Éϰ²×° Oracle RAC 10g

DBA£ºLinux
ÔÚ Linux x86 Éϰ²×° Oracle RAC 10g
×÷ÕߣºJohn Smiley
Á˽âÔÚ Red Hat Enterprise Linux »ò Novell SUSE Enterprise Linux ÉÏ´ÓÍ·°²×° Oracle RAC 10g µÄ»ù´¡ÖªÊ¶£¨½öÓÃÓÚÆÀ¹À£©
Ŀ¼
¸ÅÊö
±³¾°
µÚ 1 ²¿·Ö£º °²×° Linux
µÚ 2 ²¿·Ö£º Ϊ Oracle ÅäÖà Linux
µÚ 3 ²¿·Ö£º ×¼±¸¹²Ïí´ÅÅÌ
µÚ 4 ²¿·Ö£º ......

oracle ±íÖвåÈë¶àÐÐ

·½·¨Ò»£º
SQL>create table aa(a number);
´´½¨³É¹¦¡£
SQL> select * from aa;
A
--------
2
SQL>
SQL> insert all
2 into aa values(1)
3 into aa values(2)
4 select * from dual;
ÒÑ´´½¨2ÐС£
SQL> commit;
Ìá½»Íê³É¡£
SQL> select * from aa;
A
----------
2
1
2
·½·¨¶þ£º
S ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ