20201023_21 다양한 함수
모든열 출력 : SELECTTION 일부열 : 프로젝션 DROP TABLE Account; CREATE TABLE Account ( id NUMBER not null, name VARCHAR2(128), email VARCHAR2 (128) , location VARCHAR2 (128) ); INSERT INTO Account(id, name, email, location) VALUES (1, '나나', 'ss@ss', '서울'); INSERT INTO Account(id, name, email, location) VALUES (2, '다다', 'ss@ss', '부산'); INSERT INTO Account(id, name, email, location) VALUES (3, '가가', 'ss@ss', '..
2020. 10. 23.
20201022_20 테이블 만들기, 데이터 삽입, 조인
INSERT INTO student_info (name, phone, email, age, fired) VALUES ('김재현', '01092046805', 'wogus6804@naver.com', 13, 'N'); INSERT INTO 테이블(컬럼1,컬럼2,...) VALUES('값1', '값2',...); SELECT 열1, 열2, ...열N FROM 테이블_이름 SELECT name, phone, email, age, fired FROM student_info; 이거 왜케 오류가 많이 나 으아아앙 DROP DROP TABLE student_info; CREATE TABLE student_info ( name VARCHAR2(128) NOT NULL, phone VARCHAR2(128) NOT NUL..
2020. 10. 22.