Home > SQL Developer: TimesTen Tasks > Specify and Display LOB Dat...
If you are using TimesTen release 11.2.2.2.0 or greater, then you can specify and display LOB data types in your table definitions.
If you want to create a table with a LOB data type, then in the Create Table dialog, expand the Type column header. You see CLOB
, NCLOB
, and BLOB
as valid data types.
To view the data type for your columns, select the table and then choose the Columns tab. You see the LOB data type for your column.
If you want to add a column and specify a LOB data type, in the Add Column dialog, expand Data Type. You see CLOB
, NCLOB
, and BLOB
among the possible choices.
For PL/SQL objects, you can specify LOB data types as IN
, OUT
, and IN OUT
parameters. In the PL/SQL edit dialogs, for parameter types, choose CLOB
, NCLOB
, or BLOB
.
Related Topics