| [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 |