oracle ´æ´¢¹ý³ÌʵÀý
/*²»´øÈκβÎÊý´æ´¢¹ý³Ì(Êä³öϵͳÈÕÆÚ)*/
create or replace procedure output_date is
begin
dbms_output.put_line(sysdate);
end output_date;
/*´ø²ÎÊýinºÍoutµÄ´æ´¢¹ý³Ì*/
create or replace procedure get_username(v_id in number,v_username out varchar2)
as
begin
select username into v_username from tab_user where id = v_id; --±äÁ¿¸³Öµ
exception
when no_data_found then
raise_application_error(-20001,'ID²»´æÔÚ!');
end get_username;
Ïà¹ØÎĵµ£º
´´½¨ÐµÄÓû§Ê±£¬ÒªÖ¸¶¨default tablespace£¬·ñÔòËü»á°Ñsystem±í¿Õ¼äµ±³É×Ô¼ºµÄȱʡ±í¿Õ¼ä¡£ÕâÑù×öÊDz»ÌᳫµÄ¡£¹À¼ÆÔÀ´´´½¨Ä³¸öÓû§µÄʱºòûÓÐÖ¸¶¨È±Ê¡±í¿Õ¼ä£¬¶øÏÖÔÚËüʹÓÃϵͳ±í¿Õ¼äµÄȨÏÞ±»DBA¸øÊÕ»ØÁË¡£
ÏÈÓõļòµ¥µÄ°ì·¨ÊÔÊÔ£¬Ò»°ãȱʡµÄORACLE°²× ......
http://hi.baidu.com/wzbg/blog/item/005f9c098e31a12f6b60fbfb.html
Oracle±í½éÉÜ--Ë÷Òý×éÖ¯±í
2010-01-12 16:03
Ë÷Òý×éÖ¯±í(IOT)²»½ö¿ÉÒÔ´æ´¢Êý¾Ý£¬»¹¿ÉÒԴ洢Ϊ±í½¨Á¢µÄË÷Òý¡£Ë÷Òý×éÖ¯±íµÄÊý¾ÝÊǸù¾ÝÖ÷¼üÅÅÐòºóµÄ˳Ðò½øÐÐÅÅÁеģ¬ÕâÑù¾ÍÌá¸ßÁË·ÃÎʵÄËÙ¶È¡£µ«ÊÇÕâÊÇÓÉÎþÉü²åÈëºÍ¸üÐÂÐÔÄÜΪ´ú¼ÛµÄ(ÿ´ÎдÈëºÍ¸üкó¶¼Òª ......
³£ÓõÄÊý¾Ý¿â×Ö¶ÎÀàÐÍÈçÏ£º
×Ö¶ÎÀàÐÍ ÖÐÎÄ˵Ã÷ ÏÞÖÆÌõ¼þ ÆäËü˵Ã÷
CHAR ¹Ì¶¨³¤¶È×Ö·û´® ×î´ó³¤¶È2000 bytes
VARCHAR2 ¿É±ä³¤¶ÈµÄ×Ö·û´® ×î´ó³¤¶È4000 bytes ¿É×öË÷ÒýµÄ×î´ó³¤¶È749
NCHAR ¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¹Ì¶¨³¤¶È×Ö·û´® ×î´ó³¤¶È2000 bytes
NVARCHAR2 ¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¿É±ä³¤¶È×Ö·û´® ×î´ó³¤¶È4000 bytes
DATE È ......
ºÃ¾Ã沒ÓÐ來寫Ïà關FormµÄÎÄÕÂÁË¡£
ÏÂÃæ給´ó¼ÒÊÕ¼¯Ò»ÏÂÏà關Oracle FormµÄÏûÏ¢Ìáʾ
FND_MESSAGE.SET_STRING(‘<Message>’)¡£
´ËÏûÏ¢Ò»¶¨Òª結ºÏFND_MESSAGE.SHOW»òFND_MESSAGE.ERROR»òFND_MESSAGE.HINT»òFND_MESSAGE.WARN»òFND_MESSAGE.QUESTIONʹÓòÅÄ ......
¹ØÓÚSGAÉèÖõÄÒ»µã×ܽá
±¾×ܽ᲻Õë¶ÔÌØÀý£¬½ö¶Ô·þÎñÆ÷Ö»´æÔÚOS + ORACLE ΪÀý£¬Èç¹û´æÔÚÆäËûÓ¦ÓÃÇë×ÃÇ鿼ÂÇ
дÕâ¸öÒ²ÊÇÒòΪ½üÀ´ÕâÖÖÖØ¸´ÐÔµÄÎÊÌâ·¢ÉúµÄÌ«¶àËùµ¼ÖµÄ
Ê×ÏȲ»ÒªÃÔÐÅSTS,SG,OCP,EXPERT µÈ¸ø³öµÄÈκν¨Òé¡¢ÄÚ´æ°Ù·Ö±ÈµÄ˵·¨
»ù±¾ÕÆÎÕµÄÔÔòÊÇ£¬ data buffer ͨ³£¿ÉÒÔ¾¡¿ÉÄܵĴó£¬shared_pool_size ÒªÊÊ¶È ......