excel和oracle表数据的互动

--表的创建
CREATE TABLE zyc_test AS SELECT ROWNUM ID,customeren,projecttname FROM pms_prj_projects
--删除无用的信息
DELETE FROM zyc_test WHERE ID IS NULL
--连表查询
SELECT a.*,b.username,b.useraccount,b.customeren,b.projecttname,b.important
 FROM zyc_test a
LEFT JOIN pms_prj_projects b ON a.projecttname=b.projecttname ORDER BY a.ID

---更新表的数据

UPDATE pms_prj_projects SET important='1' WHERE projecttname IN (SELECT projecttname FROM zyc_test)

------从oracle表复制的数据 如果不适合插入excel表格 可以现在txt文本 中转一下  吧头或尾不合适的数据去掉 在黏贴