For viewing long binary object data, you can launch the LOB viewer from the SQL Editor or the Execution Console. CLOB, BLOB and BFILE arguments are supported (as are Object and Collection Types) if you use bind variables for the output.
Click the Ellipsis button in a LOB column …
… to open the LOB viewer
You can work with the following Oracle8i LOB datatypes.
|
|
View |
Edit |
|
BLOB |
Y |
N |
|
CLOB |
Y |
Y |
|
BFILE |
Y |
N |
|
NCLOB |
Y |
N |
|
|
|
|
|
SQL Navigator does not support working with LOB or Object table columns when using an Oracle 7 client connected to Oracle 8 database. For full functionality, use an Oracle 8 client to connect to an Oracle 8 database. |
|
|
|
