Skip to content

Instantly share code, notes, and snippets.

@Chudesnov
Created May 4, 2016 15:28
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Chudesnov/06324d480290a7a916aaec6ef9173083 to your computer and use it in GitHub Desktop.
Save Chudesnov/06324d480290a7a916aaec6ef9173083 to your computer and use it in GitHub Desktop.
SQLPlus, SQLcl and cursors
SQL> set sqlformat json
SQL> select cursor(select 1 as num from dual) cursor_column, 32767 number_column from dual;
������������ ��� �������: getOracleObject not implemented for class oracle.jdbc.driver.T4CResultSetAccessor
{"results":[{"columns":[{"name":"CURSOR_COLUMN","type":"NUMBER"},{"name":"NUMBER_COLUMN","type":"NUMBER"}],"items":
[
]}]}no rows selected
SQL> select cursor(select 1 as num from dual) cursor_column, 32767 number_column from dual;
CURSO NUMBER_COLUMN
----- -------------
NUM 32767
----------------------
1
SQL> select cursor(select 1 as num from dual) cursor_column, 32767 number_column from dual;
CURSOR_COLUMN NUMBER_COLUMN
-------------------- -------------
CURSOR STATEMENT : 1 32767
CURSOR STATEMENT : 1
NUM
----------
1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment