[ 자격증/SQLD ]
SQLD 2과목 필기
2024-03-04 21:47:52
CREATE TABLE test1 ( id NUMBER NOT NULL, name VARCHAR2(100) NOT NULL, gender VARCHAR2(10) NULL, age NUMBER NULL, nowdate DATE NULL, etc VARCHAR2(300) NULL, PRIMARY KEY (id) ); SELECT * FROM TEST1 t ; INSERT INTO test1 (id, name, gender, age, nowdate) VALUES (1, '조성호', '남자', 28, '2018-01-01'); INSERT INTO test1 (id, name, gender, age, nowdate) VALUES (2, '전예진', '여자', 25, '2018-01-01'); INSERT INT..