기초 SELECT문

INSERT INTO

SELECT 테이블

SELECT age-1, salary*12 FROM banana;

SELECT name,name, salary,salary*12,age,age*12 FROM banana;

SELECT name as 이름,age as 나이, salary*12 as 연봉 FROM banana;

Drop table banana;

purge recyclebin;

Create TABLE banana(

  name varchar(20), --필드

  age number,

  salary number,

  home varchar(10)

);

SELECT * FROM tab;

INSERT into apple values('홍길동',23,300,'부산');

INSERT into apple values('윤은솔',24,1000,'김해');

INSERT into apple values('김현민',25,1000,'서울');

INSERT into apple values('정우현',25,1000,'부산');

INSERT into apple values('호랑이',21,500,'대구');    

SELECT age-1, salary*12 FROM banana;

SELECT name,name, salary,salary*12,age,age*12 FROM banana;

SELECT name as 이름,age as 나이, salary*12 as 연봉 FROM banana;

SELECT name 이름, age 나이, salary*12 "연봉" FROM banana;

SELECT (name || age)as 호랑이 FROM banana; --필드와 필드열을 합친다

SELECT (name || salary)as 코끼리 FROM banana;

COMMIT;

--SELECT DISTINCT salary FROM banana;-- 중복되지 않은 정보 뽑아내기

SELECT DISTINCT name FROM banana;

COMMIT;