52ky 发表于 2022-6-16 11:00:28

Oracle预定义的21个系统异常类型.doc

FUNCTION和PROCEDURE的区别1.函数有返回值,但进程没有
2.函数在表达式中调用,过程作为pl/sql程序的语句
过程和函数以编译后的形式存储在数据库中,函数可以没有参数,也可以有多个参数并有返回值。过程
有零个或多个参数并且没有返回值。函数和过程都可以通过参数列表接收或返回零个或多个值。
主要区别不在于返回值,而在于调用它们的方式。过程被称为独立的执行语句,函数被称为有效表达式。

(Difference between function and procedure 1 Function has a return value, but the process does not
2. the function is called in the expression, and the procedure is used as the statement of the pl/sql program
Procedures and functions are stored in the database in compiled form. Functions can have no parameters or multiple parameters with return values. process
There are zero or more parameters and no return value. Both functions and procedures can receive or return zero or more values through a parameter list.
The main difference is not in the return values, but in the way they are called. Procedures are called independent execution statements, and functions are called valid expressions.)




页: [1]
查看完整版本: Oracle预定义的21个系统异常类型.doc