Übersicht der Befehle (sqlite, MySQL, Postgres, Oracle)

Befehl Sqlite MySql Postgres Oracle
select current_database();     x  
SELECT DATABASE();   x    
TABLE …        
ALTER TABLE … x x x x
CREATE TABLE (SQLite) x x x x
x x x x
CREATE TABLE (Constraints/Postgres)     x  
DECLARE LOCAL TEMPORARY TABLE        
DROP TABLE        
DISTINCT x x x x
SELECT x x x x
INSERT … x x x x
UPDATE … x x x x
T1 LEFT JOIN T2 on … x x x x
T1 RIGHT JOIN T2 on …   x x x
T1 FULL JOIN T2 on …   x x x
T1 as t1 SELF JOIN T1 as t2 on …   x x x
ADD        
ALLOCATE CURSOR        
ALTER DOMAIN        
ALTER ROUTINE        
ALTER SEQUENCE        
GENERATOR        
AETER TRANSFORM        
ALTER TYPE        
CALL        
CLOSE        
COMMIT        
CONNECT        
CREATE        
CREATE ASSERTION        
CREATE CAST        
CREATE CHARACTER SET        
CREATE COLLATION        
CREATE DATABASE (Postgres)
  x  
CREATE DOMAIN        
CREATE FUNCTION        
CREATE INDEX (Constraints/Postgres) x x x x
CREATE METHOD        
CREATE ORDERING        
CREATE PROCEDURE        
CREATE ROLE        
CREATE SCHEMA        
CREATE SEQUENCE        
CREATE TRANSFORM        
CREATE TRIGGER        
CREATE TYPE        
CREATE VIEW        
DEALLOCATE DESCRIPTOR        
DEALOCATE PREPARE        
DECLARE        
DELETE        
DESCRIBE INPUT        
DESCRIBE OUTPUT        
DISCONNECT        
DROP        
DROP ASSERTATION        
DROP ATTRIBUTE        
DROP CAST        
DROP CHARACTER SET        
DROP COLLATION        
DROP COLUMN        
DROP CONSTRAINT        
DROP DEFAULT        
DROP DOMAIN        
DROP METHOD        
DROP ORDERING        
DROP ROLE        
DROP ROUTINE        
DROP SCHEMA        
DROP SCOPE        
DROP SEQUENCE        
DROP TRANSFORM        
DROP TRANSLATIONION        
DROP TRIGGER        
DROP TYPE        
DROP VIEW        
EXECUTE IMMEDIATE        
FETCH        
FREE LOCATOR        
GET DESCRIPTOR        
GET DIAGNOSTICS        
GRANT PRIVILEGE        
GRAN ROLE        
HOLD LOCATOR        
INSERT        
MERGE        
OPEN        
REPLACE        
RELEASE SAVEPOINT        
RETURN        
REVOKE        
ROLLBACK        
SAVEPOINT        
SELECT        
SET CATALOG        
SET CONNECTION        
SET CONSTRAINTS        
SET DESCRIPTOR        
SET NAMES        
SET PATH        
SET SCHEMA        
SET SESSION AUTHORIZATION        
SET SESSION CHARACTERISTICS        
SET SESSION COLLATION        
seT TIME ZONE        
SET TRANSACTION        
SET TRANSFORM GROUP        
START TRANSACTION        
UPDATE