SQL REFERENCE (Page 2)
ALTER TABLE
 CREATE INDEX
CREATE TABLE
CREATE VIEW
 Data Types
DELETE Rows
DROP INDEX
DROP TABLE
 GRANT
INSERT

GRANT
Use the GRANT command to grant privileges to a user.

ClauseDescriptionRequired
GRANT privilege Indicates the privilege(s) to be granted. Yes
ON database object Indicates the database object(s) to which the privilege(s) pertain. Yes
TO username Indicates the user(s) to whom the the privilege(s) are to be granted. Yes

The following GRANT command grants the user Johnson the privilege of selcting rows from the Rep Table

  GRANT SELECT ON Rep TO Johnson
  ;

Back to Top

INSERT
Use the INSERT command to

ClauseDescriptionRequired
INSERT table name Indicates the name of the table to be altered. Yes
alteration Indicates the type of alteration to be performed. Yes

The following INSERT command would add one movie to the table created below:

CREATE TABLE movies (
  movie_id   NUMBER,
  title      VARCHAR2(30),
  director   VARCHAR2(30),
  actor      VARCHAR2(30),
  actress    VARCHAR2(30),
  company    VARCHAR2(30),
);
INSERT INTO movies VALUES ('231','JFK','Oliver Stone','Kevin Kostner','Sissy Spacek','Warner Bros.');

Back to Top