ORA-0092二:选项缺点和失误或无效

发布时间:2019-05-29  栏目:MyBatis  评论:0 Comments

ORA-00922:选项缺点和失误或无效

一、错误描述

 

SQL> create table info_stu from select t.stu_id,t.stu_name,t.stu_age from info t;

create table info_stu from select t.stu_id,t.stu_name,t.stu_age from info t

ORA-00922: 选项缺失或无效

二、错误原因

 

出于用数据库表中有个别字段创立一张新表,中间的总是是用AS,而不是用from

 

三、化解办法

 

SQL> create table info_stu as select t.stu_id,t.stu_name,t.stu_age from info t;

Table created

http://www.bkjia.com/Mysql/1083801.htmlwww.bkjia.comtruehttp://www.bkjia.com/Mysql/1083801.htmlTechArticleORA-00922:选项缺失或无效 一、错误描述 SQL create
table info_stu from select t.stu_id,t.stu_name,t.stu_age from info
t; create table info_stu from select t.stu_id,t.stu_n…

ora-0092二 选项缺失或无效
SET password @SQL=CONCAT(‘select id,email where
table_name=\”,tuser,’\”);

留下评论

网站地图xml地图