[SQL] Python을 이용한 Oracle DB 접근
[SQL] --1번. TABLE 생성하기 CREATE TABLE EXAM_TABLE( ID VARCHAR(50) PRIMARY KEY, PASS VARCHAR(30) NOT NULL, NAME VARCHAR(25) NOT NULL, SCORE NUMBER(3) ); INSERT INTO EXAM_TABLE VALUES('1001', '1234', 'Kim', 90); INSERT INTO EXAM_TABLE VALUES('1002', '3456', 'Lee', 100); INSERT INTO EXAM_TABLE VALUES('1003', '5678', 'Park', 85); INSERT INTO EXAM_TABLE VALUES('1004', '7890', 'Choi', 75); SELECT * FROM ..
SQL/연습문제 풀이
2023. 1. 17.
