DML sql
2022. 3. 13.
- INSERT 삽입 INSERT INTO 테이블 명(해당 컬럼) VALUES (값 목록) ex) INSERT INTO MEMBER(ID, PWD) VALUES('purple', '111'); - SELECT 조회 SELECT * FROM MEMBER; -- 테이블 생성 CREATE TABLE MEMBER_ROLE ( MEMBER_ID NVARCHAR2(50), ROLE_ID VARCHAR2(50) ); -- 값 삽입 INSERT INTO MEMBER(ID, PWD) VALUES('purple', '111'); INSERT INTO MEMBER(ID, PWD) VALUES('dragon', '111'); -- 조회 SELECT id as "user id", pwd FROM member; -- as를 생략..