ÈçºÎÈëÃÅORACLEÊý¾Ý¿â¿ª·¢
³õѧORACLE£¬Ö®Ç°¿´¹ýµÄ¶¼ÊÇЩ¹ÜÀí·½ÃæµÄÊ飬¹Ù·½Îĵµ¿´¹ýCONCEPTS,ADMINISTRATOR'S GUIDE£¨ÕýÔÚ¿´£©
¿ÉºÃÏñ¸Õ±ÏÒµ¾Í¸ã¹ÜÀí²»Ì«ÏÖʵ£¬²îµÄ֪ʶҲ»¹Í¦¶à£¬ËùÒÔÏë´Ó¿ª·¢ÏÈ×öÆð
×î½ü¿´µ½Óмҹ«Ë¾ÔÚÕÐORACLEÓ¦ÓÃÊý¾Ý¿â¿ª·¢µÄ£¬ÒªÇóÉÏдµÄÊÇ ¡°ÊìϤORACLE ,PL/SQL,LINUX,SHELL¡±
ÎÒÏÖÔÚ¿´Ò»±¾ÖÐÎÄÊé½Ð¡¶ORACLE DATABASE 10G PL/SQL¡·
Çë´ó¼Ò°ïæÍƼöÏÂÓÐûÓÐʲôºÃµãµÄÈëÃÅÊý¾Ý¿â¿ª·¢·½ÃæµÄ½Ì²Ä
ºÇºÇ ˵À´²ÑÀ¢ ÎÒÉõÖÁ»¹²»Ì«Á˽âÊý¾Ý¿â¿ª·¢µ½µ×ÊÇ¿ª·¢³ö¸öʲô¶«Î÷À´
×îºÃÍƼöµÄÊéÉÔ΢±¡Ò»µã ÒòΪ¹À¼ÆÔµ×ÍøÉ꿪ʼ 10Ô¾ͱÊÊÔÁË
ÎÒ¿´µÄµÚÒ»±¾ÊéÊǸǹúÇ¿µÄ <ÉîÈëdz³öORACLE> »¹²»´í.. ¶ÔOracle ½á¹¹Õâ¿é½²µÄ»¹±È½Ïϸ£¬¿ÉÒÔ×öÈëÃŵÄÊé¿´£¬Â¥Ö÷×ö¿ª·¢µÄ»°£¬»¹µÄ¿´¿´Ð´SQL·½ÃæµÄ°É.. ÎÒÖ÷Òª¸ãά»¤Õâ¿é..
֪ʶÊÇÂýÂý»ýÀ۵ģ¬ÒÔºó¾Í¶®µÄÔ½À´Ô½¶àÁË.
ºÇºÇ °¢Àï°Í°Í
¶Ô ÎÒÏÖÔÚ¾ÍÊÇÏë¶ÍÁ¶Ò»ÏÂ×Ô¼ºÐ´SQLÄÜÁ¦
ÓÐʲôºÃµÄ½¨ÒéÂð
ÓеÄʱºòÔÚÂÛ̳Àï¿´µ½Ò»Ð©Ìû×ÓÀïµÄSQLÎÒ¿´¶¼¿´²»¶®
Î
Ïà¹ØÎÊ´ð£º
ÈÕÇ°ÓÃociº¯Êý²éѯoracleÊý¾Ýʱ³öÏÖ¸öÎÊÌ⣬¾ÍÊÇÔÚ²éѯµ½dateÀàÐ͵ÄÊý¾Ýʱ£¬Ê¹ÓÃpl/sql ²éѯoracle¿âÖеÄÊý¾ÝÏÔʾÊÇ
2009-9-29 12:12:12
µ«ÊÇͨ¹ýÓï¾äselect * from tablename ²éѯ£¬Ê¹ÓÃoci_fetch_array£¨£© ......
°²×°11gµÄ06,´ò²¹¶¡Éýµ½07£¬´ÓODBCÀïÃæ¿´£¬ÓÐ
Oracle in OraOdac11g_home1 11.01.00.07
´Ó×¢²á±í¿´HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ÏÂÃæµÄDriverºÍSetup¶¼ÊÇÎҵݲװ·¾¶
"D:\\app\\Ad ......
ÎÒдµÄÒ»¸ö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 ......