(Oracle DB) - 16. INSERT

/* INSERT
	#	Basic Format
	#	Omitted-coloumn_name Format
	#	INSERT ~ SELECT Format
*/

	--#	Basic Format
CREATE TABLE ex3_1
(
	col1 VARCHAR2(10),
	col2 NUMBER,
	col3 DATE
);

INSERT INTO ex3_1
	(col1, col2, col3)
	VALUES
	('ABC', 10, SYSDATE)
;

INSERT INTO ex3_1
	(col3, col1, col2)
	VALUES
	(SYSDATE, 'DEF', 20)
;

INSERT INTO ex3_1
	(col1, col2, col3)
	VALUES
	('ABC', 10, 30)	-- ERROR : Value and Data Type is not matched.
;


	--# Omitted-column_name Foramt
INSERT INTO ex3_1
	VALUES
	('GHI', 10, SYSDATE)
;

INSERT INTO ex3_1
	(col1, col2)
	VALUES
	('GHI', 20)
;

INSERT INTO ex3_1
	VALUES
	('GHI', 30)	-- All columns must take data
;


	--# INSERT ~ SELECT Format
CREATE TABLE ex3_2
(
	emp_id NUMBER,
	emp_name VARCHAR2(100)
);

INSERT INTO ex3_2
	(emp_id, emp_name)
	SELECT
		employee_id, emp_name
		FROM employees
	WHERE salary > 5000
;