CREATE TABLE users (user_key NUMBER, user_login VARCHAR2(100))Table created.
CREATE TABLE dept (dept_id NUMBER, dept_name VARCHAR2(100), user_key NUMBER)Table created.
INSERT INTO users VALUES (1, 'User1')1 row(s) inserted.
INSERT INTO users VALUES (2, 'User2')1 row(s) inserted.
INSERT INTO dept VALUES (1, 'Physics',1)1 row(s) inserted.
INSERT INTO dept VALUES (2, 'Maths',1)1 row(s) inserted.
INSERT INTO dept VALUES (3, 'Physics',2)1 row(s) inserted.
INSERT INTO dept VALUES (4, 'Maths',2)1 row(s) inserted.
COMMITStatement processed.
SELECT user_login, dept_id, dept_name
FROM users, dept
WHERE users.user_key=dept.user_key| USER_LOGIN | DEPT_ID | DEPT_NAME | User1 | 1 | Physics | User1 | 2 | Maths | User2 | 3 | Physics | User2 | 4 | Maths |
|---|