REPLACE
All rows in the table are deleted and the new data is loaded. The table must be in your schema, or you must have DELETE privilege on the table.The row deletes cause any delete triggers defined on the table to fire. If DELETE CASCADE has been specified for the table, then the cascaded deletes are carried out, as well.APPEND
If data already exists in the table, SQL*Loader appends the new rows to it. If data doesn't already exist, the new rows are simply loaded. You must have SELECT privilege to use the APPEND option.
All rows in the table are deleted and the new data is loaded. The table must be in your schema, or you must have DELETE privilege on the table.The row deletes cause any delete triggers defined on the table to fire. If DELETE CASCADE has been specified for the table, then the cascaded deletes are carried out, as well.APPEND
If data already exists in the table, SQL*Loader appends the new rows to it. If data doesn't already exist, the new rows are simply loaded. You must have SELECT privilege to use the APPEND option.
解决方案 »
- 关于Oracle数据库查询问题
- 关于oracle 10g的EM启动问题
- 求解,Oracle查询时,如何让特定的记录显示在最前面
- 为什么我不能drop掉我创建的dblink?
- 如何创建白天8:00--18:00每隔一小时的ORACLE任务?谢谢!
- 哪位大哥帮帮忙!在鸟问题
- 哪位大侠知道在oracle下调试存储过程用什么工具??赐教
- [ORCALE]请问一下在ORCALE中如何选取时间?
- 最菜的问题!!求助!!
- 这个问题怎么解决,好几天了,一直没办法解决
- [公益广告]回眸软件开发语言及开发工具历史,呼唤智能、强大、高效的新一代应用系统开发平台。
- oracle9i登陆问题以normal不能登陆,以sysdba能登陆。
delete all data in the table,it can not rollback!!!APPEND
append data in the table