1.1

-- but do not assign value to 'SINCE' column
INSERT INTO TRADE.CUSTOMERS(CID ,CUST_NAME , ADDR ,TID)
VALUES (1, 'J. Pearson', 'VMWare', 1);
-- Insert two new customers using one statement
-- into the CUSTOMER table as in the previous example,
-- but do not assign value to 'SINCE' field of the new
customer.
INSERT INTO TRADE.CUSTOMERS (CID ,CUST_NAME , ADDR ,TID)
VALUES (1, 'J. Pearson' , 'VMWare', 1),
(2, 'David Y.' , 'VMWare', 1);
-- Insert the DEFAULT value for the LOCATION column
INSERT INTO TRADE.CUSTOMERS
VALUES (1, 'J. Pearson', DEFAULT, 'VMWare',1);
-- Insert using a select statement.
INSERT INTO TRADE.NEWCUSTOMERS
SELECT * from TRADE.CUSTOMERS WHERE TID=1;
REVOKE
Revoke privileges to a table or to a routine.
Syntax
The syntax used for the REVOKE statement differs depending on whether you revoke privileges to a table or
to a routine.
Syntax for Tables
REVOKE
privilege-type
ON [ TABLE ] { table-name | view-name } FROM
grantees
If you do not specify a column list, the statement revokes the privilege for all of the columns in the table.
Syntax for Routines
REVOKE EXECUTE ON { FUNCTION | PROCEDURE }
routine-designator
FROM
grantees
RESTRICT
You must use the RESTRICT clause on REVOKE statements for routines. The RESTRICT clause specifies that
the EXECUTE privilege cannot be revoked if the specified routine is used in a view, trigger, or constraint, and
the privilege is being revoked from the owner of the view, trigger, or constraint.
Description
The REVOKE statement removes permissions from a specific user or from all users to perform actions on
database objects.
vFabric SQLFire User's Guide510
vFabric SQLFire Reference