What is the difference between is and as in oracle

Difference: 1. as can be used in the view VIEW, but is cannot be used in the view VIEW; 2. as cannot be used in the cursor CURSOR, but is can be used in the cursor CURSOR.

The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

What is the difference between is and as in Oracle

There is no difference between stored procedures (PROCEDURE) and functions (FUNCTION);

Only in views (VIEW) Use AS but not IS;

can only use IS but not AS in the cursor (CURSOR).

Summary: To make it easy to remember, use is for cursors and as for everything else

Recommended tutorial: "Oracle Tutorial"

The above is the detailed content of What is the difference between is and as in oracle. For more information, please follow other related articles on the PHP Chinese website!