Home > Database > Mysql Tutorial > body text

Oracle AS关键字 提示错误

WBOY
Release: 2016-06-07 18:07:11
Original
1132 people have browsed it

今天运行程序时,在Oracle中输入SQL语句:select * from USERS as u ,程序报错

今天运行程序时,在Oracle中输入SQL语句:u ,程序报错



输入

但是在SQL Server 2005 中输入''u''相同的语句就没有错,查了原因如下:SQL2规范允许关键字AS出现在表的名字和表的别名之间,虽然这使得FROM子句更容易被读懂,但是在特定的SQL产品中它可能还不被支持。

我想Oracle还不支持这样的语法。

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template