[计算机软件及应用]ORACLE 数据库实用附录.pdf

ORACLE 数据库实用指南附录 赵元杰 2002 年11 月 15 日 目 录 附录A：SQL及SQL*PLUS 常用命令参考 10 %FOUND 10 %ISOPEN 10 %NOTFOUND 11 %ROWCOUNT 12 %ROWTYPE 12 %TYPE 13 (+) 14 @ (“at” 号) 14 @@ 15 ABS 15 ACCEPT 16 ACOS 16 ADD_MONTHS 17 ALTER CLUSTER 17 ALTER DATABASE 18 ALTER FUNCTION 19 ALTER INDEX 19 ALTER MATERIALIZED VIEW 20 ALTER MATERIALIZED VIEW LOG 20 ALTER PACKAGE 21 ALTER PROCEDURE 21 ALTER PROFILE 21 ALTER RESOURCE COST 22 ALTER ROLE 23 ALTER ROLLBACK SEGMENT 23 ALTER SEQUENCE 24 ALTER SESSION 24 ALTER SNAPSHOT 25 ALTER SNAPSHOT LOG 26 ALTER SYSTEM 26 ALTER TABLE 27 ALTER TABLESPACE 28 ALTER TRIGGER 29 ALTER TYPE 29 ALTER USER 30 ALTER VIEW 31 ANALYZE 31 APPEND 32 ASCII 32 ASIN 33 ATAN 33 ATAN2 34 AUDIT 34 AVG 35 BFILENAME 35 BLOCK 36 BTITLE 37 CEIL 38 CHANGE 39 CHARTOROWID 39 CHR 40 CLEAR 40 CLOSE 41 COLUMN 41 COMMENT 42 COMMIT 43 COMPUTE 43 CONCAT 44 CONCATENATE 44 CONNECT BY 45 CONVERT 45 COPY 46 COS 47 COSH 47 COUNT 48 CREATE CLUSTER 48 CREATE CONTROLFILE 49 CREATE DATABASE 50 CREATE DATABASE LINK 51 CREATE DIRECTORY 51 CREATE FUNCTION 52 CREATE INDEX 52 CREATE LIBRARY 53 CREATE MATERIALIZED VIEW 54 CREATE MATERIALIZED VIEW LOG 54 CREATE PACKAGE 55 CREATE PACKAGE BODY 56 CREATE PROCEDURE 57 CREATE PROFILE 58 CREATE ROLE 59 CREATE ROLLBACK SEGMENT 59 CREATE SCHEMA 60 CREATE SEQUENCE 61 CREATE SNAPSHOT 61 CREATE SNAPSHOT LOG 62 CREATE SYNONYM 63 CREATE TABLE 63 CREATE TABLESPACE 65 CREATE TRIGGER 66 CREATE TYPE 67 CREATE TYPE BODY 68 CREATE USER 68 CREATE VIEW 69 CURRVAL 70 CURSOR_ALREADY_OPEN 70 DATATYPE 71 DATATYPE —CHAR 71