Skip Headers

Oracle® Database Lite SQL Reference Release 10.3 Part Number E12092-02 |
Home | Book List | Contents | Contact Us

Previous
| View PDF

# Index

A B C D E F G H I K L M N O P Q R S T U V W Y

## A

  ADD_MONTHS function, 3.3.1
  ALTER SEQUENCE command, 4.3.1
  ALTER SESSION command, 4.3.2
  ALTER TABLE command, 4.3.3
  ALTER TRIGGER, 4.3.4
  ALTER USER command, 4.3.5
  ALTER VIEW, 4.3.6
  arithmetic operators, 2.2
  ASCII function, 3.3.2
  AVG function, 3.3.3

## B

  Backus-Nauer Form, 4.2.6, A.7
  BIGINT, E.1
  BINARY, E.2
  BIT, E.3
  BLOB, E.4
    effect on Select, 4.3.46.9
  BNF Notation, 4.2.6, A.5, A.7

## C

  CASE function, 3.3.4
  CAST expression, 1.8.8, 3.3.5
  CEIL function, 3.3.6
  CHAR, D.1, E.5, E.5
  character
    functions, 3.2.2
      returning number values, 3.2.3
    operators, 2.3
    strings
      comparison rules, 1.9.1
  CHR function, 3.3.7
  clauses, 4.2.4
  CLOB, E.6
  column
    using subquery, 1.7.2.2
  commands
    clauses, 4.2.4
    DDL, 4.2.1
    DML, 4.2.2
    overview, 4.2
    pseudocolumns, 4.2.5
    SQL, 4.1, 4.3
    transaction, 4.2.3
  commit
    autocommit, 4.3.7
  COMMIT command, 4.3.7
  comparison operators, 2.4
  comparison semantics
    blank-padded, 1.9.1.1
    nonpadded, 1.9.1.2
    of character strings, 1.9.1
  compound
    conditions, 1.7.8
    expression, 1.8.4
  CONCAT function, 3.3.8
  conditions
    compound, 1.7.8
    EXISTS, 1.7.6
    group comparison, 1.7.2
    LIKE, 1.7.7
    membership, 1.7.3
    NULL, 1.7.5
    range, 1.7.4
    simple comparison, 1.7.1
  constraint
    database, 1.10
    foreign key, 1.10
    not null, 1.10
    primary key, 1.10
    unique, 1.10
  CONSTRAINT clause, 4.3.8
  conversion function, 3.2.5
  COUNT function, 3.3.10
  CREATE DATABASE, 4.3.9
  CREATE FUNCTION command, 4.3.10
  CREATE GLOBAL TEMPORARY TABLE, 4.3.11
  CREATE INDEX command, 4.3.12
  CREATE JAVA, 4.3.13
  CREATE PROCEDURE, 4.3.14
  CREATE SCHEMA command, 4.3.15
  CREATE SEQUENCE command, 4.3.16
  CREATE SNAPSHOT TABLE, 4.3.19
  CREATE SYNONYM command, 4.3.17
  CREATE TABLE Command, 4.3.18
  CREATE TRIGGER command, 4.3.20
  CREATE USER, 4.3.21, 4.3.21
  CREATE VIEW, 4.3.22
  CURDATE function, 3.3.11
  CURRENT_DATE function, 3.3.12
  CURRENT_TIME function, 3.3.13
  CURRENT_TIMESTAMP function, 3.3.14
  CURRVAL and NEXTVAL pseudocolumn, 4.3.23
  CURTIME function, 3.3.15

## D

  database
    constraint, 1.10
    CREATE SNAPSHOT TABLE, 4.3.19
  DATABASE function, 3.3.16
  DATE, D.2, E.7
  date function, 3.2.4, 3.3.51
  DAYOFMONTH function, 3.3.18
  DAYOFWEEK function, 3.3.19
  DAYOFYEAR function, 3.3.20
  DDL
    commands, 4.2.1
  DECIMAL, D.3, E.8
  DECODE, 1.8.5, 3.3.21
  DELETE command, 4.3.24
  DML
    commands, 4.2.2
  DOUBLE, D.4
  DOUBLE PRECISION, E.9
  DROP clause, 4.3.25
  DROP FUNCTION command, 4.3.26
  DROP INDEX command, 4.3.27
  DROP JAVA command, 4.3.28
  DROP PROCEDURE command, 4.3.29
  DROP SCHEMA command, 4.3.30
  DROP SEQUENCE command, 4.3.31
  DROP SYNONYM command, 4.3.32
  DROP TABLE command, 4.3.33
  DROP TRIGGER command, 4.3.34
  DROP USER command, 4.3.35
  DROP VIEW command, 4.3.36

## E

  EXISTS
    conditions, 1.7.6
  EXPLAIN PLAN, 1.12, 4.3.37
  EXPRESSION LIST, 1.8.6
  EXTRACT function, 3.3.22

## F

  FLOAT, D.4, E.10
  FLOOR function, 3.3.23
  foreign key
    constraint, 1.10
  function
    character, 3.2.2, 3.2.3
    conversion, 3.2.5
    date, 3.2.4
    expression, 1.8.2
    Java, 1.8.3
    number, 3.2.1
    overview, 3.2
    SQL, 3.3
    SQL function types, 3.1

## G

  GRANT command, 4.3.38
  GREATEST function, 3.3.24
  group comparison conditions, 1.7.2

## H

  HOUR function, 3.3.25

## I

  INITCAP function, 3.3.26
  INSERT, 4.3.39
  INSTR function, 3.3.27
  INSTRB function, 3.3.28
  INTEGER, D.5, E.11
  Integrity constraints, 1.9

