Privileges are basically rights to access any object or perform any operation on a view.
To create a view on a schema the user must have CREATE VIEW system privilege. To create a view …
Privileges are basically rights to access any object or perform any operation on a table. Updating the data of a table is an example of object privilege.
Below are the object privileges available for …
MINUS returns all the distinct rows from first select statement which are not present in second select statement.
Below is the graphical representation of MINUS operator.
CREATE TABLE EMPLOYEES_MINUS_30 AS SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, HIRE_DATE,…
INTERSECT operators returns the distinct common rows from each query.
Below is the graphical representation of INTERSECT operator.
CREATE TABLE EMPLOYEES_INTERSECT_30 AS SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, HIRE_DATE, JOB_ID, SALARY,…
Oracle SET operators combine two or more queries and return single set of result.
UNION operators combine two or more queries and return the …
Synonyms are data base objects which is created to provide a new name to a an object.
The source object can be under the same schema or may belong to another schema.
Keywords related to CREATE SEQUENCE statement: