System Functions (Information)
Returns a query reference that you can pass to a stored procedure. Within the stored procedure, when you execute the query, the query is performed using the role of the user who created the query reference.
- See also:
SYSTEM$REFERENCE('<select_statement>', [ , <use_session_scope> ] )
The SELECT statement to pass to the stored procedure. This must be a statement that serves as an inline view.
Note that if the SELECT statement contains any single quotes or other special characters (e.g. newlines), you must escape those characters with backslashes.
TRUE, specifies that the query reference should be valid for the duration for the session. If this is
FALSEor omitted, the query reference is valid within the context in which it was created. See Specifying the Scope of the Reference.
A query reference that represents the specified SELECT statement.