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)
Though, you can create two or more CLOB, BLOB or BFILE fields at the same table. But ordering or grouping using these fields would not be possible.