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

oracleѧϰÀú³Ì

¶ÔoracleÒѾ­Ñ§Ï°Èý¸ö¶à4£¬¿ÉÒÔ²âÊÔÓÃһЩ¸´ÔÓµÄ×éºÏ£» 5£¬ËüÉú³ÉµÄ²âÊÔÓÃÀýÊÇÓм£¿ÉÑ­ÈÕ£¬¼´ÓйæÂɵģ¬²»ÏñÊÖ¹¤²âÊÔÄÇÑù»áÒÅ©һЩÓÃÀýµÄ×éºÏ¡£ 3 Ñ¡ÔñOATSµÄ»ù±¾Ô­ÔòÒ»°ã¶¼ÊÇÏÈÈ·¶¨²âÊÔµÄÒòËØ¡¢Ë®Æ½ºÍ½»»¥×÷Ó㬺óÑ¡ÔñÊÊÓõÄÕý½»±í¡£ÔÚÈ·¶¨ÒòËصÄˮƽÊýʱ£¬Ö÷ÒªÒòËØÓ¦¸Ã¶à°²Åż¸¸öˮƽ£¬´ÎÒªÒòËØ¿ÉÉÙ°²Åż¸¸öˮƽ¡£ £¨1ÖØÇìÈí¼þÅàѵ£©ÏÈ¿´Ë®Æ½Êý¡£Èô¸÷ÒòËØÈ«ÊÇ2ˮƽ£¬¾ÍÑ¡ÓÃL(2£ª)±í£»Èô¸÷ÒòËØÈ«ÊÇ3ˮƽ£¬¾ÍÑ¡L(3£ª)±í¡£Èô¸÷ÒòËصÄˮƽÊý²»Ïàͬ£¬¾ÍÑ¡ÔñÊÊÓõĻìºÏˮƽÕý½»±í¡£ £¨2£©Ã¿Ò»¸ö½»»¥×÷ÓÃÔÚÕý½»±íÖÐÓ¦Õ¼Ò»Áлò¶þÁС£Òª¿´ËùÑ¡µÄÕý½»±íÊÇ·ñ×ã¹»´ó£¬ÄÜ·ñÈÝÄɵÃÏÂËù¿¼ÂǵÄÒòËغͽ»»¥×÷Óá£ÎªÁ˶ÔÊÔÑé½á¹û½øÐз½²î·ÖÎö»ò»Ø¹é·ÖÎö£¬»¹±ØÐëÖÁÉÙÁôÒ»¸ö¿Õ°×ÁУ¬×÷Ϊ“Îó²î”ÁУ¬ÔÚ¼«²î·ÖÎöÖÐÒª×÷Ϊ“ÆäËûÒòËØ&rdquo.Êý¾Ý¿â¼¯Èº
¹Ø¼ü×Ö£ºOATS£º¼´Orthogonal Array ¼¯£¬Õâ¸ö¼¯ºÏ£¬°üÀ¨×îÉٵIJâÊÔÓÃÀý£¬;Áд¦Àí¡£ £¨3£©Òª¿´²âÊÔ¾«¶ÈµÄÒªÇó¡£ÈôÒªÇó¸ß£¬ÔòÒËÈ¡²âÊÔ´ÎÊý¶àµÄÕý½»±í¡£ £¨4£©Èô²âÊÔ·ÑÓúܰº¹ó£¬»ò²âÊԵľ­·ÑºÜÓÐÏÞ£¬»òÈËÁ¦ºÍʱ¼ä¶¼±È½Ï½ôÕÅ£¬Ôò²»ÒËѡʵÑé´ÎÊýÌ«¶àµÄÕý½»±í¡£ £¨5£©°´Ô­À´¿¼ÂǵÄÒòËØ¡¢Ë®Æ½ºÍ½»»¥×÷ÓÃȥѡÔñÕý½»±í£¬ÈôÎÞÕýºÃÊÊÓõÄÕý½»±í¿ÉÑ¡£¬¼ò±ãÇÒ¿ÉÐеİ취ÊÇÊʵ±ÐÞ¸ÄÔ­¶¨µÄˮƽÊý¡££¨6£©¶ÔijÒòËØ»òij½»»¥×÷ÓõÄÓ°ÏìÊÇ·ñȷʵ´æÔÚûÓаÑÎÕµÄÇéÔÂÁË£¬¿´Á˲»ÉÙ¶«Î÷£¬oracleÊý¾Ý¿âºÜ¸´ÔÓ£¬¹â¸ÅÄî¾ÍºÜ¶à£¬ÎªÁ˶ÔoracleÓиüºÃµÄÈÏʶÎÒ´òËã°ÑÎÒÕâ¶Îʱ¼äµÄѧϰ×öÏÂ×ܽᣬΪ½áÏÂÀ´µÄѧϰ´òϺõĻù´¡¡£×ܽáĿ¼£º1.Éè¼ÆÊý¾Ý¿â£¬Éè¼Æ³ö½á¹¹ÓÅ»¯µÄÊý¾Ý¿â£¬¿ÉÀ©Õ¹ÐԺá£2.Êý¾Ý¿âµÄ±¸·ÝºÍ»Ö¸´£¬È¨Ï޵ķÖÅä3.ÓÅ»¯Êý¾Ý¿â£¬Êý¾Ý¿âÐÔÄܵ÷ÓÅ¡£4.Êý¾Ý¿â¿ª·¢£¬´æ´¢¹ý³Ì£¬´¥·¢Æ÷£¬º¯ÊýµÈºó¶ËÊý¾Ý¿â³ÌÐò£¬¸øϵͳ¿ª·¢ÈËÔ±Ìṩ·½±ãÊÓͼ5.Êý¾Ý¿âµÄǨÒÆ¡£6.ʵʩÊý¾Ý¿âͬ²½ÖØÇìÈí¼þ£¬´ó±í·Ö¸î£¬·ÖÇø±í¹ÜÀí¡£7²¢ÇÒ£¬°üÀ¨ÁËËùÓбäÁ¿µÄ×éºÏ,3£¬µÃµ½µÄ±äÁ¿µÄ×éºÏÊǾùÔȵķֲ¼µÄ£¨ÕâÒ»µã¿ÉÒÔ²ÎÕÕÉÏÃæµÄÕý½»±íµÄÌص㣩£»¿öÏ£¬Ñ¡ÔñL±íʱ³£Îª¸ÃÑ¡´ó±í»¹ÊÇѡС±í¶øÓÌÔ¥¡£ÈôÌõ¼þÐí¿É£¬Ó¦¾¡Á¿Ñ¡Óôó±í£¬ÈÃÓ°Ïì´æÔڵĿÉÄÜÐԽϴóµÄÒòËغͽ»»¥×÷Óø÷Õ¼Êʵ±µÄÁС£4 OATSµÄ²½Ö裺1£¬ÏÈÒªÖªµÀÄãÓжàÉÙ¸ö±äÁ¿£¬Õâ¸ö²»ÓÃ˵ÁË£¬ºÜ¼òµ¥µÄ¾ÍÄÜÈ·¶¨ÁË¡£Ëü¶ÔÓ¦µ½Õý½»±íµÄ¸ÅÄîÖеÄÒòËØÊý¡£ 2£¬²é¿´Ã¿¸ö±äÁ¿µÄ²âÊÔÈ¡Öµ¸öÊý£¨ÕâÀïÎÒÓÃa´úÌ棬ÒÔ·½±ãºóÃæµ÷Óã©£¬Õâ¸öÈ¡Öµ²»ÊÇ˵Õâ¸ö±äÁ¿µÄÈ¡Öµ·¶Î§ÖаüÀ¨¶àÉÙ¸öÖµ£¬¶øÊÇÓõȼÛÀà»®·Ö³öÀ´µÄ¡£¹ØÓڵȼ


