“AS"和“AS"有什么区别?和“是"在 Oracle 存储过程中?
我看到 Oracle 程序有时用AS"编写，有时用IS"关键字编写.
I see Oracle procedures sometimes written with "AS", and sometimes with "IS" keyword.
CREATE OR REPLACE Procedure TESTUSER.KILLINSTANCE (INSTANCEID integer) **AS**
...
对比
CREATE OR REPLACE Procedure TESTUSER.KILLINSTANCE (INSTANCEID integer) **IS**
...
两者有区别吗?
<小时>显然，两者之间没有功能差异，但有些人遵循约定，当 SP 是包的一部分时使用AS"，而当它不是时使用IS".或者反过来.嗯.
Apparently, there is no functional difference between the two, but some people follow a convention to use "AS" when the SP is part of a package and "IS" when it is not. Or the other way 'round. Meh.
推荐答案
无.它们是同义词，旨在使您的代码更具可读性:
None whatsover. They are synonyms supplied to make your code more readable:
功能 f IS ...
FUNCTION f IS ...
CREATE VIEW v AS SELECT ...
CREATE VIEW v AS SELECT ...
相关文章