个人使用
t1000.unix-center.net<!DOCTYPE html>
<html>
<head>
<link href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/themes/base/jquery-ui.css" rel="stylesheet" type="text/css"/>
<script language="javascript" src="jquery-1.4.js"></script>
<script language="javascript" src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/jquery-ui.min.js"></script>
<script>
$(document).ready(function() {
$("#click").click(function(){
//alert("ok");
$("#dialog").dialog({
//autoOpen: false,
modal:true,
width:270,
height:280,
title:"添加（修改）商品类信息",
buttons: {
"Ok": function()
{
$(this).dialog("close");
},
"Cancel": function()
{
$(this).dialog("close");
}
}
});
});
});
</script>
</head>
<body style="font-size:62.5%;">
<button id="click" >click</button>
<div id="dialog" title="Dialog Title">
<include file="textDialog_inculde.html" />
</div>
</body>
</html>
=======================
CREATE OR REPLACE FUNCTION test_fun(
s varchar2, e varchar2) return number is
start_date date;
end_date date;
cre_date date;
begin
start_date := to_date(s,'YYYY/MM/DD');
end_date := to_date(e,'YYYY/MM/DD');
select sysdate into cre_date from dual;
loop
insert into rep_date_temp values(to_char(start_date,'MM/YYYY'), cre_date);
start_date := add_months(start_date,1);
if start_date > end_date then
exit;
end if;
end loop;
commit;
delete from rep_date_temp where cre_time = cre_date;
return 0;
end;
=======================
页:
[1]