トーク:SQL

未執筆

• CREATE ASSERTION
• CREATE CARACTER SET
• CREATE COLLATION
• CREATE DOMAIN
• CREATE SCHMA
• CREATE TRANSLATION
• CREATE VIEW
• CHECK
• GRANT
• DECLARE TIME DISPLACEMENT TABLE
• DROP SCHEMA
• DROP DOMAIN
• DROP TABLE
• DROP VIEW
• DROP ASSERTION
• REVOKE
• DROP COLLATION
• DROP CHARACTER SET
• DROP TRANSLATION
• ALTER DOMAIN
• ALTER TABLE ADD / ALTER TABLE DROP
• ADD DEFAULT
• REPLACE DEFAULT
• DROP DEFAULT
• ADD CHECK
• DROP CONSTRAINT
• DECLARE CURSOR
• OPEN
• FETCH
• CLOSE
• SELECT
• DELETE(CURSOR)
• UPDATE(CURSOR)
• DELETE(WHERE)
• UPDATE(WHERE)
• DECLARE LOCAL TEMPORARY TABLE

Dynamic SQL

• USING
• ALLOCATE DESCRIPTION
• DEALLOCATE DESCRIPTION
• GET DESCRIPTION
• SET DESCRIPTION
• PREPARE
• DEALLOCATE PREPARE
• DESCRIBE
• EXECUTE
• EXECUTE IMMEDIATE
• DECLARE CURSOR(Dynamic)
• ALLOCATE CURSOR
• OPEN(Dynamic)
• FETCH(Dynamic)
• CLOSE(Dynamic)
• DELETE(Dynamic, CURSOR)
• DELETE(Dynamic, WHERE)

TRANSACTION

• CONNECT
• SETCONNECTION
• DISCONNECT

単語のみ

• COMMIT
• ROLLBACK
• SET TRANSACTION

概要のみ（例題、図解無し）

• PRIMARY KEY
• FOREIGN KEY
• UNIQUE
• NOT NULL

たぶん書き終わり

• CREATE TABLE
• INSERT