yjyyjy

  博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

We know that there is "commit" in oracle to submit all data in the session and used very common.

But there is "/" in sql command line that is special and do not use it in wrong way.

"Adding a slash to the end of each statement was a bad choice because sqlplus treats slash as a buffer flush.

  • For procedure/triggers/functions it is a must: because content of if is stored in the buffer and is not executed.
  • However, for all other statements it means executing the same statement twice because such statement is executed immediately and put into buffer and following slash just re-executes the same statement."

-- So if one command exceuted before and still in buffer, after several steps you do not need execute any more. Then do no not use it to make mistake.

posted on 2019-09-20 15:39  闭关49天  阅读(185)  评论(0编辑  收藏  举报