You can have only one LONG field per table

Oracle won’t let you create a table with more than one LONG data type. Only one LONG is allowed per table.

And of course, you can’t make GROUP BY or ORDER BY operations over LONG data type fields ( similar to any LOB data type like CLOB, BLOB and BFILE)

 

 

 

 

Leave a comment

Your email address will not be published. Required fields are marked *