[SYMBOL]
[A]
[B]
[C]
[D]
[E]
[F]
[G]
[H]
[I]
[J]
[K]
[L]
[M]
[N]
[O]
[P]
[Q]
[R]
[S]
[T]
[U]
[V]
[W]
[X]
[Y]
parameter object types (ADO.NET)
parameters
binding input
bound [See bound parameters]
parametrized statements
parentheses
nested and operator precedence
PARSENAME function
SQL Server
partitioned tables
Oracle
altering
partitioning clause
PASSWORD function (MySQL)
PATH datatype
platform comparison
PostgreSQL
PATH function
Oracle
PostgreSQL
PATINDEX function
SQL Server
PCLOSE function (PostgreSQL)
PERCENT_RANK function 2nd 3rd
PERCENTILE_CONT function 2nd
PERCENTILE_DISC function 2nd
PERIOD_ADD function (MySQL)
PERIOD_DIFF function (MySQL)
permissions
PERMISSIONS function
SQL Server
physical_attributes_clause (Oracle)
PI( ) function
MySQL
PostgreSQL
SQL Server
PL/pgSQL
PL/SQL
platform comparisons
POINT datatype
platform comparison
PostgreSQL
POINT function (PostgreSQL)
POLYGON datatype
platform comparison
PostgreSQL
POLYGON function (PostgreSQL)
POPEN function (PostgreSQL)
POSITION function
MySQL
POSSTR function (DB2)
PostgreSQL
allowed characters in identifiers
beginning identifier character
CLOSE CURSOR statement
COMMIT statement
CONNECT statement
connecting using JDBC
CREATE/ALTER DATABASE statements
CREATE/ALTER FUNCTION/PROCEDURE statements
CREATE/ALTER INDEX statements
CREATE/ALTER METHOD statements
CREATE/ALTER ROLE statements
CREATE/ALTER SCHEMA statements
CREATE/ALTER TABLE statements
CREATE/ALTER TRIGGER statements
CREATE/ALTER TYPE statements
CREATE/ALTER VIEW statements
datatypes
DECLARE CURSOR command
DELETE statement
DISCONNECT statement
DROP statements
[PROCEDURAL] LANGUAGE
AGGEGATE
DATABASE
FUNCTION
GROUP
INDEX
OPERATOR
RULE
SEQUENCE
TABLE
TRIGGER
TYPE
USER
VIEW
EXCEPT set operator
FETCH statement
functions
ABSTIME
ACOS
AGE
AREA
ASCII
ASIN
ATAN
ATAN2
BOX
BROADCAST
CBRT
CENTER
CHAR
CHAR_LENGTH
CIRCLE
COALESCE
COS
COT 2nd
DATE_PART
DATE_TRUNC
DEGREES
DIAMETER
FLOAT
FLOAT4
HEIGHT
HOST
INITCAP
INTEGER
INTERVAL
ISCLOSED
ISFINITE
ISOPEN
LENGTH
LOG
LPAD
LSEG
LTRIM
MASKLEN
NETMASK
NETWORK
NPOINTS
NULLIF
PATH
PCLOSE
PI( )
POINT
POLYGON
POPEN
POW
RADIANS
RADIUS
RELTIME
ROUND
RPAD
RTRIM
SET_MASKLEN
SIN
SUBSTR
SUBSTRING
TAN
TEXT
TIMESTAMP
TO_CHAR
TO_DATE
TO_NUMBER
TO_TIMESTAMP
TRANSLATE
TRUNC
VARCHAR
WIDTH
GRANT statement
identifier size
INSERT statement
INTERSECT set operator
JOIN subclause
keywords
LIKE operator
MERGE statement
OPEN statement
ORDER BY clause
RELEASE SAVEPOINT statement
reserved identifiers
RETURN statement
REVOKE statement
ROLLBACK statement
SAVEPOINT statement
schema addressing
SELECT statement
[CROSS] JOIN
ALL
AS
FOR UPDATE OF
FROM
FULL [OUTER] JOIN
GROUP BY
INNER JOIN
INTO
LEFT [OUTER] JOIN
NATURAL
ON
ORDER BY
RIGHT [OUTER] JOIN
select_item
SET CONNECTION statement
SET CONSTRAINT statement
SET PATH statement
SET ROLE statement
SET SCHEMA statement
SET SESSION AUTHORIZATION statement
SET statement
SET TIME ZONE statement
SET TRANSACTION statement
START TRANSACTION statement
SUBQUERY substatement
TRUNCATE TABLE statement
UNION set operator
UPDATE statement
web site
WHERE clause
PostgreSQL keywords
pound symbol (#)
POW function
MySQL
PostgreSQL
POWER function
MySQL
POWERMULTISET function (Oracle)
prefixes
PreparedStatement set methods (JDBC)
PRESENTNNV function (Oracle)
PRESENTV function (Oracle)
PREVIOUS function (Oracle)
primary databases (Oracle)
PRIMARY KEY constraints
PROC_ROLE function
procedural programming
PROCEDURE, quick reference
PROCESSADMIN (SQL Server system role)
programming databases
examples
overview
|
