1.Oracle数据库基础

17

DATATYPE —CHAR ............................................................................................................. 518 DATATYPE —DATE ............................................................................................................. 519 DATATYPE —FLOAT ........................................................................................................... 519 DATATYPE —LONG ............................................................................................................. 519 DATATYPE —LONGRAW .................................................................................................... 520 DATATYPE —MLSLABEL ................................................................................................... 520 DATATYPE —NUMBER ....................................................................................................... 520 DATATYPE —RAW ............................................................................................................... 520 DATATYPE —ROWID .......................................................................................................... 521 DATATYPE —VARCHAR ..................................................................................................... 521 DATATYPE —VARCHAR2 ................................................................................................... 521 DECLARE .............................................................................................................................. 522 DECODE ................................................................................................................................ 522 DEFINE .................................................................................................................................. 523 DEL ......................................................................................................................................... 523 DELETE ................................................................................................................................. 524 DEREF .................................................................................................................................... 525 DESCRIBE ............................................................................................................................. 525 DROP CLUSTER ................................................................................................................... 526 DROP DATABASE LINK ...................................................................................................... 526 DROP DIRECTORY .............................................................................................................. 527 DROP FUNCTION ................................................................................................................. 527 DROP INDEX ......................................................................................................................... 527 DROP LIBRARY .................................................................................................................... 528 DROP PACKAGE................................................................................................................... 528 DROP PROCEDURE ............................................................................................................. 529 DROP PROFILE ..................................................................................................................... 529 DROP ROLE ........................................................................................................................... 530 DROP ROLLBACK SEGMENT ............................................................................................ 530 DROP SEQUENCE ................................................................................................................ 531 DROP SNAPSHOT ................................................................................................................ 531 DROP SNAPSHOT LOG ....................................................................................................... 531 DROP SYNONYM ................................................................................................................. 532 DROP TABLE......................................................................................................................... 532 DROP TABLESPACE ............................................................................................................ 533 DROP TRIGGER .................................................................................................................... 533 DROP TYPE ........................................................................................................................... 534 DROP TYPE BODY ............................................................................................................... 534 DROP USER ........................................................................................................................... 535 DROP VIEW ........................................................................................................................... 535 DUMP ..................................................................................................................................... 536 DUP_VAL_ON_INDEX ......................................................................................................... 536 EDIT ....................................................................................................................................... 537 EMPTY_BLOB ...................................................................................................................... 537

18

EMPTY_CLOB ...................................................................................................................... 538 EXCEPTION INIT Pragma .................................................................................................... 538 EXECUTE .............................................................................................................................. 539 EXISTS ................................................................................................................................... 539 EXIT ....................................................................................................................................... 540 EXIT ....................................................................................................................................... 541 EXIT-WHEN .......................................................................................................................... 541 EXP ......................................................................................................................................... 542 EXPLAIN PLAN .................................................................................................................... 542 FETCH .................................................................................................................................... 543 FLOOR ................................................................................................................................... 544 FOR-LOOP ............................................................................................................................. 544 FORMAT ................................................................................................................................ 545 FORMAT —DATE ................................................................................................................. 545 FORMAT —NUMBER .......................................................................................................... 546 GET ......................................................................................................................................... 546 GLB ........................................................................................................................................ 547 GOTO ..................................................................................................................................... 547 GRANT ................................................................................................................................... 548 GREATEST ............................................................................................................................ 549 GREATEST_LB ..................................................................................................................... 549 HEXTORAW .......................................................................................................................... 550 HOST ...................................................................................................................................... 550 IF-THEN ................................................................................................................................. 550 IF-THEN-ELSE ...................................................................................................................... 551 IF-THEN-ELSEIF ................................................................................................................... 552 INITCAP ................................................................................................................................. 552 INPUT ..................................................................................................................................... 553 INSERT ................................................................................................................................... 553 INSTR ..................................................................................................................................... 554 INSTRB .................................................................................................................................. 555 INTERSECT ........................................................................................................................... 555 INVALID_CURSOR .............................................................................................................. 556 INVALID_NUMBER ............................................................................................................. 557 KEYWORDS .......................................................................................................................... 557 LABELS ................................................................................................................................. 559 LAST_DAY ............................................................................................................................ 559 LEAST .................................................................................................................................... 560 LEAST_LB ............................................................................................................................. 560 LENGTH ................................................................................................................................ 561 LENGTHB .............................................................................................................................. 561 LIKE ....................................................................................................................................... 562 LIST ........................................................................................................................................ 563 LN ........................................................................................................................................... 563

