摘要: 3>update A
set A3 = (select A.A3 + B.B3 from B where A.A1 = B.B1) ;
7>update (select a1,a3,b1,b3 from a,b where a1=b1) set a3=a3+b3
阅读全文
摘要: update bzjd_ydhqd
set ydlb =
(SELECT b.dmmc
FROM JF_YDSQD a,dmb b
where a.ydlb = b.dmbh and b.dmlbbh_id ='03'
and a.sqdxh = bzjd_ydhqd.ydsqdxh );
阅读全文
摘要: 会在SQL*Plus中执行单个sql脚本文件
SQL>@c:\aaa.sql
阅读全文
摘要: SQL*Plus system/manager
2、显示当前连接用户
SQL> show user
3、查看系统拥有哪些用户
SQL> select * from all_users;
阅读全文