| | FUNKCJE
Agregacji Avg Count Max Min StDev StdDev StDevP Sum Var Variance VarP
Matematyczne Abs Bit_Length Ceil Floor Greatest Least Length Mod Octet_Length Position Power Round Sign Sqrt Trunc Znakowe Ascii Chr Convert Initcap Lower Lpad Ltrim Replace Rpad Rtrim Soundex Substr Substring Translate Trim Upper
Inne funkcje Current_Date Current_Time Current_Timestamp Session_User System_User Current_User
INSTRUKCJE
ALLOCATE CURSOR ALLOCATE DESCRIPTOR ALTER DOMAIN ALTER TABLE CLOSE COMMIT WORK CONNECT CREATE ASSERTION CREATE CHARACTER SET CREATE COLLATION CREATE DOMAIN CREATE INDEX CREATE SCHEMA CREATE TABLE CREATE TRANSLATION CREATE VIEW DEALLOCATE DESCRIPTOR DEALLOCATE PREPARE DECLARE CURSOR DECLARE LOCAL TEMPORARY TABLE DELETE DESCRIBE DISCONNECT DROP ASSERTION DROP CHARACTER SET DROP COLLATION DROP DOMAIN DROP INDEX DROP SCHEMA DROP TABLE DROP TRANSLATION DROP VIEW EXECUTE EXECUTE IMMEDIATE FETCH GET DESCRIPTOR GET DIAGNOSTIC GRANT INSERT OPEN PREPARE RENAME REVOKE ROLLBACK WORK SELECT SET CATALOG SET CONNECTION SET CONSTRAINTS MODE SET DESCRIPTOR SET NAMES SET SCHEMA SET SESSION AUTHORIZATION SET TIME ZONE SET TRANSACTION TRANSFORM UPDATE
KLAUZULE(wybrane)
AS CASCADE COLLATE FROM GROUP BY HAVING IN ON COMMIT ORDER BY RESTRICT WHERE
PREDYKATY
ALL ANY BETWEEN DISTINCT DISTINCTROW EXISTS IN LIKE NULL OVERLAPS SOME TOP UNIQUE
TYPY DANYCH
BINARY BIT BIT VARYING BOOLEAN BYTE CHAR COUNTER CURRENCY DATE DATETIME DECIMAL DOUBLE DOUBLE PRECISION FLOAT INTEGER INTERVAL LONG LONGBINARY LONGTEXT NUMERIC REAL SHORT SINGLE SMALLINT TEXT TIME TIMESTAMP VARCHAR
INNE
Not NULL
|