OracleÖеĴø²ÎÊýµÄÊÓͼ
OracleµÄÊÓͼ²»Ö§³Ö²ÎÊý
ÕâÀïÓÐÒ»¸öÁíÀàµÄ·½·¨£¬²»ÊǺܺ㬵«ÊÇ»¹ÊÇÒ»ÖÖ½â¾ö·½°¸
ͨ¹ýpackageʵÏÖ
create or replace package pkg_pv is
¡¡¡¡procedure set_pv(pv varchar2);
¡¡¡¡function get_pv return varchar2;
¡¡¡¡end;
¡¡¡¡create or replace package body pkg_pv is
¡¡¡¡v varchar2(20);
¡¡¡¡procedure set_pv(pv varchar2) is begin v:=pv; end;
¡¡¡¡function get_pv return varchar2 is begin return v; end;
¡¡¡¡end;
¡¡¡¡´´½¨´ø²ÎÊÓͼ
¡¡¡¡create view v_emp as select * from emp where ename=pkg_pv.get_pv();
¡¡¡¡µ÷Óùý³Ì£¬½á¹ûÕýÈ·Ö´ÐÐ
¡¡¡¡begin
¡¡¡¡pkg_pv.setpv('scotte');
¡¡¡¡end;
¡¡¡¡select * from v_emp;
¡¡¡¡°´ÕÕ´Ë·½·¨ÎÒÃÇ¿ÉÒÔ°Ñͨ¹ý°üµÄÐÎʽÀ´´´½¨Ò»¸öϵͳ±äÁ¿£¬Í¨¹ýÔÚÔËÐÐʱÉèÖÃÆäÖµ¡£À´»ñµÃ¶ÔһЩÐèÒªÔÚÔËÐÐʱÓв»Í¬ÖµÐèÇóµÄÒµÎñ´¦Àí×÷һЩ¸ü¼ò»¯µÄ´¦Àí¡£±¾ÀýÖÐÎÒÃÇÉõÖÁ¿ÉÒÔÔÚ°üÌåÀïÃæËüÉèÒ»¸ö³õʼֵ£¬Èç¹û²»µ¥¶ÀÉèÖÃʱ£¬¾Í²ÉÓóõÖµ¡£ÕâÑù¾Í¿ÉÒÔ»ñµÃ¸ü´óµÄÁé»îÐÔ
ËÑË÷¸ü¶àÏà¹ØÖ÷ÌâµÄÌû×Ó: View
PLSQL
ÌṩOracle¹ÜÀí/¹ÊÕÏ´¦Àí/ÓÅ»¯/°²×°/RAC/±¸·Ý»Ö¸´¼¼Êõ·þÎñ,ÌṩרҵµÄOracleÅàѵºÍ×Éѯ·þÎñ¡£
Óʼþ: inthirties@gmail.com
MSN: inthirties@hotmail.com
QQ: inthirties@qq.com
רҵÂÛ̳ http://www.inthirties.com
¼¼Êõ²©¿Í http://blog.csdn.net/inthirties
¸öÈËÕ¾µã http://blog.inthirties.com
Ïà¹ØÎĵµ£º
select p.spid,
a.serial#,
c.object_name,
b.session_id,
b.oracle_username,
b.os_user_name
from v$proces ......
1. Oracle°²×°Íê³ÉºóµÄÔʼ¿ÚÁ
¡¡internal/oracle
¡¡¡¡sys/change_on_install
¡¡¡¡system/manager
¡¡¡¡scott/tiger
¡¡¡¡sysman/oem_temp
2. ORACLE9IAS WEB CACHEµÄÔʼĬÈÏÓû§ºÍÃÜÂ룿
administrator/administrator
3. oracle 8.0.5ÈçºÎ½¨Á¢Êý¾Ý¿â£¿
ÓÃorainst¡£¼ÙÈçÓÐmotif½çÃ棬Äܹ»ÓÃorainst /m¡ ......
°²×°¸ÅÊö
±¾Æª½éÉÜÈçºÎ°²×°OracleÈí¼þ£¬Òª°²×°OracleÈí¼þÍƼöʹÓÃOracleͨÓð²×°¡£OracleͨÓð²×°³ÌÐòÊÇÒ»¸öͼÐÎÓû§½çÃ棨GUI£©¹¤¾ß£¬Ê¹Äú¿ÉÒԲ鿴OracleÈí¼þÒÑÔÚ¼ÆËã»úÉÏ°²×°»ò°²×°ÐµÄOracleÈí¼þ£¬²¢Ð¶ÔØOracleÈí¼þ£¬ÒÔϽ«ÐÖúÄúÍê³É°²×°¹ý³Ì¡£
¼ì²éÏȾöÌõ¼þ
°²×°³ÌÐò֮ǰ£¬Oracle¹«Ë¾Ö´ÐÐÒ»¸öÏȾöÌõ¼þ¼ì²éµÄ×Ô¶¯±àº ......
ÒÔÏÂÊÇOracle JDBC¹Ù·½ÎĵµµÄ˵·¨£º
Ò²¾ÍÊÇËæ±ã·ÒëһϾÍÀí½âÁË¡£
JDBC Thin for All Platforms
classes12.jar (1,600,090 bytes) - for use with JDK 1.2 and JDK 1.3
Ôڵͼ¶JDK°æ±¾1.2Óë1.3ÖÐʹÓõÄÇý¶¯£¬ËäȻʵ¼ÊÉÏÔÚ1.4£¬1.5ÖÐʹÓô󲿷ÖÇé¿öÒ²ÊÇOKµÄ
classes12_g.jar (2,044,594 bytes) - same as classes12.j ......