blocks|key|5329714|text|除非SQL表中只有一行，并且ASSIGNMENT_20081120是ASSIGNMENT%25ROWTYPE类型的本地PL/+ASSIGNMENT变量，否则这不是您想要的结果。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|5329715|假设您正在尝试创建一个新表，并将现有数据复制到该新表中|5329716|CREATE+TABLE+assignment_20081120
AS
SELECT+*
++FROM+assignment|code-block|syntax|javascript|5329717|entityMap^0|E|J|Y|I|1P|A|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]|$9|R|A|S|B|C]|$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|V|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|W|8|@]|D|@]|E|$K|L]]|$1|M|3|-4|5|6|7|X|8|@]|D|@]|E|$]]]|N|$]]

Unless there is a single row in the <code>ASSIGNMENT</code> table and <code>ASSIGNMENT_20081120</code> is a local PL/SQL variable of type <code>ASSIGNMENT%ROWTYPE</code>, this is not what you want.

Assuming you are trying to create a new table and copy the existing data to that new table

<pre><code>CREATE TABLE assignment_20081120
AS
SELECT *
 FROM assignment
</code></pre>

blocks|key|5329749|text|首先，我想：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5329750|5329751|+"...In+Microsoft+SQL+Server+SELECT...INTO会自动创建新表，而Oracle似乎要求您在执行SELECT...INTO语句之前手动创建它...“|blockquote|offset|length|style|CODE|5329752|5329753|5329754|但是在手动生成表之后，它仍然不起作用，仍然显示"missing+keyword“错误。|5329755|因此，我放弃了这一次，通过首先手动创建表，然后使用“经典”SELECT语句来解决它：|5329756|INSERT+INTO+assignment_20081120+SELECT+*+FROM+assignment;|code-block|syntax|javascript|5329757|它的工作效果与预期一致。如果有人能就如何正确使用SELECT...INTO给出一个解释，我会很高兴的！|5329758|entityMap^0|0|0|T|D|1T|D|0|0|0|0|T|6|0|0|O|D|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|10|8|@$F|11|G|12|H|I]|$F|13|G|14|H|I]]|9|@]|A|$]]|$1|J|3|-4|5|6|7|15|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|16|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|17|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|18|8|@$F|19|G|1A|H|I]]|9|@]|A|$]]|$1|P|3|Q|5|R|7|1B|8|@]|9|@]|A|$S|T]]|$1|U|3|V|5|6|7|1C|8|@$F|1D|G|1E|H|I]]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]]|X|$]]

First, I thought:

<blockquote>
 "...In Microsoft SQL Server the
 <code>SELECT...INTO</code> automatically creates
 the new table whereas Oracle seems to
 require you to manually create it
 before executing the <code>SELECT...INTO</code>
 statement..."
</blockquote>

But after manually generating a table, it still did not work, still showing the "missing keyword" error.

So I gave up this time and solved it by first manually creating the table, then using the "classic" <code>SELECT</code> statement:

<pre><code>INSERT INTO assignment_20081120 SELECT * FROM assignment;
</code></pre>

Which worked as expected. If anyone come up with an explanaition on how to use the <code>SELECT...INTO</code> in a correct way, I would be happy!

blocks|key|1801521|text|可以在PLSQL块中使用select+into，如下所示。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1801522|Declare
++l_variable+assignment%25rowtype
begin
++select+*
++into+l_variable
++from+assignment;
exception
++when+no_data_found+then
++++dbms_output.put_line('No+record+avialable')
++when+too_many_rows+then
+++dbms_output.put_line('Too+many+rows')
end;|code-block|syntax|javascript|1801523|仅当赋值中恰好有1行时，此代码才有效。通常，您将使用这种代码来选择由键编号标识的特定行。|1801524|Declare
++l_variable+assignment%25rowtype
begin
++select+*
++into+l_variable
++from+assignment
++where+ID=<my+id+number>;
exception
++when+no_data_found+then
++++dbms_output.put_line('No+record+avialable')
++when+too_many_rows+then
+++dbms_output.put_line('Too+many+rows')
end;|1801525|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

