OS: Windows 11
DB: 19C
I have a query which runs to get sizes of blob columns, together with some other columns. The result of this query looks good in SQL Developer but when I run the same query in SQLcl the result is "screwed". What am I missing here? In the SQL cl result the file_size column printed on the 'file_name'-column, but that is not happening for the last line.
This is the query:
SELECT hbfc.FILE_ID
, hbfc.FILE_NAME
, NVL(DBMS_LOB.GETLENGTH(hbfc.FILE_CONTENT),0) FILE_SIZE
FROM HOLX_BLOB_FILES_CONV hbfc
ORDER BY hbfc.FILE_ID ASC;
