Skip Headers
Oracle® Database Lite SQL Reference
10g (10.3.0)

Part Number B28925-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
View PDF

Index

A  B  C  D  E  F  G  H  I  J  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
ASCII function, 3.3.2
AVG function, 3.3.3

B

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

C

CASE function, 3.3.4
CAST Expression, 1.8.8
CAST function, 3.3.5
CEIL function, 3.3.6
CHAR datatype, E.5, E.5
CHAR, literal, D.1
character strings
comparison rules, 1.9.1
CHR function, 3.3.7
Clauses, 4.2.4
CLOB datatype, E.6
Commands
Alphabetical listing, 4.3
Clauses, 4.2.4
DDL, 4.2.1
DML, 4.2.2
Overview, 4.2
Pseudocolumns, 4.2.5
Transaction Control, 4.2.3
Types of, 4.1
Comments, 1.10
commit
autocommit, 4.3.7
COMMIT command, 4.3.7
comparison semantics
blank-padded, 1.9.1.1
nonpadded, 1.9.1.2
of character strings, 1.9.1
compound conditions, 1.7.8
Compound 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 clause, 4.3.8
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
create snapshot table, 4.3.19
DATABASE function, 3.3.16
DATE datatype, E.7
DATE literal, D.2
DAYOFMONTH function, 3.3.18
DAYOFWEEK function, 3.3.19
DAYOFYEAR function, 3.3.20
DDL (Data Definition Language) Commands, 4.2.1
DECIMAL datatype, E.8
DECIMAL literal, D.3
DECODE Expression, 1.8.5
DECODE function, 3.3.21
DELETE command, 4.3.24
DML (Data Manipulation Language) Commands, 4.2.2
DOUBLE literal, D.4
DOUBLE PRECISION datatype, 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.11
EXPLAIN PLAN command, 4.3.37
Expression List, 1.8.6
EXTRACT function, 3.3.22
Extract function, 3.3.22

F

FLOAT datatype, E.10
FLOAT literal, D.4
FLOOR function, 3.3.23
Formats, 1.6
Function Expression, 1.8.2
Functions
Alphabetical Listing, 3.3
Character, 3.2.2
Character returning number values, 3.2.3
Conversion, 3.2.5
Date, 3.2.4
Number, 3.2.1
Overview, 3.2
Types of, 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 datatype, E.11
INTEGER literal, D.5
Integrity constraints, 1.9

J

Java Function Expression, 1.8.3

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.9
Linguistiic Sort, 4.3.9
LOCATE function, 3.3.34
LONG datatype, E.12
LONG RAW datatype, E.13
LONG VARBINARY datatype, E.14
LONG VARCHAR datatype, 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

NEXT_DAY function, 3.3.45
NLS_SORT parameter, 4.3.9
NOW function, 3.3.46
NULL conditions, 1.7.5
NUMBER datatype, E.16
NUMBER literal, D.3
NUMERIC datatype, E.17
NUMERIC literal, D.3
NVL function, 3.3.47

O

ODBC
commit, 4.3.7
OFFSET clause, 4.3.46.9
OL__ROW_STATUS pseudocolumn, 4.3.19.2
Operators
Arithmetic, 2.2
Character, 2.3
Comparison, 2.4
Logical, 2.5
Other, 2.7
Overview, 2.1
Set, 2.6
Oracle Database Lite Object Naming Conventions, 1.5
Oracle Lite database
create snapshot table, 4.3.19

P

performance
EXPLAIN PLAN, 1.11
SQL operations
order of execution, 1.11
POLITE.INI, 4.3.9, F.1.3.1
POSITION function, 3.3.48
PRECISION literal, D.4
pseudocolumn
CURRVAL and NEXTVAL, 4.3.23
LEVEL, 4.3.40
OL__ROW_STATUS, 4.3.19.2
ROWID, 4.3.43
Pseudocolumns, 4.2.5

Q

QUARTER function, 3.3.49

R

range conditions, 1.7.4
RAW datatype, E.18
READ_COMMITTED
behavior, 4.3.46.10
REAL datatype, E.19
REAL literal, D.4
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
ROUND - Number function, 3.3.52
Row_Value_Constructor in a Subquery Comparison, 1.7.2.1
ROWID datatype, E.20
ROWID pseudocolumn, 4.3.43
ROWNUM pseudocolumn, pseudocolumn
ROWNUM, 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
Select
retrieving BLOB, 4.3.46.10
SELECT command, 4.3.46.2
SELECT statement
LIMIT clause, 4.3.46.9
OFFSET clause, 4.3.46.9
returning few records, 4.3.46.9
SET TRANSACTION command, 4.3.47
simple comparison conditions, 1.7.1
Simple Expression, 1.8.1
SMALLINT datatype, E.21
SMALLINT literal, D.5
snapshot
create snapshot table, 4.3.19
SQL
limitations, B
ODBC syntax conventions, 1.4
Overview, 1.1
Specifying conditions, 1.7
Specifying expressions, 1.8
SQL operations
order of execution, 1.11
SQL_AUTOCOMMIT, 4.3.7
SQLEndTrans, 4.3.7
SQLTransact
results, 4.3.7
STDDEV function, 3.3.56
Subquery in Place of a Column, 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 datatype, E.22
TIMESTAMP datatype, E.23
TIMESTAMPADD function, 3.3.61
TIMESTAMPDIFF function, 3.3.62
TINYINT datatype, E.24, E.24
TINYINT literal, D.5
TO_CHAR function, 3.3.63
TO_DATE function, 3.3.64
TO_NUMBER function, 3.3.65
transaction
READ_COMMITTED behavior, 4.3.46.10
Transaction Control Commands, 4.2.3
TRANSLATE function, 3.3.66
TRIM function, 3.3.67
TRUNC function, 3.3.68
TRUNCATE TABLE, 4.3.48

U

UPDATE command, 4.3.49
UPPER function, 3.3.69
USER function, 3.3.70

V

VARBINARY datatype, E.25
VARCHAR datatype, E.26
VARCHAR literal, D.1
VARCHAR2 datatype, E.27
Variable Expression, 1.8.7
VARIANCE function, 3.3.71

W

WEEK function, 3.3.72

Y

YEAR function, 3.3.73