bok



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



    • Powrót