英语论文网

the SELECT statement query.
The FETCH statement scrolls the cursor through the data until the variables have been
loaded. Then the cursor scrolls to the next record.
DROP DATABASE
DROP DATABASE database_name;
DROP DATABASE statement completely deletes a database, including all data and the
database's physical structure on disk.
DROP INDEX
DROP INDEX index_name;
DROP INDEX statement removes an index from a table.
DROP PROCEDURE
drop procedure procedure_name
DROP PROCEDURE statement drops a stored procedure from the database; its function is
similar to the DROP TABLE and DROP INDEX statements.
DROP TABLE
DROP TABLE table_name;
DROP TABLE statement drops a table from a database.
DROP TRIGGER
DROP TRIGGER trigger_name
DROP TRIGGER statement removes a trigger from a database.
DROP VIEW
DROP VIEW view_name;
DROP VIEW statement removes a view from a database.
EXECUTE
execute [@return_status = ]
procedure_name
[[@parameter_name =] value |
[@parameter_name =] @variable [output]...]]
EXECUTE command runs a stored procedure and its associated SQL statements.
Parameters can be passed to the stored procedure, and data can be returned in these
parameters if the output keyword is used.
FETCH
fetch cursor_name [into fetch_target_list]
FETCH command loads the contents of the cursor's data into the provided program
variables. After the variables have been loaded, the cursor scrolls to the next record.
FROM
FROM <tableref> [, <tableref> ...]
FROM specifies which tables are used and/or joined.
GRANT
GRANT role TO user
or
GRANT system_privilege TO {user_name | role | PUBLIC}
GRANT command grants a privilege or role to a user who has been created using the
CREATE USER command.
GROUP BY
GROUP BY <col> [, <col> ...]
GROUP BY statement groups all the rows with the same column value.
HAVING
HAVING <search_cond>
HAVING is valid only with GROUP BY and limits the selection of groups to those that
satisfy the search condition.
INTERSECT
INTERSECT
INTERSECT returns all the common elements of two SELECT statements.
ORDER BY
ORDER BY <order_list>
ORDER BY statement orders the returned values by the specified column(s).
ROLLBACK TRANSACTION
ROLLBACK TRANSACTION statement effectively cancels all work done within a
transaction (since the BEGIN TRANSACTION statement was executed).
REVOKE
REVOKE role FROM user;
or
REVOKE {object_priv | ALL [PRIVILEGES]}
[, {object_priv | ALL [PRIVILEGES]} ] ...
ON [schema.]object
FROM {user | role | PUBLIC} [, {user | role | PUBLIC}] ...
REVOKE command removes a database privilege from a user, whether it be a system
privilege or a role.
SELECT
SELECT [DISTINCT | ALL]
SELECT statement is the beginning of each data retrieval statement. The modifier
DISTINCT specifies unique values and prevents duplicates. ALL is the default and
allows duplicates.
SET TRANSACTION
SQL> SET TRANSACTION (READ ONLY | USE ROLLBACK SEGMENT);
SET TRANSACTION enables the user to specify when a transaction should begin. The
READ ONLY option locks a set of records until the transaction ends to ensure that the
data is not changed.
UNION
UNION
UNION statement returns all the elements of two SELECT statements.
WHERE
留学生用英语WHERE <search_cond>
WHERE statement limits the rows retriev