oracle UPDATE ¶à±í¹ØÁª¸üÐÂ
update customers a
set city_name=(select b.city_name from tmp_cust_city b where b.customer_id=a.customer_id)
where exists (select 1
from tmp_cust_city b
where b.customer_id=a.customer_id
)
-- update ³¬¹ý2¸öÖµ
update customers a
set (city_name,customer_type)=(select b.city_name,b.customer_type
from tmp_cust_city b
where b.customer_id=a.customer_id)
where exists (select 1
from tmp_cust_city b
where b.customer_id=a.customer_id
)
========================
select * from path p,sd_mapnodes a
where p.aendnode=a.nm_node_id
update path p
set p.aendnode=(select s.ems_node_id from sd_mapnodes s where s.nm_node_id=p.aendnode)
where exists (select 1 from sd_mapnodes s where s.nm_node_id=p.aendnode)
select * from pathtrace pt,sd_mapnodes a
where pt.anode_id=a.nm_node_id
update pathtrace r
set (r.anode_id,r.znode_id)=(select s.ems_node_id,s.ems_node_id from sd_mapnodes s where s.nm_node_id=r.anode_id)
where exists (select 1 from sd_mapnodes s where s.nm_node_id=r.anode_id)
Ïà¹ØÎĵµ£º
--ËøµÄ¸ÅÄî
Ëø³öÏÖÔÚÊý¾Ý¹²ÏíµÄ³¡ºÏ£¬ÓÃÀ´±£Ö¤Êý¾ÝµÄÒ»ÖÂÐÔ¡£µ±¶à¸ö»á»°Í¬Ê±ÐÞ¸ÄÒ»¸ö±íʱ£¬ÐèÒª¶ÔÊý¾Ý½øÐÐÏàÓ¦µÄËø¶¨¡£
-- ËøµÄģʽ£¬ÓÐÒÔϼ¸ÖÖģʽ
0£ºnone
1£ºnull ¿Õ
2£ºRow-S Ðй²Ïí(RS)£º¹²Ïí±íËø£¬sub share
3£ºRow-X ÐжÀÕ¼(RX)£ºÓÃÓÚÐеÄÐ޸ģ¬sub ex ......
1.»ù±¾½á¹¹
CREATE OR REPLACE PROCEDURE ´æ´¢¹ý³ÌÃû×Ö
(
²ÎÊý1 IN NUMBER,
²ÎÊý2 IN NUMBER
) IS
±äÁ¿1 INTEGER :=0;
±äÁ¿2 DATE;
BEGIN
END ´æ´¢¹ý³ÌÃû×Ö
2.SELECT INTO STATEMENT
½«select²éѯµÄ½á¹û´æÈëµ½±äÁ¿ÖУ¬¿ÉÒÔͬʱ½«¶à¸öÁд洢¶à¸ö±äÁ¿Ö ......
¡¶oracle´óÐÍÊý¾Ý¿âϵͳÔÚAIX/unixÉϵÄʵսÏê½â¡·¼¯ÖÐÌÖÂÛ35£ºÔÚAIX»·¾³ÏÂΪOracle¡¢sybase ʹÓÃÂãÉ豸 ÎÄƽ ÂãÉ豸ÊÂÒ»ÖÖÔÚUNIXϳ£ÓõÄÊý¾Ý¿âÊý¾Ý´æ´¢·½Ê½,ÔÚAIXÖÐÈç´Ë,ÔÚHP-UX\SCO UNIXµÈϵͳÖнÔÊÇÈç´Ë¡£Õâ¶ÎʱÆÚÒÔÀ´Ò»Ö±ÓÐͬ־ÃÇÓʼþѯÎÊÈçºÎʹÓÃÂãÉ豸¡£ÕâÀïÎÒ»ã×ÜһЩAIXÏÂÂãÉ豸µÄʹÓÃÎ ......
¶ÔÓÚ×°ºÃÁ˸ÃÈí¼þºó,ÀûÓÃsystemÊÇÄܵǽøÈ¥µÄ,»ú×ÓÖØÆôºó,³öÏֵĸÃÎÊÌ⣺
¿ÉÄÜÄú ÔËÐÐ--sqlplusw ÊÇÄܵÇÉÏÈ¥µÄ ¶ø»»³ÉPL/SQL Developer È´Á¬²»ÉÏ ·þÎñÆ÷,Èç¹ûÄúÈ·¶¨ÄãµÄ·þÎñ¿ªÆôÁË
ËÑË÷ÕÒµ½tnsnames.oraºÍlistener.oraÎļþ, °ÑÆäÖеÄHOST=ºóµÄÖ÷»úÃû»òip¸ÄΪµ±Ç°µ ......
ORACLEÊý¾Ý¿âµÄ»ù±¾Óï·¨¼¯½õ
-- ±í
create table test (names varchar2(12),
dates date,
&nb ......