Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Óαê

drop table tmp_lzw_3283_tar;
create table tmp_lzw_3283_tar
(
    servnumber varchar2(11)
)
;
load data
infile 'tar_3283.txt'
insert into table tmp_lzw_3283_tar
fields terminated by '|'
(
servnumber
)
/*
select count(*),count(distinct servnumber) from tmp_lzw_3283_ta ......

oracle µ¼Èë

sqlldrÏê½â
 
Oracle µÄSQL*LOADER¿ÉÒÔ½«ÍⲿÊý¾Ý¼ÓÔØµ½Êý¾Ý¿â±íÖС£ÏÂÃæÊÇSQL*LOADERµÄ»ù±¾Ìص㣺
1£©ÄÜ×°È벻ͬÊý¾ÝÀàÐÍÎļþ¼°¶à¸öÊý¾ÝÎļþµÄÊý¾Ý
2£©¿É×°Èë¹Ì¶¨¸ñʽ£¬×ÔÓɶ¨½çÒÔ¼°¿É¶È³¤¸ñʽµÄÊý¾Ý
3£©¿ÉÒÔ×°Èë¶þ½øÖÆ£¬Ñ¹ËõÊ®½øÖÆÊý¾Ý
4£©Ò»´Î¿É¶Ô¶à¸ö±í×°ÈëÊý¾Ý
5£©Á¬½Ó¶à¸öÎïÀí¼Ç¼װµ½Ò»¸ö¼Ç¼ÖÐ
6£©¶ÔÒ ......

Oracle select in/exists/not in/not exits

in ÊǰÑÍâ±íºÍÄÚ±í×÷hash Á¬½Ó£¬¶øexistsÊǶÔÍâ±í×÷loopÑ­»·£¬Ã¿´ÎloopÑ­»·ÔÙ¶ÔÄÚ±í½øÐвéѯ¡£
Ò»Ö±ÒÔÀ´ÈÏΪexists±ÈinЧÂʸߵÄ˵·¨ÊDz»×¼È·µÄ¡£
Èç¹û²éѯµÄÁ½¸ö±í´óСÏ൱£¬ÄÇôÓÃinºÍexists²î±ð²»´ó¡£
in ÊǰÑÍâ±íºÍÄÚ±í×÷hash Á¬½Ó£¬¶øexistsÊǶÔÍâ±í×÷loopÑ­»·£¬Ã¿´ÎloopÑ­»·ÔÙ¶ÔÄÚ±í½øÐвéѯ¡£
Ò»Ö ......

Æô¶¯oracle ¹ùÒ«½ñ

ÓÃsqlplusÆô¶¯Êý¾Ý¿â
sqlplus /nolog
SQL> connect system/change_on_install as sysdba
SQL> startup
ÓÃsqlplusÍ£Ö¹Êý¾Ý¿â$ORACLE_HOME/bin/sqlplus /nolog
SQL> connect system/change_on_install as sysdba
SQL> shutdown ......

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> ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