Oracle - Do Not Bear Drops

Question

I noticed that in "SQL Developer", if you select from a table containing a BLOB, it uses the word "(BLOB)" instead of displaying / loading the contents of the BLOB.

Is this something that can be done at the session level?

I have a .net program that "selects" from TABLE_WITH_BLOB that returns the contents of a BLOB. I cannot change the program by selecting all the columns, so it’s best to say .net or session so as not to transmit BLOBs. Does anyone know a way to do this?

Answer 1

, SQL Developer , , BLOB '(BLOB)' :

v_sql := 'SELECT col1, col2, col3, ''(BLOB)'' as blob_col FROM mytable';

.net - , BLOB.

Answer 2

- / blobs, .