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
Ïà¹ØÎĵµ£º
Ïȶ¨ÒåÒ»¸öcursor:
Procedure P_MYPROC (
PI_PARAM VARCHAR2
)IS
VI_A&nb ......
ÅäÖÃÎļþ£º
<hibernate-mapping>
<class name="vo.SshPost" table="ssh_post" >
<!-- <cache usage="read-write"/>-->
<id name="postId" type="java.lang.String">
......
µ¥Ðк¯Êý:
º¯ÊýÀà±ð:
µ¥ÐÐ:·µ»Øµ¥¸ö½á¹û:substr,length
¶àÐÐ:·µ»Ø¶à¸ö½á¹û,any,all
µ¥ÐеķÖÀà:
×Ö·ûÀ࣬ÈÕÆÚÀ࣬Êý×ÖÀ࣬ת»»À࣬ͨÓÃÀà
1.×Ö·ûÀà
ת»»´óСд:
lower:ת»»ÎªÐ¡Ð´
Select ENAME,LOWER(ENAME) from EMP
upper:ת»»Îª´óд
Select upper( ......
10ÔÂ10ÈÕµÄÃÀ¹ú¾É½ðɽһÏÂÓ¿ÈëÁË4ÍòÈËÁ÷£¬ËûÃǾۼ¯ÔھɽðɽµÄMoscone»áÕ¹ÖÐÐÄ£¬ÖÜΧ81000¸ö¾Æµê´²Î»±»¶©¹ºÒ»¿Õ£¬¾É½ðɽÊÐÕþ¸®×¨ÃÅ·âËøÁËÖܱßÈýÌõµÀ·µÄ½»Í¨£¬ÒÔΪÕâЩÅÓ´óÈËÁ÷Ìṩ±ãÀû¡£ÕâЩÈ˶¼ÊÇÈ«ÇòITÒµ½çµÄ¾«Ó¢——´ÓIT¾ÞÍ·µÄÁìÐäµ½ÆÕͨµÄÆóÒµIT¼¼ÊõÈËÔ±£¬´Ó×Éѯ»ú¹¹µÄ·ÖÎöÈËÊ¿µ½¸÷ÐÐÒµµÄÐÅÏ¢»¯Ö÷¹Ü£¬µ ......
תÔØ
from: http://cid-4e5d038451e31a25.spaces.live.com/blog/cns!4E5D038451E31A25!140.entry
create or replace procedure P_QuerySplit(
sqlscript varchar2, --±íÃû/SQLÓï¾ä
pageSize integer, ......