Ü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 |
x |
x |
x |
x |
DECLARE LOCAL TEMPORARY TABLE |
||||
DROP TABLE |
||||
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 |
||||
x |
||||
CREATE DOMAIN |
||||
CREATE FUNCTION |
||||
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 |