egoing님 강의록..

CREATE TABLE topic (
	id NUMBER NOT NULL,
	title VARCHAR2(50) NOT NULL,
	description VARCHAR2(4000),
	created DATE NOT NULL,
	CONSTRAINT PK_TOPIC PRIMARY KEY(id)
);

SELECT * FROM topic
		 OFFSET 1 ROWS
		 FETCH NEXT 2 ROWS ONLY;

INSERT INTO topic
	(id, title, description, created)
	VALUES
	(1, 'ORACLE', 'ORACLE is ...', SYSDATE);
	
INSERT INTO topic
	(id, title, description, created)
	VALUES
	(2, 'MySQL', 'MySQL is ...', SYSDATE);
	
INSERT INTO topic
	(id, title, description, created)
	VALUES
	(3, 'SQL Server', 'SQL Server is ...', SYSDATE);

UPDATE topic
	SET
		title = 'MongoDB',
		description = 'MongoDB is ... '
	WHERE
		id = 4;

---

SELECT 심화

 

SELECT
    T.id TOPIC_ID, 
    title, 
    name
FROM topic T
    LEFT JOIN author A 
    ON T.author_id = A.id
WHERE
    T.id = 1
;