oracleÈçºÎÕÆÎÕµÁ°æÓû§£¿
oracleÊÇÔõô֪µÀ±ðÈËÓõÁ°æµÄ£¿
ͨ¹ýʲôÇþµÀ×öµ½µÄ£¿
·Ö²»¶à²»ºÃÒâ˼
²»Á˽⣬²»¹ýoracleÒª¼ÓÕâÑùµÄ¹¦ÄÜ£¬Ì«¼òµ¥ÁË¡£
ûÈËÌý˵¹ýÂð£¿
°æÈ¨·¨ÂÉÊֶΰɣ¬ÆäËüÁ˽âÖÐ...
ʹÓÃoracleµÄÓû§£¬ÓÐÊÚȨÊéµÄΪÊÚȨÓû§£¬Ã»ÓÐÊÚȨÊéµÄΪδÊÚȨÓû§£¬Ò²¾ÍÊÇ·Ç·¨Óû§£»
oracleµÄÓªÏú²ßÂÔÖÐûÓÐÕý°æºÍµÁ°æÖ®·Ö£»ÔÚËûÃÇÍøÕ¾ÉÏ×¢²á¸öÓû§¾Í¿ÉÒÔʹÓÃÊÚȨÓû§Ò»ÑùµÄORACLE°æ±¾ÁË
±»¶¢ÉϵÄÒ»°ã¶¼ÊÇ´óÐÍµÄÆóÊÂÒµµ¥Î»£¬¹À¼ÆÂ¥Ö÷Ò²ÊÇÉíÔÚÕâÑùµÄ¹«Ë¾µ±ÖÐ
²»¶® ·¹ý ~~~~~~~~~~~~~
¹Ø×¢¡£¡£¡£¡£
Ïà¹ØÎÊ´ð£º
»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
ÎÒдµÄÒ»¸öJob
declare
job1 integer;
begin
dbms_job.submit(job1,
'Sale_FinanceUseFee(4,null,null,null);',
TRUNC(SYSDATE)+1.103, ......
µ¼³ö¡¢µ¼Èë¶¼ÊÇ oracle 10g ¡£
ÔÚµ¼Èë¹ý³ÌÖгöÏÖÈçÏÂÇé¿ö£º
IMP-00017: ÓÉÓÚ ORACLE ´íÎó 6550, ÒÔÏÂÓï¾äʧ°Ü:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4E014E50 ......
Óиö´æ´¢¹ý³ÌÓÐÈý¸öInt²ÎÊýºÍÒ»¸öOut²ÎÊý.
Ö´ÐÐʱÏȽ«Ò»Ð©Êý¾Ý²åÈëµ½Ò»¸ö±íÖÐ.È»ºóÔÙ´Ó±íÖÐÈ¡³öÊý¾Ý½øÐÐÐÐתÁÐ,ºÏ¼ÆµÈÂß¼.½«´¦Àí½á¹û·Åµ½Ò»¸ö±íÖÐ.²¢½«Idͨ¹ýOut²ÎÊý·µ»Ø.
µ«ÔÚÖ´ÐÐʱ¿ÉÒÔ»ñÈ¡µ½OutÖµ,µ«¾ÍÊÇà ......
sqlplusÁ¬½ÓOracleÊý¾Ý¿âµÄÕû¸öÁ÷³Ì£¬
ÀýÈç sqlplus /nolog
conn system/oracle£¨ÃÜÂ룩
Õâ¸öÁ¬½ÓOracleµÄÕû¸ö»úÖÆÊÇʲô£¨×¢ÖØÓÚÁ¬½ÓµÄÔÀíÉÏ£©
Èç¹ûÓÐ˶®»òÓÐÏà¹ØÄÚÈݸøÓèÌáÊ ......