ÏÖÔÚÎÒ±¾µØÃ»Óа²×°oracle, µ«plsqldevÐèÒªsqlplus.exeµÈ£¬ÇëÎÊoracle10gÔÚwindowsÐèÒª
ÄÄЩexeÎļþ£¬ÄÄλ´ó¸çÄÜ˳±ãÌṩһÏÂQQ£º190565390
×°oracleµÄʱºò¿ÉÒÔÑ¡ÔñÖ»×°¿Í»§¶ËµÄ
×îÆðÂëҪװoracle£¬ÄãÖ»Ðè×°¿Í»§¶Ë¾Í¿ÉÒÔ
¿ÉÒÔÑ¡ÔñÐԵذ²×°¿Í»§¶Ë
Ö»Ðè×°¿Í»§¶Ë¾Í¿ÉÒÔ...
ÄǾÍÔÚ±¾µØ°²×°¸ö
ÎÒ¾ÍÊDz»Ïë°²×° ......
CREATE VIEW NMSGUEST.DB2TBSENTRY(DEVIPADDR,DBINDEX,TABLESPACEINDEX,TABLESPACENAME,TABLESPACESTATE,DEVTYPE)
AS
select varchar(char(integer(A.devID)),20),B.int01,B.int02,B.str01,B.int05,A.neType
from imap_db.INMSNEMO A
inner join imap_db.MOStorageTable B on LEFT(B.fdn,LENGTH(A.fdn)+1)=A ......
×î½üÔÚoracleÖÐÔÚµ¼Èëʱ×ÜÊdzöÏÖËÀËø£¬Ã»°ì·¨Ö»ÄÜɱËÀµôÕâ¸öÈ»ºó´Óµ¼
ÎÒµÄÊý¾Ý¿âÓм¸Ê®ÕÅ±í£¬¶øÇÒÓкܶà·ÖÇø±í£¬×ܵÄÊýÁ¿Ò²Í¦´ó£¬´ó¸ÅÎåÊ®¶àG£¬ËùÒÔµ¼³öʱ¶¼ÊDz¢·¢µÂ½«Ã¿¸ö·ÖÇøµ¥¶Àµ¼³ö£¬×îºó´ó¸ÅÄÜÓÐһǧ¸ödmpÎļþ°É£¬È»ºó²¢·¢µ¼È룬¸øÎҵĸоõÊǵ¼ÈëµÄ²¢·¢ÊýµÍʱ²»ÈÝÒ׳öÏÖ£¬²¢·¢Êý¸ßʱ¾ÍÈÝÒ׳öÏÖËÀËø£¨Ò»°ã24¸öCPUÎÒ¾ ......
¹¤³ÌÓõÄc3p0Á¬½Ó³Ø
¹¤³ÌÆô¶¯ºó,Á¬½ÓÕý³£
µ±¹¤³ÌÍ£Ö¹ÒÔºó,²é¿´OracleµÄ»á»°,·¢ÏÖÁ¬½Ó»¹ÔÚ,²¢Ã»ÓÐÊÍ·Å
ÖØ¸´Æô¶¯ºÍÍ£Ö¹¹¤³Ì,»á·¢ÏÖÁ¬½ÓÔ½À´Ô½¶à,ûÓм°Ê±ÊÍ·Å,Çó½â¾ö°ì·¨
Oracle10+Tomcat6.0
лл´ó¼Ò
up
ÁÙʱµÄ½â¾ö·½·¨£ºÊý¾Ý¿âÀïɱsession.
¸ù±¾·½·¨£ºÐÞ¸ÄÈí¼þ´úÂë..
¸ü¹îÒìµÄÊÇ, ......
oracle´æ´¢¹ý³ÌÔõôд°¡£¬Èçselect,insert
SQL code:
CREATE OR REPLACE PROCEDURE pro
(v1 in t.c1%type,
v2 in t.c2%type
)
is
begin
insert into t values(v1,v2);
end pro;
/
´æ´¢¹ý³Ì´´½¨Óï·¨£º
create or replace procedure ´æ´¢¹ý³ÌÃû£¨param1 in type£¬param2 out type£©
as
......
ÏÖÔÚʹÓÃoracleÊý¾Ý¿â´æ´¢¹ý³Ì ʵÏÖ·ÖÒ³¹¦ÄÜ£¬Ò»°ãÀ´ËµÕâÖÖ·ÖÒ³·½Ê½¶¼ÊÇʹÓÃoracleÊý¾Ý±íÖеÄÒ»¸öÒþ²ØÁÐROWNUM£¬µ«ÊÇÓöµ½ÏÂÃæÕâÖÖÎÊÌ⣬ÓÖ¸ÃÔõô°ìÄØ£¿
SQL code:
procedure pro_getresource_bystartend(p_out out myCur,
f_id in number,
......