SqlDbx
You are not logged in.
It looks like SqlDbx does not support Q-delimited literals
SELECT T.TABLE_NAME
,T.COLUMN_NAME
,T.DATA_TYPE||'('||NVL(T.DATA_PRECISION,T.DATA_LENGTH)||')' COL_TYPE
,T.NULLABLE
,Q'[SELECT ']' || T.TABLE_NAME || Q'[' TBL, COUNT(*) CNT, TO_CHAR(SYSDATE,'YYYYMMDD') DT FROM ]' || T.TABLE_NAME ||';' SEL_COUNT_SQL
FROM USER_TAB_COLS T
WHERE ROWNUM < 5
ORDER BY T.TABLE_NAME
;
This is absolutely valid SQL statement and it runs OK in PL/SQL or any other application
However, SQLDbx gives these errors:
ORA-01756: quoted string not properly terminated
SQL parse error location
ORA-00900: invalid SQL statement
SQL parse error location
Last edited by garbuya (2016-07-14 08:00:19)
Offline
Please comment this post
Offline
Please comment this post
Offline
This will be fixed in the one of the future releases
Offline