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;
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
SELECT * from ALL_SOURCE
where TYPE='PROCEDURE' AND TEXT LIKE
'%0997500%';
--²éѯALL_SOURCEÖУ¬£¨½Å±¾´úÂ룩ÄÚÈÝÓë0997500Ä£ºýÆ¥ÅäµÄÀàÐÍΪPROCEDURE£¨´æ´¢¹ý³Ì£©µÄÐÅÏ¢¡£
¸ù¾ÝGROUP
BY TYPE
¸ÃALL_SOURCEÖÐÖ»ÓÐÒÔÏÂ5ÖÖÀàÐÍ
1 FUNCTION
2 JAVA
SOURCE
3 PACKAGE
4 P ......
¸ù¾Ý±í½á¹¹Éú³ÉJavaÎļþµÄ¹¤¾ß£¬ÔÚÈ¡µÃ±íµÄ×Ö¶ÎʱÈçºÎÈ¡µÃ±íµÄ¸÷ÖÖÐÅÏ¢ºÍ×¢ÊÍ£¬¾¶à·½ËÑѰÕÒµ½ÈçÏÂ×ÊÁϱ¸Ó㺠oracle£º
user_tab_comments;±í×¢ÊÍ
user_col_comments;±í×Ö¶Î×¢ÊÍ
Ò ......
Ò». µ¼³ö¹¤¾ß exp
1. ËüÊDzÙ×÷ϵͳÏÂÒ»¸ö¿ÉÖ´ÐеÄÎļþ ´æ·ÅĿ¼/ORACLE_HOME/bin
expµ¼³ö¹¤¾ß½«Êý¾Ý¿âÖÐÊý¾Ý±¸·ÝѹËõ³ÉÒ»¸ö¶þ½øÖÆÏµÍ³Îļþ.¿ÉÒÔÔÚ²»Í¬OS¼äÇ¨ÒÆ
ËüÓÐÈýÖÖģʽ£º
a. Óû§Ä£Ê½£º µ¼³öÓû§ËùÓжÔÏóÒÔ¼°¶ÔÏóÖÐµÄ ......
http://hi.baidu.com/wzbg/blog/item/005f9c098e31a12f6b60fbfb.html
Oracle±í½éÉÜ--Ë÷Òý×éÖ¯±í
2010-01-12 16:03
Ë÷Òý×éÖ¯±í(IOT)²»½ö¿ÉÒÔ´æ´¢Êý¾Ý£¬»¹¿ÉÒԴ洢Ϊ±í½¨Á¢µÄË÷Òý¡£Ë÷Òý×éÖ¯±íµÄÊý¾ÝÊǸù¾ÝÖ÷¼üÅÅÐòºóµÄ˳Ðò½øÐÐÅÅÁеģ¬ÕâÑù¾ÍÌá¸ßÁË·ÃÎʵÄËÙ¶È¡£µ«ÊÇÕâÊÇÓÉÎþÉü²åÈëºÍ¸üÐÂÐÔÄÜΪ´ú¼ÛµÄ(ÿ´ÎдÈëºÍ¸üкó¶¼Òª ......