19

LOCK TABLE ........................................................................................................................ 564 LOG ........................................................................................................................................ 565 LOGIN_DENIED ................................................................................................................... 565 LOOP ...................................................................................................................................... 566 LOWER .................................................................................................................................. 566 LPAD ...................................................................................................................................... 567 LTRIM .................................................................................................................................... 567 LUB ........................................................................................................................................ 568 MAKE_REF ........................................................................................................................... 568 MAX ....................................................................................................................................... 569 MIN ......................................................................................................................................... 570 MINUS .................................................................................................................................... 570 MOD ....................................................................................................................................... 571 MONTHS_BETWEEN ........................................................................................................... 571 NEW_TIME ............................................................................................................................ 572 NEXT_DAY............................................................................................................................ 573 NEXTVAL .............................................................................................................................. 573 NLS_CHARSET_DECL_LEN ............................................................................................... 574 NLS_CHARSET_ID ............................................................................................................... 574 NLS_CHARSET_NAME ....................................................................................................... 574 NLS_INITCAP ....................................................................................................................... 575 NLS_LOWER ......................................................................................................................... 576 NLS_UPPER........................................................................................................................... 576 NO_DATA_FOUND ............................................................................................................... 577 NOAUDIT .............................................................................................................................. 577 NOT_LOGGED_ON .............................................................................................................. 578 NULL ...................................................................................................................................... 579 NVL ........................................................................................................................................ 579 OPEN ...................................................................................................................................... 580 OPEN-FOR ............................................................................................................................. 580 运算符 .................................................................................................................................... 581 运算符— < > .......................................................................................................................... 581 运算符—> .............................................................................................................................. 582 运算符—> = ........................................................................................................................... 582 运算符—! = ............................................................................................................................ 583 运算符—* .............................................................................................................................. 584 运算符—+ .............................................................................................................................. 584 运算符—-* ............................................................................................................................. 585 运算符—/ ............................................................................................................................... 585 运算符—<= ............................................................................................................................ 586 运算符—= .............................................................................................................................. 586 运算符—AND ........................................................................................................................ 587 运算符—BETWEEN ............................................................................................................. 588 运算符—IN ............................................................................................................................ 588

20

运算符—IS NOT NULL ........................................................................................................ 589 运算符—IS NULL ................................................................................................................. 589 运算符—NOT ........................................................................................................................ 589 运算符—NOT BETWEEN .................................................................................................... 590 运算符—NOT IN ................................................................................................................... 591 运算符—OR ........................................................................................................................... 591 PRIOR ..................................................................................................................................... 592 PROGRAM_ERROR ............................................................................................................. 592 PROMPT ................................................................................................................................ 593 PSEUDOCOLUMN ................................................................................................................ 593 RAISE ..................................................................................................................................... 594 RAWTOHEX .......................................................................................................................... 594 RECORD ................................................................................................................................ 595 REFTOHEX ............................................................................................................................ 596 REMARK ............................................................................................................................... 596 RENAME ................................................................................................................................ 597 REPFOOTER .......................................................................................................................... 597 REPHEADER ......................................................................................................................... 598 REPLACE ............................................................................................................................... 599 REPLACE ............................................................................................................................... 599 RETURN ................................................................................................................................ 600 REVOKE ................................................................................................................................ 600 ROLLBACK ........................................................................................................................... 601 ROUND .................................................................................................................................. 602 ROWIDTOCHAR ................................................................................................................... 603 ROWTYPE_MISMATCH ...................................................................................................... 603 RPAD ...................................................................................................................................... 604 RTRIM .................................................................................................................................... 605 SAVE....................................................................................................................................... 605 SAVEPOINT ........................................................................................................................... 606 SELECT .................................................................................................................................. 606 SELECT INTO ....................................................................................................................... 607 SET ......................................................................................................................................... 608 SET ROLE .............................................................................................................................. 609 SET TRANSACTION ............................................................................................................ 610 SHOW ..................................................................................................................................... 610 SIGN ....................................................................................................................................... 611 SIN .......................................................................................................................................... 612 SINH ....................................................................................................................................... 612 SOUNDEX ............................................................................................................................. 613 SPOOL .................................................................................................................................... 613 SQLERRM .............................................................................................................................. 614 SQLPLUS ............................................................................................................................... 614 SQRT ...................................................................................................................................... 615