Select ename,salary*12'annual salary' from employee
Select ename,salary*12 as initcap(annual salary)from employee
Select ename,salary*12"annual salary" from employee
Select ename,salary*12 as annual salary from employee
When indexed columns are part of an expression
When indexed xolumns are declared as not null
When indexed column contains wide range of values
The indexed columns are used in FROM clause
Your table names are too long
You have too many tables
Your table have difficult names
You have too many columns on the table
The underlying tables must be in the same schema
The underlying tables must have data
You need select privileges on the view
You need select privileges only on underlying tables
Descending by date
Ascending by date
Creates a view with constraints
Creates a view in another schema
Creates a view even if the underlying parents table has constraints
Creates a view regardless of whether or not the base tables exists
ROLLBACK TO SAVEPOINT C;
SELECT MAX(SAL) FROM employees WHERE DEPARTMENT_ID=20;
GRANT SELECT ON employees TO SCOTT;
ALTER TABLE employee SET UNUSED COLUMNS SAL;
The inner query must always return a value or outer query will return an error
The inner query wil return values to the outer query
The inner query always sorts the result of the outer query
The outer query must return a value to the inner query
Manipulate data items
Accept only one argument and returns only one value
Returns one result per row
Cannot be nested
The line numbers reported match the line numbers you see in your text editor.
SQL*Plus will automatically show the errors to you.
To see the errors, enter SHOW ERRORS in SQL*Plus.
If there are no syntax errors, you will receive the message "NO ERRORS."
ON DELETE CASCADE
ON UPDATE CASCADE
CREATE SEQUENCE[sequence name]
DROP SEQUENCE[sequence name]
DESCRIBE STRUCTURE [TableName].
DESC TABLE [TableName].
FLASHBACK TABLE.......TO DROP
FLASHBACK TABLE........TO BEFORE DROP
FLASHBACK TABLE ....FROM RECYCLEBIN