ITPub博客

首页 > Linux操作系统 > Linux操作系统 > multi-table insert command

multi-table insert command

原创 Linux操作系统 作者:Nikita_he 时间:2013-09-20 13:04:37 0 删除 编辑

syntax overview

There are two types of multi-table insert as follows:

  • INSERT FIRST; and
  • INSERT ALL.

Multi-table inserts are an extension to INSERT..SELECT. Syntax is of the following form.:

INSERT ALL|FIRST
   [WHEN condition THEN] INTO target [VALUES]
   [WHEN condition THEN] INTO target [VALUES]
   ...
   [ELSE] INTO target [VALUES]
SELECT ...
FROM   source_query;



http://www.oracle-developer.net/display.php?id=209

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29056905/viewspace-772928/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2013-08-11

  • 博文量
    3
  • 访问量
    10035