This little script displays some useful meta-information:
SQL_EXA> create schema myschema;
EXA: create schema myschema;
Rows affected: 0
SQL_EXA> create or replace script whoami as
output('Current User: '.. tostring(exa.meta.current_user))
output('Current Schema: '.. tostring(exa.meta.current_schema))
output('Session ID: '.. tostring(exa.meta.session_id))
output('Database Version: '.. tostring(exa.meta.database_version))
output('Number of Nodes: '.. tostring(exa.meta.node_count))
/
EXA:create or replace script whoami as...
Rows affected: 0
SQL_EXA> col output for a40;
COLUMN output ON
FORMAT a40
SQL_EXA> execute script whoami with output;
EXA: execute script whoami with output;
OUTPUT
----------------------------------------
Current User: SYS
Current Schema: MYSCHEMA
Session ID: 1612024483893367379
Database Version: 6.1.0-alpha1
Number of Nodes: 1
5 rows in resultset.
All available metadata is documented here (Chapter 3. Concepts -> 3.6 UDF scripts).
Pickleball spielen 