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]
全站熱搜
留言列表
