- page 25
DeleteRemove rows from a table.
DML table expression
Subquery restriction
Table collection expression
Where
Returning
|
Disassociate StatisticsDisassociate statistics from a column, function, package, type or index.
|
DropDrop statements are used to remove objects from the database. You can drop the following objects: Drop cluster
Drop context
Drop database link
Drop dimension
Drop directory
Drop function
Drop index
Drop indextype
Drop Java
Drop library
Drop materialized view
Drop materialized view log
Drop operator
Drop outline
Drop package
Drop procedure
Drop profile
Drop role
Drop rollback segment
Drop sequence
Drop synonym
Drop table
Drop tablespace
Drop trigger
Drop type
Drop type body
Drop
Drop view
|
Explain PlanInserts a row into the specified table describing each step in the SQL statement.
|
GrantGrants system and object privileges, and roles, to users and roles. Relational table
System privileges
Object privileges
On object
Grantee
|
InsertAdd rows to the database.
Single table insert
Insert into
Values
Returning
Multitable insert
Conditional insert
DML table expression
Subquery restriction
Table collection expression
|
Lock TableLocks one or more tables, overriding automatic locking.
|
MergeInsert or update rows in one table based on a selection from another table.
Merge update
Merge insert
|
NoauditStop auditing a particular audit statement.
SQL statement
Auditing by
Schema object
Auditing on
|
Rename
Change the
|
Revoke
Remove a privilege, role or grant from a
Revoke system privileges
Revoke object privileges
On object
Grantee
|
RollbackUndo the current transaction.
|
SavepointCreate a point in a transaction that can be rolled back to without rolling back the entire transaction.
|
SelectRetrieve data from the database.
Subquery
Subquery factoring
Select list
Table reference
Flashback
Query table expression
Sample
Subquery restriction
Table collection expression
Joined table
Join type
Hierarchical query
Group by
Rollup cube
Grouping sets
Grouping expression list
Expression list
Order by
For update
|
Set Constraint[S]Specify for a specific transaction if deferrable constraints are checked. Can be in either form SET CONSTRAINT or SET CONSTRAINTS.
|
Similar products
- Executable UML. A Foundation for Model-Driven Architecture
Mellor, s.j. , 2002, executable uml a foundation for model driven architecture - Executable UML. A Foundation for Model-Driven Architecture
Class diagram for bookstore system - Sams Teach Yourself PHP MySQL and Apache All in One
What do you by valid servername directive - Executable UML. A Foundation for Model-Driven Architecture
Use cases sky sea