PL/SQL Oracle 函数或过程创建的 IS 与 AS 关键字

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/2338408/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-01 05:30:17  来源:igfitidea点击:

IS vs AS keywords for PL/SQL Oracle Function or Procedure Creation

sqloracleplsql

提问by Joel Cunningham

I have been trying to find out what the difference is between the ISand ASkeywords in PL/SQL when creating an Oracle function or procedure.

在创建 Oracle 函数或过程时,我一直试图找出PL/SQL 中的ISAS关键字之间的区别。

I have searched and have been unable to find any information on this. Does anyone know the difference?

我已经搜索过,但无法找到任何关于此的信息。有谁知道区别?

回答by OMG Ponies

I've never known there to be a difference. The Oracle documentationimplies that they are synonyms:

我从来不知道有什么不同。在Oracle文档意味着它们是同义词:

The function body begins with the keyword IS(or AS) and ends with the keyword END followed by an optional function name.

函数体以关键字IS(或AS)开头,以关键字 END 结尾,后跟可选的函数名称。

回答by pj.

Same as DISTINCT and UNIQUE in select statements. i.e, there is no material difference between 'IS' and 'AS'. Backwards compatibility and meeting standards

与 select 语句中的 DISTINCT 和 UNIQUE 相同。即,“IS”和“AS”之间没有实质性区别。向后兼容性和满足标准