Ïà¹ØÎĵµ£º

Oracle¶àÐмǼºÏ²¢/Á¬½Ó/¾ÛºÏ×Ö·û´®µÄ¼¸ÖÖ·½·¨

ʲôÊǺϲ¢¶àÐÐ×Ö·û´®£¨Á¬½Ó×Ö·û´®£©ÄØ£¬ÀýÈ磺
SQL> desc test;
Name     Type          Nullable Default Comments
------- ------------ -------- ------- --------
COUNTRY VARCHAR2(20) Y       &nb ......

Oracle Trigger¼òµ¥Ó÷¨

1. trigger ÊÇ×Ô¶¯Ìá½»µÄ£¬²»ÓÃCOMMIT£¬ROLLBACK
2. trigger×î´óΪ32K£¬Èç¹ûÓи´ÔÓµÄÓ¦ÓÿÉÒÔͨ¹ýÔÚTRIGGERÀïµ÷ÓÃPROCEDURE»òFUNCTIONÀ´ÊµÏÖ¡£
3. Óï·¨
CREATE OR REPLACE TRIGGER <trigger_name>
<BEFORE | AFTER> <ACTION>
ON <table_name>
DECLARE
 <variable definitions> ......

´øÅÅÐòµÄoracle·ÖÒ³´æ´¢¹ý³Ì

create or replace package Pager
is
type curs is ref cursor;
procedure Pagination
(
inPageSize in integer, --ÿҳ¼Ç¼Êý
inPageIndex in integer, --µ±Ç°Ò³Êý
inTableName in varchar2, --±íÃû
inOrderField in varchar2,--ÅÅÐò×Ö¶Î
inIsOrderBy in varchar2,--ÅÅÐòÀà±ð£¬ÊäÈë'  desc' »òÕß' asc'
inW ......

dz̸ÔÚHibernateÖÐʹÓÃOracle sequence

Ò». Ϊ±í´´½¨×ÔÔö³¤×Ô¶ÎÓÐÁ½ÖÖ£¬Ò»ÖÖÊDz»Í¬µÄ±íʹÓø÷×ÔµÄSequence£¬·½·¨ÈçÏ£º
    1¡¢ÔÚOracle sequenceÊ×ÏÈ´´½¨sequence       create sequence seq_idminvalue 1start with 1increment by 1cache 20;     2.ÔÚÄãµÄhbm.xmlÖеÄÅäÖà    seq ......

Oracle raw Êý¾ÝÀàÐÍ

    RAW£¬ÀàËÆÓÚCHAR£¬ÉùÃ÷·½Ê½RAW(L)£¬LΪ³¤¶È£¬ÒÔ×Ö½ÚΪµ¥Î»£¬×÷ΪÊý¾Ý¿âÁÐ×î´ó2000£¬×÷Ϊ±äÁ¿×î´ó32767×Ö½Ú¡£
    LONG RAW£¬ÀàËÆÓÚLONG£¬×÷ΪÊý¾Ý¿âÁÐ×î´ó´æ´¢2G×Ö½ÚµÄÊý¾Ý£¬×÷Ϊ±äÁ¿×î´ó32760×Ö½Ú
 
    ²åÈërawÊý¾Ý²Ù×÷:
¡¡¡¡insert into raw_test values (1, ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