You can use select into inside of a PLSQL block such as below.

<pre><code>Declare
 l_variable assignment%rowtype
begin
 select *
 into l_variable
 from assignment;
exception
 when no_data_found then
 dbms_output.put_line('No record avialable')
 when too_many_rows then
 dbms_output.put_line('Too many rows')
end;
</code></pre>

This code will only work when there is exactly 1 row in assignment. Usually you will use this kind of code to select a specific row identified by a key number.

<pre><code>Declare
 l_variable assignment%rowtype
begin
 select *
 into l_variable
 from assignment
 where ID=&lt;my id number&gt;;
exception
 when no_data_found then
 dbms_output.put_line('No record avialable')
 when too_many_rows then
 dbms_output.put_line('Too many rows')
end;
</code></pre>

blocks|key|5329823|text|虽然这与OP的确切问题没有直接关系，但是我刚刚发现，在查询中使用Oracle保留字(在我的例子中，别名为IN)可能会导致相同的错误。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|5329824|示例：|5329825|SELECT+*+FROM+TBL_INDEPENTS+IN
JOIN+TBL_VOTERS+VO+on+IN.VOTERID+=+VO.VOTERID|code-block|syntax|javascript|5329826|或者它是否在查询本身中作为字段名|5329827|+SELECT+...,+....,+IN,+...,+....+FROM+SOMETABLE|5329828|这也会抛出这个错误。我希望这对某些人有帮助。|5329829|entityMap^0|1G|2|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|X|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|Y|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|Z|8|@]|D|@]|E|$]]|$1|O|3|P|5|J|7|10|8|@]|D|@]|E|$K|L]]|$1|Q|3|R|5|6|7|11|8|@]|D|@]|E|$]]|$1|S|3|-4|5|6|7|12|8|@]|D|@]|E|$]]]|T|$]]

Though this is not directly related to the OP's exact question but I just found out that using a Oracle reserved word in your query (in my case the alias <code>IN</code>) can cause the same error. 

Example:

<pre><code>SELECT * FROM TBL_INDEPENTS IN
JOIN TBL_VOTERS VO on IN.VOTERID = VO.VOTERID
</code></pre>

Or if its in the query itself as a field name

<pre><code> SELECT ..., ...., IN, ..., .... FROM SOMETABLE
</code></pre>

That would also throw that error. I hope this helps someone.

blocks|key|1801545|text|回答晚了，但我今天才上这张单子！|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1801546|CREATE+TABLE+assignment_20101120+AS+SELECT+*+FROM+assignment;|code-block|syntax|javascript|1801547|做同样的事情。|1801548|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Late answer, but I just came on this list today!
<pre class="lang-sql prettyprint-override"><code>CREATE TABLE assignment_20101120 AS SELECT * FROM assignment;
</code></pre>
Does the same.

blocks|key|5329849|text|如果您在Oracle数据库中备份表。您可以尝试下面的语句。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5329850|CREATE+TABLE+name_table_bk
AS
SELECT+*
++FROM+name_table;|code-block|syntax|javascript|5329851|我使用的是Oracle数据库12c。|5329852|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

If you backup a table in Oracle Database. You try the statement below.
<pre><code>CREATE TABLE name_table_bk
AS
SELECT *
 FROM name_table;
</code></pre>
I am using Oracle Database 12c.

Excuting the line of SQL:

<pre><code>SELECT * 
 INTO assignment_20081120 
 FROM assignment ;
</code></pre>

against a database in oracle to back up a table called assignment gives me the following ORACLE error: 
ORA-00905: Missing keyword

Oracle error : ORA-00905: Missing keyword

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

执行SQL行：SELECT *   INTO assignment_20081120   FROM assignment ;在oracle中备份一个名为assignment的表时，会出现以下ORACLE错误: ORA-00905:缺少关键字

问Oracle错误: ORA-00905:缺少关键字
EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Oracle错误: ORA-00905:缺少关键字EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Oracle错误: ORA-00905:缺少关键字
EN