1.
In SQLPLUS the command set pagesize does not set the size of the body of the report. It sets the total length of the page measured in lines upto btitle including the set newpage value
2.
Views do not contain any data. Tables contain data. All though we can create "materialised views" that contain data. Thy are truly tables not views.
3.
To modify the datatype of a column the column must be empty. To add a column with NOT NULL constraint, the table must be empty.
4.
Every compute avg command must have a break on command to guide it and the on portion of both commands must match.
5.
We cannot perform functions such as length on a column that uses a long datatype.
6.
DUAL is a small but useful oracle table created for testing functions or doing a quick calculations.
7.
Not every table is joined to every other table. The number of links between the tables is usually one less than the number of tables being joined.
8
To store the fractional seconds , we can use the timestamp and **timestamp with timezone.