Oracle system privilege


A system privilege is the right to perform an action on any schema objects of a particular type.

Like, the privileges to create tablespaces and to delete the rows of any table in a database are system privileges.

There are over 60 distinct system privileges.

Any Privilege

System privileges that use the ANY keyword enable you to set privileges for an entire category of objects in the database. PUBLIC privileges are granted to every user in an Oracle database, and can be granted to roles and as users.
Explain sub-queries in brief
Sub-query is the technique that lets us use the result of one query as part of another query.....
Different operators used in building sub queries
Following operators can be used in building sub queries: IN: Allows multiple values to be checked. EXIST: Checks if a value exists......
What are the guidelines for using SUB-QUERIES?
Following things need to be kept in mind when you write sub-queries: Caution should be taken with simple sub-query, especially when a normal value operator is used on the results of a sub-query, only one field must be returned....
Post your comment