OracleÊý¾Ý¿âʹÓü°ÃüÃû¹æÔòµÄÏê½â
¹«Ë¾Òѽ¨Á¢µÄ»ò´ý½¨Á¢µÄÍøÕ¾£¬È磺ÖÐÎÄÕ¾£¨CHINA£©£¬¹ú¼ÊÕ¾£¨ALIBABA£©£¬»ªÉÌÕ¾£¨CHINESE£©µÈ¡£
OLPS
Online process system£¬ÔÚÏß´¦Àíϵͳ£¬¼´ÎÒÃǵĻáÔ±¿ÉÒÔä¯ÀÀµÄÍøÕ¾ËùÁ¬½ÓµÄÊý¾Ý¿â£¬Ò²ÊÇÎÒÃÇËù˵µÄǰ̨¡£
BOPS
Back Office process system£¬ºǫ́´¦Àíϵͳ£¬¼´ÎÒÃǵÄÍøÕ¾µÄ·¢²¼ÏµÍ³¡£
BZO
Business Object(?)£¬¹«Ë¾ÍøÕ¾µÍ²ãJAVA¶ÔÏó£¬Ö÷Òª¸ºÔðÓëÊý¾Ý¿â´ò½»µÀ¡£
Ò»¡¢ ÃüÃûÔ¼¶¨
£±£® ÊÇÖ¸Êý¾Ý¿â¡¢Êý¾Ý¿â¶ÔÏóÈçTABLE¡¢SEQUENCE¡¢PROCEDURE¡¢COLUMNµÈµÄÃüÃûÔ¼¶¨£»
£²£® ÃüÃû¸»ÓÐÒâÒåÓ¢ÎĴʻ㣬³ý¸ö±ðͨÓõģ¨¼ûÁÐ±í£©£¬Òª±ÜÃâʹÓÃËõд£©£¬¶à¸öµ¥´Ê×é³ÉµÄ£¬ÖмäÒÔÏ»®Ï߷ָ
£³£® ³ýÊý¾Ý¿âÃû³Æ³¤¶ÈΪ1£8¸ö×Ö·û£¬ÆäÓàΪ1£30¸ö×Ö·û£¬Database linkÃû³ÆÒ²²»Òª³¬¹ý30¸ö×Ö·û£»
£´£® ÃüÃûÖ»ÄÜʹÓÃÓ¢ÎÄ×Öĸ£¬Êý×ÖºÍÏ»®Ïߣ»
£µ£® ±ÜÃâʹÓÃOracleµÄ±£Áô×ÖÈçlevel¡¢¹Ø¼ü×ÖÈçtype£¨¼ûÁÐ±í£©£»
£¶£® Ãû±íÖ®¼äÏà¹ØÁÐÃû¾¡Á¿Í¬Ãû£»
£·£® Êý¾Ý¿âµÄÃüÃû£ºÍøÉÏÊý¾Ý¿âÃüÃûΪ“OLPS”£«±íʾվµã£¨SITE£¬ÒÔÏÂͬ£©µÄ2£4¸ö×Ö·û£¬ºǫ́Êý¾Ý¿âÃüÃûΪ“BOPS”£«±íʾվµãµÄ2£4¸ö×Ö·û¡£²âÊÔÊý¾Ý¿âÃüÃûΪ“OLPS|BOPS”£«“TEST”£¬ ¿ª·¢Êý¾Ý¿âÃüÃûΪ“OLPS|BOPS”+“TEST”£¬ÓÃģʽ£¨SCHEMA£¯USER£©µÄ²»Í¬À´Çø·Ö²»Í¬µÄÕ¾µã¡£
£¸£® INDEXÃüÃû£ºtable_name+column_name+index_type(1 byte)+idx,¸÷²¿·ÖÒÔÏ»®Ïߣ¨_£©·Ö¸î¡£¶àµ¥´Ê×é³ÉµÄcolumn name£¬È¡Ç°¼¸¸öµ¥´ÊÊ××Öĸ£¬¼ÓÄ©µ¥´Ê×é³Écolumn_name¡£È磺sample±ímember_idÉϵÄindex: sample_mid_idx news±ítitleÉϵÄunique index:news_titile_uidx£»
£¹£® SEQUENCEÃüÃû£ºseq_+table_name£»
¶þ¡¢ ×¢ÊÍ˵Ã÷
£±£® ±¾×¢ÊÍ˵Ã÷Ö÷ÒªÓÃÓÚPL/SQL³ÌÐò¼°ÆäËüSQLÎļþ£¬ÆäËü¿É×÷²Î¿¼£»
£²£® SQLPLUS½ÓÊܵÄ×¢ÊÍÓÐÈýÖÖ£º
¨D¨D Õâ¶ùÊÇ×¢ÊÍ
£¯£ª Õâ¶ùÊÇ×¢ÊÍ £ª£¯
REM Õâ¶ùÊÇ×¢ÊÍ
£³£® ¿ªÊ¼×¢ÊÍ£¬ÀàËÆJAVAKÖеĿªÊ¼×¢ÊÍ£¬Ö÷ÒªÁгöÎļþÃû£¬±àдÈÕÆÚ£¬°æȨ˵Ã÷£¬³ÌÐò¹¦ÄÜÒÔ¼°Ð޸ļǼ£º
REM
REM $Header: filename, version, created date,auther
REM
REM Copyright
REM
REM FUNCTION
REM function explanation
REM
REM NOTES
REM
REM MODIFIED £¨yy/mm/dd£©
REM who when - for what, recently goes first
£´£® ¿é×¢ÊÍ£¬Èç±í×¢ÊÍ£¬PROCEDURE×¢Ê͵ȣ¬Í¬JAVA:
/*
* This table is for TrustPass
* mainly store the information
* of TrustPass me
Ïà¹ØÎĵµ£º
ÔÚORACLEÖо³£»áÅöµ½×èÈûµÄÇé¿ö·¢Éú£¬Õâ¸öʱºòÎÒÃǾÍÐèÒª¿ìËÙµÄÕÒ³öµ¼ÖÂ×èÈûµÄÔÒò£¬²¢¾¡¿ìÅųýËü£¬ºÃÈÃϵͳÖØÐÂÕý³£ÔËÐС£
ÏÂÃæÒÔËÀËøΪÀý£¬À´¿´¿´ÈçºÎÕÒ³öµ¼ÖÂ×èÈûµÄ»á»°²¢½â¾öÎÊÌâ¡£
//SCOTT´°¿Ú1
SQL> select * from t2;
ID
----------
3
1
2
SQL> update t2 set i ......
10ÔÂ10ÈÕµÄÃÀ¹ú¾É½ðɽһÏÂÓ¿ÈëÁË4ÍòÈËÁ÷£¬ËûÃǾۼ¯ÔھɽðɽµÄMoscone»áÕ¹ÖÐÐÄ£¬ÖÜΧ81000¸ö¾Æµê´²Î»±»¶©¹ºÒ»¿Õ£¬¾É½ðɽÊÐÕþ¸®×¨ÃÅ·âËøÁËÖܱßÈýÌõµÀ·µÄ½»Í¨£¬ÒÔΪÕâЩÅÓ´óÈËÁ÷Ìṩ±ãÀû¡£ÕâЩÈ˶¼ÊÇÈ«ÇòITÒµ½çµÄ¾«Ó¢——´ÓIT¾ÞÍ·µÄÁìÐäµ½ÆÕͨµÄÆóÒµIT¼¼ÊõÈËÔ±£¬´Ó×Éѯ»ú¹¹µÄ·ÖÎöÈËÊ¿µ½¸÷ÐÐÒµµÄÐÅÏ¢»¯Ö÷¹Ü£¬µ ......
ÏîÄ¿ÖУ¬ÐèÒª½¨Á¢×ÔÔö³¤×ֶΣ¬µ«Åöµ½oracle±¾Éí²»Ö§³Ö´ËÖÖÀàÐ͵Ä×ֶΣ¬Ö»ºÃÓñðµÄ°ì·¨¡£
ORACLE×ÔÔö³¤×Ö¶ÎʵÏÖ£¨×ª£©
Ê×ÏÈ£¬ÄãÒªÓÐÒ»ÕÅ±í£¡
CREATE TABLE example(
&nbs ......
http://hi.baidu.com/aku88168/blog/item/fa727454ec008553564e00e8.html
CONNECT½ÇÉ«£º --ÊÇÊÚÓè×îÖÕÓû§µÄµäÐÍȨÀû£¬×î»ù±¾µÄ
ALTER SESSION --Ð޸ĻỰ
CREATE&nbs ......
ÏîÄ¿¿ª·¢ÖУ¬ÐèÒªÔ¶³Ì±¸·ÝÊý¾Ý¿â£¬ÒÔÏÂΪC#Ô¶³Ì±¸·ÝÊý¾Ý¿âµÄ´úÂë
/// <summary>
/// Êý¾Ý¿â±¸·Ý
/// </summary>
/// <param name="fileName">dmpÎļþÃû³Æ</param>
/// <param name="logFileName">logÎļþÃû³Æ</param>
/// <re ......