Oracle's Learning Summary and Its Difference to SQLServer
I have learned Oracle recently, I found that it is very different from SQL Server. I do a small record 1. In the definition of the Oralce process, the number is not defined, and the SQLServer can be 2, and the Oracle process cannot be returned with RETURN. , But SQLServer can, if needed
Return Value, you can use the output parameter in the process or return value 3 in the function, define the process in Oralce, can be directly defined as the process, or the process inside the package, there is no concept in the SQL Server and the package correspondence 4, use the semicolon in Oracle; as the end of the statement, SQL Server is a 50, process, or an end method of the inclusion, there are two Create or Replace Scott.getdirectors (/ * * /) as begin end; / * Here you can also use endddirectors; but note that there is no scott. * / 6, if you need to get an Oracle recordset in the program, you need to use the output parameter ref. REF CURSOR usually needs to be defined in the package, not directly in the process. definition
