Issue

When querying LONG type columns in tbsql, an interactive utility provided by Tibero for processing SQL statements, the output is limited and the entire TEXT is not displayed correctly.

When checking the contents of a VIEW through the TEXT column in DBA_VIEWS or reviewing the contents of SQL_TEXT in DBA_AUDIT_TRAIL, only part of the TEXT column's result value is output.

$ tbsql sys/tibero

SQL> select text from dba_views where rownum < 3;


TEXT
--------------------------------------------------------------------------------
select instance_id() as inst_id, "V"."SID", "V"."OWNER", "V"."OBJECT", "V"."TYPE
select instance_id() as inst_id, "V"."SAMPLE_ID", "V"."THREAD#", "V"."SAMPLE_TIM

2 rows selected.

Cause

When the DATA_TYPE is LONG TYPE, the TEXT is omitted in the output on tbsql.

Solutions

Use the set command to set the default output length of the data to ‘1000000’ to resolve the TEXT omission issue. 

SQL> set long 1000000

SQL> select text from dba_views where rownum < 3;

TEXT
--------------------------------------------------------------------------------
select instance_id() as inst_id, "V"."SID", "V"."OWNER", "V"."OBJECT", "V"."TYPE
" from v$access v
select instance_id() as inst_id, "V"."SAMPLE_ID", "V"."THREAD#", "V"."SAMPLE_TIM
E", "V"."SID", "V"."SESS_SERIAL_NO", "V"."USER_NO", "V"."USER_NAME", "V"."IPADDR
", "V"."WAIT_EVENT", "V"."ID1", "V"."ID2", "V"."WE_SEQ", "V"."TIME_WAITED", "V".
"WAIT_OBJ_ID", "V"."WAIT_FILE_NO", "V"."WAIT_BLOCK_NO", "V"."WAIT_ROW_NO", "V"."
USGMT_ID", "V"."SLOTNO", "V"."WRAPNO", "V"."SQL_ID", "V"."SQL_CHILD_NUMBER", "V"
."CURR_HASHVAL", "V"."MODULE_NAME", "V"."ACTION_NAME", "V"."CLIENT_INFO_NAME", "
V"."PROG_NAME", "V"."SQL_EXEC_START", "V"."SQL_EXEC_ID", "V"."SQL_PLAN_LINE_ID",
"V"."PORT", "V"."DELTA_TIME", "V"."DELTA_PHY_READ_BLKS", "V"."DELTA_LOG_READ_BL
KS", "V"."PGA_SIZE" from v$active_session_history v

2 rows selected.