oracle cartridge¿ª·¢
ÄÄλÐÖµÜÓÐoracle cartradge¿ª·¢×ÊÁÏ£¬Äܲ»Äܹ²Ïíһϣ¿Ð»Ð»£¡
ûÓÐÌý˵¹ý£¬OracleÌ«ÅÓ´óÁË
ÎÒÒ²ÊǸսӴ¥£¬²»Çå³þÔõô×ö£¬Ö»ÖªµÀÕâ¸ö¼¼ÊõÊÇÓÃÀ´¿ª·¢Öмä¼þµÄ
End_rbody_60301247//-->
¸Ã»Ø¸´ÓÚ2009-10-11 09:05:28±»¹ÜÀíԱɾ³ý
¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[0]
ÒýÓÃ
¾Ù±¨
¹ÜÀí
TOP
Ïà¹ØÎÊ´ð£º
ÈÕÇ°ÓÃociº¯Êý²éѯoracleÊý¾Ýʱ³öÏÖ¸öÎÊÌ⣬¾ÍÊÇÔÚ²éѯµ½dateÀàÐ͵ÄÊý¾Ýʱ£¬Ê¹ÓÃpl/sql ²éѯoracle¿âÖеÄÊý¾ÝÏÔʾÊÇ
2009-9-29 12:12:12
µ«ÊÇͨ¹ýÓï¾äselect * from tablename ²éѯ£¬Ê¹ÓÃoci_fetch_array£¨£© ......
Oracle´æ´¢¹ý³ÌÈçÏÂ,ÓÃÓαêÊä³ö½á¹û:
procedure proc_xcxf_detail(v_sbh varchar2,
v_szpq varchar2,
&nbs ......
create or replace function GetWorkBeginTime()
return date is
myDate date;
begin
myDate := trunc(sysdate-1)+8/24;
return myDate;
end;
......
ÂÒÂë²úÉúÊÇÓÉÓÚ¼¸¸ö×Ö·û¼¯Ö®¼äת»»²»Æ¥ÅäÔì³É£¬·ÖÒÔϼ¸ÖÖÇé¿ö£º£¨×¢£º×Ö·û¼¯Ö®¼äÈç¹û²»´æÔÚ×Ó¼¯¡¢³¬¼¯¶ÔÓ¦¹ØϵʱµÄÇé¿ö²»Ó迼ÂÇ£¬ÒòΪÕâÖÖÇé¿öÏÂ×Ö·û¼¯Ö®¼äת»»±Ø²úÉúÂÒÂ룩
1£©·þÎñÆ÷¶ËÊý¾Ý¿ ......
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......