select into from 在plsql中的错误
来源:互联网 发布:大数据可视化 tableu 编辑:程序博客网 时间:2024/05/17 16:03
SELECT INTO FROM语句
语句形式为:SELECT vale1, value2 into Table2 from Table1
语句形式为:SELECT vale1, value2 into Table2 from Table1
要求目标表Table2不存在,因为在插入时会自动创建表Table2,并将Table1中指定字段数据复制到Table2中。
但是这个语句不能再plsql中执行,会报"ORA-00905:缺失关键字"错误,原因是PL/Sql与T-SQL的区别。
T-SQL中该句正常,但PL/SQL中解释是:(不知道在sqlplus中能否执行)
select..into is part of PL/SQL language which means you have to use it inside a PL/SQL block. You can not use it in a SQL statement outside of PL/SQL.
即不能单独作为一条sql语句执行,一般在PL/SQL程序块(block)中使用。
如果想在PL/SQL中实现该功能,可使用Create table newTable as select * from ...:
如: create table NewTable as select * from ATable;
NewTable 除了没有键,其他的和ATable一样
阅读全文
0 0
- select into from 在plsql中的错误
- MySQL中的SELECT...INTO...FROM
- select into from 和 into from select
- select into from …
- sqlserver select into from
- insert into select from
- insert into select from
- SELECT INTO FROM语句
- select into from 提示 Undeclared variable.....错误的解决办法
- select into ...from... 提示 Undeclared variable.....错误的解决办法
- Insert into select 和 select into from
- SELECT INTO FROM 与 INSERT INTO SELECT
- SELECT INTO FROM与INSERT INTO SELECT
- SELECT INTO FROM与INSERT INTO SELECT
- SELECT INTO FROM与INSERT INTO SELECT
- SELECT INTO FROM与INSERT INTO SELECT
- SELECT INTO FROM与INSERT INTO SELECT
- SELECT INTO FROM与INSERT INTO SELECT
- Hi3518EV200平台直接操作GPIO输入或输出高低电平
- echarts-3.8.4
- node.js解决跨域,express是基于webpack中的处理方式
- 流程图工具的选择
- HDU2018
- select into from 在plsql中的错误
- SpringCloud学习笔记-Hystrix熔断器
- .NET编程利器: Reflector for .NET
- Makefile特殊符号
- MongoDB索引创建
- poj 2259 Team Queue (模拟)
- 黑白棋对战(电脑下不过我)
- 【已解决】WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED!
- 关于各操作系统对UVC协议支持的说明