oracle PL/SQL³ÌÐò¿éÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí
±àдPL/SQL³ÌÐò¿éShowInfo£¬¸ø¶¨Ò»¸öÔ±¹¤ºÅ¾Í¿ÉÒÔÏÔʾÆäÐÕÃû¡¢ÐÔ±ðµÈÐÅÏ¢,
Èç¹û¸ÃÔ±¹¤²»´æÔÚÔòÏÔʾ¡®¶Ô²»Æð£¬Ã»ÓдËÔ±¹¤£¡¡¯
ÇëÎÊÉÏÃæÕâµÀÌâÕâôд£¿£¿¸Õѧoracle¶ÔºÜ¶à¶¼²»ÊǺܶ®£¬Ï£ÍûÄܹ»Ïêϸ½âÊÍ£¡Ð»Ð»
if(v is not null)then
dbms_output.put_line('¸ÃÔ±¹¤²»´æÔÚ');
Õâ¸öÎÊÌâ¼ÇµÃǰ¼¸ÌìÓÐÈËÎʹý
×Ô¼º×ö³öÀ´ÁË£¬ºÜ¼òµ¥µÄ£¬Êǿα¾ÀïÃæµÄÀý×Ó˵µÄºÜÂÒ¡£Ð»Ð»£¡£¡
SO easy
Ïà¹ØÎÊ´ð£º
Ð»Ð»ÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡
°²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓÆµ£¬¸ú×ÅÊÓÆµÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖá£
µã»÷½øÈ룺Database Configuration Assistant
1. ´´½¨Êý¾Ý¿â£»
......
ÐèÇóÈçÏ£º
ѧԺ academy£¨aid,aname£©
°à¼¶ class£¨cid,cname,aid£©
ѧÉú stu(sid,sname,aid,cid)
סËÞÇø region(rid,rname)
ËÞÉáÂ¥ build(bid,rid,bnote) bnoteÊÇ¡®ÄС¯/¡®Å®¡¯
ËÞÉá dorm(did,rid,bid£¬bedn ......
oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃMS SQLµÄ´æ´¢¹ý³Ì,Çó½â~лл~
ÒýÓÃ
oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃM ......
SQL code:
CREATE OR REPLACE PROCEDURE usp_refreshTopN IS
BEGIN
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,organizat ......
Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿
ÖÁÉٵø½¼Óµ½sqlserverÉÏ
¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿
Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ
º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£
sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......