Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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 EXP/IMP µ¼³öµ¼È빤¾ßµÄʹÓÃ


Ò». µ¼³ö¹¤¾ß exp
1. ËüÊDzÙ×÷ϵͳÏÂÒ»¸ö¿ÉÖ´ÐеÄÎļþ ´æ·ÅĿ¼/ORACLE_HOME/bin
   expµ¼³ö¹¤¾ß½«Êý¾Ý¿âÖÐÊý¾Ý±¸·ÝѹËõ³ÉÒ»¸ö¶þ½øÖÆÏµÍ³Îļþ.¿ÉÒÔÔÚ²»Í¬OS¼äÇ¨ÒÆ
   
   ËüÓÐÈýÖÖģʽ£º
       a. Óû§Ä£Ê½£º µ¼³öÓû§ËùÓжÔÏóÒÔ¼°¶ÔÏóÖÐµÄ ......

[oracle 10g]ÃüÁîÐÐÆô¶¯ORACLE·þÎñ¼°Ë³Ðò

°¸Àý˵Ã÷
ΪÁ˽ÚԼϵͳ×ÊÔ´£¬ÎÒÃÇÔÚÁ·Ï°oracleµÄµçÄÔÖо­³£»á½«oracleµÄ¸÷ÖÖ·þÎñÉèΪÊÖ¶¯µÄÆô¶¯Ä£Ê½£¬ÓÐʱΪÁË·½±ãÆÚ¼ä²»Ô¸Òâ´ò¿ª·þÎñ¹ÜÀí´°¿Ú£¬Òò´ËÌØÔڴ˼ǼһÏÂÃüÁîÐÐÆô¶¯·½·¨¡£
ÎÒÓÐÁ½¸öÀý³Ì£ºorcl--×öÄ¿±êÊý¾Ý¿â£»test--×ö»Ö¸´Ä¿Â¼Êý¾Ý¿â¡£
Ò»°ãÀ´ËµË³ÐòÈçÏ£º
C:\>net start oracleserviceorcl
OracleServic ......

Oracle×Ö·û¼¯ÎÊÌâ×ܽá

¡¡¡¡Ò»¡¢Ê²Ã´ÊÇoracle×Ö·û¼¯
¡¡¡¡Oracle×Ö·û¼¯ÊÇÒ»¸ö×Ö½ÚÊý¾ÝµÄ½âÊ͵ķûºÅ¼¯ºÏ,ÓдóС֮·Ö,ÓÐÏ໥µÄ°üÈݹØÏµ¡£ORACLE Ö§³Ö¹ú¼ÒÓïÑÔµÄÌåϵ½á¹¹ÔÊÐíÄãʹÓñ¾µØ»¯ÓïÑÔÀ´´æ´¢£¬´¦Àí£¬¼ìË÷Êý¾Ý¡£ËüʹÊý¾Ý¿â¹¤¾ß£¬´íÎóÏûÏ¢£¬ÅÅÐò´ÎÐò£¬ÈÕÆÚ£¬Ê±¼ä£¬»õ±Ò£¬Êý×Ö£¬ºÍÈÕÀú×Ô¶¯ÊÊÓ¦±¾µØ»¯ÓïÑÔºÍÆ½Ì¨¡£
¡¡¡¡Ó°ÏìoracleÊý¾Ý¿â×Ö·û¼¯×îÖ ......

oracle±í¿Õ¼ä²éѯ

1.²éѯÓû§£¨Êý¾Ý£©±í¿Õ¼ä
SELECT UPPER(F.TABLESPACE_NAME) "±í¿Õ¼äÃû",
       D.TOT_GROOTTE_MB "±í¿Õ¼ä´óС(M)",
       D.TOT_GROOTTE_MB - F.TOTAL_BYTES "ÒÑʹÓÿռä(M)",
       TO_CHAR(ROUND((D.TOT_GROOTTE_ ......

oracle ÎﻯÊÓͼ

ÎﻯÊÓͼÊÇÒ»ÖÖÌØÊâµÄÎïÀí±í£¬“Îﻯ”(Materialized)ÊÓͼÊÇÏà¶ÔÆÕͨÊÓͼ¶øÑԵġ£ÆÕͨÊÓͼÊÇÐéÄâ±í£¬Ó¦ÓõľÖÏÞÐÔ´ó£¬ÈκζÔÊÓͼµÄ²éѯ£¬Oracle¶¼Êµ¼ÊÉÏת»»ÎªÊÓͼSQLÓï
¾äµÄ²éѯ¡£ÕâÑù¶ÔÕûÌå²éѯÐÔÄܵÄÌá¸ß£¬²¢Ã»ÓÐʵÖÊÉϵĺô¦¡£
¡¡¡¡Oracle×îÔçÔÚOLAPϵͳÖÐÒýÈëÁËÎﻯÊÓͼµÄ¸ÅÄî¡£µ«ºóÀ´ºÜ¶à´óÐÍOLTPϵͳÖÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