Oracle 11g SQL New Features
In continuation to my last tutorial on PL/SQL enhancements, I have compiled the list of enhancement pertaining to SQL. Similar to PL/SQL, Oracle had done considerable enhancements in SQL to raise performance level from instrumental to advisory. In the tutorial, we shall go through the performance oriented features, fresh additions and language enhancements. Performance improvements a. Alter table to add columns with default value In Oracle 11g, we can alter a table to add a column with a default value. Earlier, a developer used to update the value for the…
Read More