-
Write ONLY ONE SQL statement which produces the following output
DEPARTMENT_ID EMP_COUNT DEPT_PERCENTAGE
-
-
FLASHBACK concept ? What is it?
Can any one help me on FLASHBACK concept ? What is it?
-
Group By
Create a query using “ group by” that shows maximum salary for each department?
-
DML operations on base tables using a simple view
Can we make DML operations on base tables using a simple view?Can we insert or update or delete rows to the base tables using a view?