SQL code:
DECLARE
var_cursor SYS_REFCURSOR;
BEGIN
procedure_name(p_1 => NULL,
p_2 => NULL,
p_3 => NULL,
p_cursor => var_cursor);
FOR i IN var_cursor LOOP
dbms_output.put_line(i.col_name);
END LOOP;
END;
ÎÒµ ......
ÈçÌ⣬ÎÒµÄÊÇHP 4411S£¬²»ÖªµÀÓë»úÆ÷ÓÐûÓйØÏµ£¬ÎÒͬʵÄIBMµÄ¾Í¿ÉÒÔ°²×°ÉÏ£¬ÎÒÓÃËüµÄoracle¿Í»§¶Ë°²×°³ÌÐò¶¼²»ÄÜÔËÐУ¬²»ÖªÊÇɶÔÒò£¬»¹ÓÐÎÒ»»ÁíÒ»¸ö°æ±¾µÄoracle¿Í»§¶Ë°²×°³ÌÐòʱ£¬°²×°³É¹¦£¬µ«°²×°PL/SQL DeveloperºóËÀ»îµÇ¼²»ÉÏ£¨×¢£ºtnsnames.oraÒѾÅäÖã©£¬³öÏÖÒ»¸ö¿´²»³ÉÈκÎ×ÖµÄÌáʾ¿ò£¬Ö»ÓÐÒ»¸öÈ·¶¨°´Å¥£¬Çë¸÷Î ......
Àý:10/8/2009 8:22:20 PM ÕâÑùµÄ¸ñʽÈçºÎת»»³Édate¸ñʽ,×îºÃÊÇ24Ð¡Ê±ÖÆµÄ
Çë´ó¼ÒÖ¸µã,лл
select to_date('10/8/2009 8:22:20','dd/mm/yyyy hh24:mi:ss' ) from DUAL;
SQL code:
select to_date('10/8/2009 8:22:20 PM','dd/mm/yyyy hh:mi:ss AM','NLS_DATE_LANGUAGE = American') from ......
require_once ("smarty/libs/Smarty.class.php");
require_once("adodb/adodb.inc.php");
$staID = "54511";
$days = 0;
$dsn = 'oci8://****:*******@192.168.39.113:1521/portaldb?charset=UTF8';
$db = ......
Çë½Ì£ºoracleÊý¾Ý¿â½ø³ÌÕ¼ÓÃÒ»Ö±²»¶ÏÉÏÕÇ£¬´óÔ¼20¶àÌìºó£¬¾Í»áµ¼ÖÂϵͳÐéÄâÄÚ´æ²»×㣬Á¬½Ó¶Ïµô£¬ÇëÎÊÔõô»áÊ£¿
Ö»ÓÐÖØÆô·þÎñÆ÷²Å¿ÉÒÔÔÙÕý³£ÔËÐУ¬ÖÜÆÚÐÔ³öÏÖÐéÄâÄÚ´æ²»×ãÏÖÏó£¡
¼±£¡£¡£¡£¡ÏȸÐл´Í½Ì£¡
which os ?
oracle version?
ÄãµÄ·þÎñÆ÷ÊÇʲôÁ¬½Ó·½Ê½Ñ½£¿
ÒýÓÃ
which os ?
oracle version?
windows xp ......
ÇóORACLE°²×°Îļþ£¬Ð»Ð»£¡
¸ø¸ö·¾¶Ò²ÐÐ
Áô¸öÓÊÏ䣺xiangziyanhuang@126.com
ÎÒÒѾ½«°²×°Îļþ·¢µ½ÄãµÄÓÊÏäÀïÁË£¬¾´Çë²éÊÕ!
www.oracle.com
SQL code:
---ÄãÖÁÉٵøæËßÈ˼Òʲôƽ̨ϰ²×°Oracleʲô°æ±¾°É£¿
¹Ù·½ÏÂÔØ
ÉÏotnµÄdownloadƵµÀ°É£¬¹ØÓÚoracleµÄʲô¶¼ÓУ¬×Ô¼ºÕÒÏëÒªµÄϰÉhttp://otn.oracl ......