PL/SQL Insert Into Select

摘要:PL/SQL Insert Into Select

MS Sql 的 Select into ,在PL SQL 也是有的.... 順便記下 PL SQL的insert into

1. PL SQL 的Select into
CREATE TABLE [New Table Name] AS SELECT * FROM [Table Name]

2. PL SQL 的 insert into select
INSERT ALL INTO [Table Name 1] SELECT * FROM [Table Name 2]

OR

INSERT INTO [Table Name 1] ([Column Name]+)
SELECT  [Column Name]+ FROM [Table Name 2]