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) […]
Monthly Archives: April 2018
3 posts
You can’t have LOB data types (CLOB, BLOB, BFILE) ordered. Oracle will trigger an error when you try to order on LOB fields Same with grouping. You can’t apply GROUP BY on LOB fields. It will raise the same error.
When you modify existing column with DEFAULT value, then modification to add a DEFAULT value takes effect only from subsequent insertions to the table. Let’s have a look at EMP table below. All DEFAULT values are set to NULL at this point Let’s modify EMP .COMMISION_PCT DEFAULT value to 0.777 Now, the EMP .COMMISION_PCT […]