oracle ´æ´¢¹ý³ÌºÍº¯Êýѧϰ±Ê¼Ç
oracle ´æ´¢¹ý³ÌºÍº¯Êýѧϰ±Ê¼Ç
1¡¢´´½¨¹ý³ÌµÄÓï·¨£º
Code
create [or replace] procedure procedure_name
[(argument[{in|out|in out}] type,
argument[{in|out|in out}] type)] {is|as}
procedure_body
¼òµ¥µÄÀý×Ó£º
Code
create procedure RaiseError(
/*if p_Raise is true,then an unhandled error is raised.
if p_Raise is false,the procedure completes successfully.*/
p_Raise in boolean:=true,
p_ParameterA out number) as
begin
p_Parameter1:='abcdwxc';
p_Parameter2:=143;
end ParameterLength;
ɾ³ý¹ý³ÌÓï·¨£º
drop procedure procedure_name;
2¡¢´´½¨º¯ÊýµÄÓï·¨£º
Code
create [or replace] function function_name
[(argument[{in|out|in out}] type,
argument[{in|out|in out}] type)]
return return_type {is|as}
function_body
¼òµ¥º¯ÊýµÄÀý×Ó£º
create function ClassInfo(
p_Department classes.department%type,
p_Course classes.course%type)
return varchar is
v_CurrentStudents number;
v_MaxStudents number;
v_PercentFull numbe
Ïà¹ØÎĵµ£º
ÒÔÏÂÊÇÔÚºǫ́¸üÐÂÒ×ÍØERPÊý¾Ý¿âʱÓöµ½µÄÒ»¸öÎÊÌâ:
1.ÔÚDB14Êý¾Ý¿âÖн«ÁϼþºÅP44¿ªÍ·,²¢ÇÒÆ·ÃûΪ"ËÜÁÏ´ü"µÄÁϼþ¸ÄΪÏûºÄÐÔÁϼþ.
Õâ¸ö¼òµ¥: UPDATE DB14.ima_file SET ima70 = ‘Y’ WHERE ima01 like ‘P44%’ AND ima0 ......
·½·¨Ò»£º
----------------------------------------------------------------
---Muti-row to line(col2row)
----------------------------------------------------------------
create or replace type str_tab is table of varchar2(20);
/
grant all on str_tab to public;
create public synonym str_tab for ......
ÒÔÏÂÁгöµÄÊÇOracle
Óû§¹ÜÀí¹ý³ÌÖг£ÓõÄһЩָÁÒÔ¹©´ó¼Ò²Î¿¼¡£
Oracle
Óû§¹ÜÀíÖ®Ò»¡¢´´½¨profile
Îļþ¡£
1.
SQL>Create
profile
ÎļþÃû limit
2.
  ......
±¾ÎĽéÉÜÁË8¸ö³£Óõļà¿ØÊý¾Ýshell½Å±¾¡£Ê×ÏȻعËÁËһЩDBA³£ÓõÄUnixÃüÁÒÔ¼°½âÊÍÁËÈçºÎͨ¹ýUnix CronÀ´¶¨Ê±Ö´ÐÐDBA½Å±¾¡£ÍøÉÏÒ²ÓкöàÀàËƵÄÎÄÕ£¬µ«»ù±¾É϶¼²»ÄÜÕý³£ÔËÐУ¬»¨µãʱ¼äÖØÐÂÕûÀíÁËÏ£¬ÒÔºó¾ÍÄÜÖ±½ÓʹÓÃÁË¡£
Ò»£®Í¬Ê±ÎÄÕ»¹½éÉÜÁË8¸öÖØÒªµÄ½Å±¾À´¼à¿ØOracleÊý¾Ý¿â£º
1.¼ì²éʵÀýµÄ¿ÉÓÃÐÔ
2.¼ì²é¼àÌýÆ÷µ ......
2009-04-22 22:00
À´Ô´£ºÖйú
IT
ʵÑé
ÊÒ ×÷ÕߣºØýÃû
Oracle
¿Í
Ȥ
¶ËÓë·þ
Îñ
Æ÷¶ËµÄ
Á¬
½ÓÊÇͨ
¹ý
¿Í
Ȥ
¶Ë
·¢
³ö
Á¬
½Ó
Çë
Çó£¬ÓÉ·þ
Îñ
Æ÷¶Ë
¼à
ÌýÆ÷
¶Ô
¿Í
Ȥ
¶Ë
Á¬
½Ó
Çë
Çó
½ø
ÐкϷ¨
¼ì²é
£¬Èç¹û
Á¬
½Ó
Çë
ÇóÓÐЧ£¬
Ôò½ø
ÐÐ
Á¬
½Ó£¬·ñ
Ôò
¾Ü
¾ø¸ÃÁ¬
½Ó¡£ ......