![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle
打工人(DGR)
这个作者很懒,什么都没留下…
展开
-
oracle表关联更新
oracle表关联更新from关联更新UPDATE T1 SET T1.FMONEY = (select T2.FMONEY from t2 where T2.FNAME = T1.FNAME)WHERE EXISTS(SELECT 1 FROM T2 WHERE T2.FNAME = T1.FNAME);内联视图更新UPDATE (select t1.fmoney fmoney1,t2.fmoney fmoney2 from t1,t2 where t1.fname =转载 2020-09-17 10:37:10 · 132 阅读 · 0 评论 -
oracle表的导入导出
oracle表的导入导出1、不含oracle版本信息的导入imp userName/password@serviceName file=xxxx full=y2、不含oracle版本信息的导出exp userName/password@serviceName tables=tableName file=xxx log=xxx(log指代导出的日志,可不写)3、含oracle版本信息导出expdp userName/password @serviceName dumpfile=xxx.dmp v原创 2020-07-08 17:56:01 · 173 阅读 · 0 评论