can we create the table with more than 2 Long datatype fields in PL/SQL ?

Question

In oracle PL/SQL, I had create the table with more than two LONG Datatype fields. It is not created the table? i want to declare the those two LONG fields are declared as a Primary Key also. How i can create the Table and declare the Primary Key ? Please give me the suggestions.

Answer 1

In pl/sql you can use number data type for corrosponding long datat type. you will be able to create table and primary key also. You will not be able to have more than 1 LOB per table.

Answer 2

Nope,
In SQL For EACH Table Only One Long Column is allowed.


ERROR at line 1:
ORA-01754: a table may contain only one column of type LONG