this works for me: SELECT TO_CHAR(dbms_lob.substr(,4000)) ... View more

There is a difference in how the MS SQL Server driver handles VARCHAR(max) compared with jTDS. The MS driver reports the column as a standard VARCHAR, jTDS however treats the column as a LOB. Workaround is to set the "USELOBS" driver property for jTDS to "false". Copy db_connection_types.conf from default to local and change this line: jdbcUrlFormat = jdbc:jtds:sqlserver://<host>:<port>/<database>;useCursors=true into: jdbcUrlFormat = jdbc:jtds:sqlserver://<host>:<port>/<database>;useCursors=true;UseLOBs=false ... View more

zcat splunkforwarder-6.0-182037-SunOS-sparc.tar.Z | tar xvf - ... View more

Maybe a subquery in select will do? select ....... , (select USERNAME from table2 where .....) as USER, .... from table1 ... View more