SQL Process Flow

From Robs_Wiki
Revision as of 23:24, 20 February 2020 by Qadmin wiki (talk | contribs) (Created page with "__TOC__ == Step 1 Statement is parsed == The user issues a statement and the statement is parsed by the database. When an application issues a SQL statement, the application...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Step 1 Statement is parsed

The user issues a statement and the statement is parsed by the database. When an application issues a SQL statement, the application makes a parse call to the database to prepare the statement for execution. The parse call opens or creates a cursor, which is a handle for the session-specific private SQL area that holds a parsed SQL statement and other processing information. The cursor and private SQL area are in the program global area (PGA).