2.1. SQL DDL Statements by Task
Often one of the most frustrating and time-consuming aspects of working with an Oracle database is simply finding the proper statement to accomplish a particular task. Table 2-1 lists most common data definition tasks, along with the appropriate SQL statements used to accomplish each task. You will find the detailed syntax of each statement later in this chapter.
If you want to | Use this statement |
---|---|
Add a column/integrity constraint to a table | ALTER TABLE |
Add a comment about a table, view, snapshot, or column into the data dictionary | COMMENT |
Add a resource limit from an existing profile | ALTER PROFILE |
Add datafiles to an existing tablespace | ALTER TABLESPACE |
Add/rename data files | ALTER TABLESPACE |
Allocate an extent for a cluster | ALTER CLUSTER |
Allocate an extent for the table | ALTER TABLE |
Allow/disallow access to a table | GRANT/REVOKE ROLE |
Allow/disallow writing to a table | ALTER TABLE |
Allow/disallow writing to a tablespace | ALTER TABLESPACE |
Associate a method of statistics computation with database objects | ASSOCIATE STATISTICS |
Audit a specific schema object | AUDIT |
Audit specific SQL statements | AUDIT |
Back up the current control file | ALTER DATABASE |
Begin/end a backup by putting a tablespace in backup or normal mode | ALTER TABLESPACE |
Bring a rollback segment online/offline | ALTER ROLLBACK SEGMENT |
Change a resource limit from an existing profile | ALTER PROFILE |
Change a user's default role | ALTER ... |
Get Oracle SQL: the Essential Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.