1.1.1

To revoke the UPDATE privilege on columns c1 and c2 of table s.v from all users:
REVOKE UPDATE (c1,c2) ON TABLE test.sample FROM PUBLIC;
To revoke the EXECUTE privilege on procedure p from the authorization ID george:
REVOKE EXECUTE ON PROCEDURE p FROM richard RESTRICT;
SELECT
A query with an optional ORDER BY CLAUSE and an optional FOR UPDATE clause.
Syntax
Query [ ORDER BY Clause ] [ FOR UPDATE Clause ]
Description
A SELECT statement consists of a query with an optional ORDER BY CLAUSE and an optional FOR UPDATE
clause. The SELECT statement is so named because the typical first word of the query construct is SELECT.
(Query includes the VALUES expression as well as SELECT expressions).
The ORDER BY CLAUSE guarantees the ordering of the ResultSet. The FOR UPDATE clause acquires a lock
on the selected rows and makes the result set's cursor updatable.
A SELECT statement returns a ResultSet. A cursor is a pointer to a specific row in ResultSet. In Java applications,
all ResultSets have an underlying associated SQL cursor, often referred to as the result set's cursor. The cursor
can be updatable,that is, you can update or delete rows as you step through the ResultSet if the SELECT statement
that generated it and its underlying query meet cursor updatability requirements, as detailed below. The FOR
UPDATE clause can be used to ensure a compilation check that the SELECT statement meets the requiremments
of a updatablecursors, or to limit the columns that can be updated.
Note: The ORDER BY clause allows you to order the results of the SELECT. Withoutthe ORDER BY
clause, the results are returned in random order. Unlike in some other databases, the select results have
no relation with the insertion order of those rows in the table.
Requirements for updatable cursors and updatable ResultSets
Only simple, single-table SELECT cursors can be updatable. The SELECT statement for updatable ResultSets
has the same syntax as the SELECT statement for updatablecursors.
To generate updatable cursors:
• The SELECT statement must not include an ORDER BY clause.
• The underlying Query must be a SelectExpression.
• The SelectExpression in the underlying Query must not include:
• DISTINCT
• Aggregates
• GROUP BY clause
• HAVING clause
• ORDER BY clause
• The FROM clause in the underlying Query must not have:
• more than one table in its FROM clause
• anything other than one table name
vFabric SQLFire User's Guide528
vFabric SQLFire Reference