Eine Einführung in

SQL

DROP TABLE anyoldtable;
CREATE TABLE anyoldtable (i INTEGER);
INSERT INTO anyoldtable VALUES (1);

SELECT user FROM anyoldtable

DROP TABLE anyoldtable;
CREATE TABLE anyoldtable (i INTEGER);
INSERT INTO anyoldtable VALUES (1);

SELECT user FROM anyoldtable

DROP TABLE anyoldtable;
CREATE TABLE anyoldtable (i INTEGER);
INSERT INTO anyoldtable VALUES (1);

SELECT user FROM anyoldtable

DROP TABLE anyoldtable;
CREATE TABLE anyoldtable (i INTEGER);
INSERT INTO anyoldtable VALUES (1);

select user

SELECT user, uid FROM dual

USE scott; SELECT user, user_id(); USE gisq; SELECT user, user_id()

SELECT user()

USE scott; SELECT user, user_id(); USE gisq; SELECT user, user_id()

DROP TABLE anyoldtable;
CREATE TABLE anyoldtable (i INTEGER);
INSERT INTO anyoldtable VALUES (1);

SELECT user FROM anyoldtable