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.
The common perception is that SUBQUERY can’t be used inside the VALUES clause. And frankly speaking, there are many situations on the […]
It looks like you have a very big chance of getting this question on your exam. In first insert statement, we just […]
There are some questions on the exam to verify your knowledge about finding the second highest value of the table or column. […]
If you have a column with NOT NULL restriction and at the same time this same column provided a DEFAULT value, then […]
