ÈçÌ⣬ÓÐÕâ2¸ö·½ÃæµÄ¹¤×÷»ú»á£¬ÔËάÖ÷Òª¸ºÔð¹©Ó¦Á´µÄÔËά£¬²é¿´sqlÖ´Ðмƻ®Ö®ÀàµÄ£¬ÓеãÏñDBAµÄ¸Ð¾õ£¬²»¹ýÕâ¸ö¹«Ë¾±È½ÏС£¬ERP ¶þ´Î¿ª·¢Õâ¸ö¹¤×÷µÄ¹«Ë¾ºÜ´ó£¬ÊÇÒ»¼ÒÏã¸ÛÉÏÊй«Ë¾£¬ÎÒ¶ÔERP²»ÊǺÜÁ˽⣬²»ÖªµÀÓÐûÓÐǰ;£¬ËùÒÔÏëÈôó¼Ò°ïæÄøöÖ÷Òâ»ò±È½ÏÏÂÄĸöºÃ£¡
ÒýÓÃ
ÈçÌ⣬ÓÐÕâ2¸ö·½ÃæµÄ¹¤×÷»ú»á£¬ÔËάÖ÷Òª¸ºÔð¹©Ó¦Á ......
ÎÒÏÖÔÚÓÐ2Õűí Ò»ÕÅBASE±í Ò»ÕÅDETAIL±í
±í½á¹¹ÄÚÈÝÈçÏÂBASE±í
×Ö¶Î LOT MAG DEVICE   ......
ÓÃSQLÓï¾ä²åÈëÒ»ÐÐÊý¾Ýʱ£¬ÓеÄ×Ö¶ÎÊÇСÊý£»µ«ÊÇÔÚÊý¾Ý¿âÀïÃæ¿´µ½Oracle×Ô¶¯ËÄÉáÎåÈëÁË¡£ÏÖÔÚÒª±£ÁôСÊý»òÕß±£ÁôÒ»¶¨µÄСÊýλÊý£¬¸ÃÔõô°ì£¿OracleÊý¾Ý¿â¸ÃÔõôÉèÖã¿
ÄãµÄÁÐÊôÐÔÊÇÔõôÉ趨µÄ£¿
SQL code:
--ËÄÉáÎåÈëСÊý
select round(0.3565,3) from dual;
ROUND(0.3565,3)
0.357
--·ÇËÄÉáÎåÈëСÊý
select tru ......
OracleÐÂÊÖ£¬ÇóOracle¾µä½Ì²Ä£¬1µ½2±¾£¬ÒÔǰÓõÄÊÇsql server¡£
½Ì²ÄÒª¾µäµÄ£¬½²½âOracleºÍPL/SQLµÄ¡£
¾«Í¨Oracle10g PLSQL±à³Ì.pdf
¡¶oracle pl/sql ʵÀý¾«½â¡· Benjamin Rosenzweig
¡¶oracle database 11g sql¿ª·¢Ö¸ÄÏ¡·Jason Price
ÏÈ´Ó»ù´¡¿´Æð£¬Oracle9i Database Administration Fundamentals
......
°²×°oracle¿Í»§¶Ë11gºÍ10g¶¼°²×°Ê§°Ü£¬±¨´íÈçÏ£º
"ÎÞ·¨ÔÚwindowsÆô¶¯²Ëµ¥»ò×ÀÃæÉÏ´´½¨Ïî"¡£
·þÎñÆ÷ÅäÖÆ£¬64λ£¬Ó¢ÎÄwindows Server 2003£¬Ã»Óа²×°É±¶¾Èí¼þ¡£
°æ±¾ÎÊÌâ¡£32λ¿Í»§¶Ë Ö»ÄÜ×°ÔÚ32λwindowsϵͳÉÏ¡£¡£
¿´¿´ÏÂÔØµÄÊǶàÉÙλµÄ³ÌÐò£¬ºÍ×Ô¼ºµÄϵͳÊÇ·ñ¼æÈÝ¡£
¶÷£¬²éһϼæÈÝÐÔ°É¡ ......
ÕâÊÇÎÒдµÄ´æ´¢¹ý³Ì£¬ÏÖÔÚͬÊÂ˵Ҫ·µ»ØÒ»¸öÓα꣬´ó¼Ò˵ҪÔÚÕâ¸ö¹ý³Ì×öÄÄЩÐ޸ģ¬ÎÒ²»¶®ÎÒµÚÒ»´Îд´æ´¢¹ý³Ì£¬Ï£Íû´óÏÀ°ï°ï棬¸Ð¼¤²»¾¡£¬ÔÚÏßµÈ
create or replace procedure pro_activity (a in varchar2)
is
v_name VARCHAR2(256);
v_sdate VARCHAR2(256);
v_edate VARCHA ......