摘要：oracle导入导出(前提,本机已经安装oracle和oracle客户端)导出命令: exp username/password@192.168.1.138/ORCL file=c:\test.dmp导入本地数据库命令: imp username/password@127.0.0.1/ORCL file=c:\test.dmp full=y导入时,遇到错误: IMP-00017: 由于 ORACLE 错误 959, 以下语句失败:.........................IMP-00003: 遇到 ORACLE 错误 959ORA-00959: 表空间 'TBS_GCWGGL& 阅读全文

摘要：1.oracle查询结果去除重复项SELECT DISTINCT * FROM TABLE_NAME2.合并查询结果select id,name from wg_personunionselect id,name from wg_superUsers从person表和superuser表中查询到的结果合并3.递归查询START WITH PID = :id CONNECT BY PRIOR ID = PID一般和union语句结合使用:START WITH PID = :id CONNECT BY PRIOR ID = PID unionselect id from wg_depart whe 阅读全文