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

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²éѯϵͳÖÐ×èÈûÇé¿ö~

ÔÚORACLEÖо­³£»áÅöµ½×èÈûµÄÇé¿ö·¢Éú£¬Õâ¸öʱºòÎÒÃǾÍÐèÒª¿ìËÙµÄÕÒ³öµ¼ÖÂ×èÈûµÄÔ­Òò£¬²¢¾¡¿ìÅųýËü£¬ºÃÈÃϵͳÖØÐÂÕý³£ÔËÐС£
ÏÂÃæÒÔËÀËøΪÀý£¬À´¿´¿´ÈçºÎÕÒ³öµ¼ÖÂ×èÈûµÄ»á»°²¢½â¾öÎÊÌâ¡£
//SCOTT´°¿Ú1
SQL> select * from t2;
ID
----------
3
1
2
SQL> update t2 set i ......

Oracle£ºÒ»¸öIT¡°Èںϡ±¾ÞÍ·µÄµ®Éú

 10ÔÂ10ÈÕµÄÃÀ¹ú¾É½ðɽһÏÂÓ¿ÈëÁË4ÍòÈËÁ÷£¬ËûÃǾۼ¯ÔھɽðɽµÄMoscone»áÕ¹ÖÐÐÄ£¬ÖÜΧ81000¸ö¾Æµê´²Î»±»¶©¹ºÒ»¿Õ£¬¾É½ðɽÊÐÕþ¸®×¨ÃÅ·âËøÁËÖܱßÈýÌõµÀ·µÄ½»Í¨£¬ÒÔΪÕâЩÅÓ´óÈËÁ÷Ìṩ±ãÀû¡£ÕâЩÈ˶¼ÊÇÈ«ÇòITÒµ½çµÄ¾«Ó¢——´ÓIT¾ÞÍ·µÄÁìÐäµ½ÆÕͨµÄÆóÒµIT¼¼ÊõÈËÔ±£¬´Ó×Éѯ»ú¹¹µÄ·ÖÎöÈËÊ¿µ½¸÷ÐÐÒµµÄÐÅÏ¢»¯Ö÷¹Ü£¬µ ......

ORACLE×ÔÔö³¤×Ö¶ÎʵÏÖ£¨×ª£©

ÏîÄ¿ÖУ¬ÐèÒª½¨Á¢×ÔÔö³¤×ֶΣ¬µ«Åöµ½oracle±¾Éí²»Ö§³Ö´ËÖÖÀàÐ͵Ä×ֶΣ¬Ö»ºÃÓñðµÄ°ì·¨¡£ 
ORACLE×ÔÔö³¤×Ö¶ÎʵÏÖ£¨×ª£©
     Ê×ÏÈ£¬ÄãÒªÓÐÒ»ÕÅ±í£¡
       CREATE TABLE example(
          &nbs ......

oracle grant connect,resource to user°üÀ¨µÄȨÏÞ

http://hi.baidu.com/aku88168/blog/item/fa727454ec008553564e00e8.html
CONNECT½ÇÉ«£º    --ÊÇÊÚÓè×îÖÕÓû§µÄµäÐÍȨÀû£¬×î»ù±¾µÄ   
    
   ALTER    SESSION    --Ð޸ĻỰ   
   CREATE&nbs ......

C#±¸·ÝOracle´úÂë

ÏîÄ¿¿ª·¢ÖУ¬ÐèÒªÔ¶³Ì±¸·ÝÊý¾Ý¿â£¬ÒÔÏÂΪC#Ô¶³Ì±¸·ÝÊý¾Ý¿âµÄ´úÂë
 /// <summary>
/// Êý¾Ý¿â±¸·Ý
/// </summary>
/// <param name="fileName">dmpÎļþÃû³Æ</param>
/// <param name="logFileName">logÎļþÃû³Æ</param>
/// <re ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