## K

  Keywords, C.1

## L

  LAST_DAY function, 3.3.30
  LEAST function, 3.3.31
  LENGTH function, 3.3.32
  LENGTHB function, 3.3.33
  LEVEL pseudocolumn, 4.3.40
  LIKE conditions, 1.7.7
  LIMIT clause, 4.3.46.8
  Linguistiic Sort, 4.3.9
  LOCATE function, 3.3.34
  logical operators, 2.5
  LONG, E.12
  LONG RAW, E.13
  LONG VARBINARY, E.14
  LONG VARCHAR, E.15
  LOWER function, 3.3.35
  LPAD function, 3.3.36
  LTRIM function, 3.3.37

## M

  MAX function, 3.3.38
  membership conditions, 1.7.3
  MIN function, 3.3.39
  MINUTE function, 3.3.40
  MOD function, 3.3.41
  MONTH function, 3.3.42, 3.3.43
  MONTHS_BETWEEN function, 3.3.44

## N

  naming conventions
    object, 1.5
  NEXT_DAY function, 3.3.45
  NLS_SORT parameter, 4.3.9
  not null
    constraint, 1.10
  NOW function, 3.3.46
  NULL conditions, 1.7.5
  NUMBER, D.3, E.16
    function, 3.3.52
  NUMBER function, 3.2.1
  NUMERIC, D.3, E.17
  NVL function, 3.3.47

## O

  object
    naming conventions, 1.5
  ODBC
    commit, 4.3.7
    syntax, 1.4
  OFFSET clause, 4.3.46.8
  OL__ROW_STATUS pseudocolumn, 4.3.19.2
  operators, 2.7
    arithmetic, 2.2
    character, 2.3
    comparison, 2.4
    logical, 2.5
    overview, 2.1
    set, 2.6

## P

  performance
    EXPLAIN PLAN, 1.12
    SQL
      order of execution, 1.12
  POLITE.INI, 4.3.9, F.1.3.1
  POSITION function, 3.3.48
  PRECISION, D.4
  primary key
    constraint, 1.10
  pseudocolumn, 4.2.5
    CURRVAL and NEXTVAL, 4.3.23
    LEVEL, 4.3.40
    OL__ROW_STATUS, 4.3.19.2
    ROWID, 4.3.43
    ROWNUM, 4.3.44

## Q

  QUARTER function, 3.3.49

## R

  range conditions, 1.7.4
  RAW, E.18
  READ_COMMITTED
    behavior, 4.3.46.9
  REAL, D.4, E.19
  REPLACE function, 3.3.50
  reserved words, C.2
  REVOKE command, 4.3.41
  ROLLBACK command, 4.3.42
  ROUND
    date function, 3.3.51
    number function, 3.3.52
  ROW_VALUE_CONSTRUCTOR, 1.7.2.1
  ROWID, E.20
    pseudocolumn, 4.3.43
  ROWNUM
    pseudocolumn, 4.3.44
  RPAD function, 3.3.53
  RTRIM function, 3.3.51

## S

  SAVEPOINT command, 4.3.45
  SECOND function, 3.3.55
  SELECT, 4.3.46, 4.3.46.2
    retrieving BLOB, 4.3.46.9
    statement
      LIMIT clause, 4.3.46.8
      OFFSET clause, 4.3.46.8
      returning few records, 4.3.46.8
  set operators, 2.6
  SET TRANSACTION command, 4.3.47
  simple
    expression, 1.8.1
  simple comparison conditions, 1.7.1
  SMALLINT, D.5, E.21
  snapshot
    CREATE SNAPSHOT TABLE, 4.3.19
  SQL
    commands, 4.1, 4.3
    comments, 1.11
    function, 3.3
    functions, 3.1, 3.2
    limitations, B
    ODBC syntax conventions, 1.4
    operators, 2.1
    order of execution, 1.12
    overview, 1.1
    specifying conditions, 1.7
    specifying expressions, 1.8
  SQL_AUTOCOMMIT, 4.3.7
  SQLEndTrans, 4.3.7
  SQLTransact
    results, 4.3.7
  STDDEV function, 3.3.56
  subquery, 1.7.2.2
  SUBSTR function, 3.3.57
  SUM function, 3.3.59, 3.3.59
  synchronization
    CREATE SNAPSHOT TABLE, 4.3.19
  SYSDATE function, 3.3.60

## T

  table
    CREATE SNAPSHOT TABLE, 4.3.19
  TIME, D.6, E.22
  TIMESTAMP, D.7, D.7, E.23
  TIMESTAMPADD function, 3.3.61
  TIMESTAMPDIFF function, 3.3.62
  TINYINT, D.5, E.24
  TO_CHAR function, 3.3.63
  TO_DATE function, 3.3.64
  TO_NUMBER function, 3.3.65
  transaction
    commands, 4.2.3
    READ_COMMITTED behavior, 4.3.46.9
  TRANSLATE function, 3.3.66
  TRIM function, 3.3.67
  TRUNC function, 3.3.68
  TRUNCATE TABLE, 4.3.48

## U

  unique
    constraint, 1.10
  UPDATE command, 4.3.49
  UPPER function, 3.3.69
  USER function, 3.3.70

## V

  VARBINARY, E.25
  VARCHAR, D.1, E.26
  VARCHAR2, E.27
  VARIABLE EXPRESSION, 1.8.7
  VARIANCE function, 3.3.71

## W

  WEEK function, 3.3.72

## Y

  YEAR function, 3.3.73