[ DB / Oracle ] 삭제(DELETE)

환경 : DBeaver

 

삭제(DELETE) : 데이터 등을 삭제할 때 사용하는 명령어

 

(참고) 해당 글에서 사용될 데이터베이스 생성 및 데이터 삽입 구문 입니다.

CREATE TABLE vehicle (
  vehicle_id NUMBER PRIMARY KEY,	--차량 고유 숫자
  model_name VARCHAR2(30) NOT NULL,	--차량 모델
  vehicle_type VARCHAR2(15) CHECK(vehicle_type IN ('Sedan', 'SUV', 'Truck', 'Motorcycle')),
  price NUMBER,	--차량 종류
  manufacture_date DATE,	--차량 제조일자
  registration_expire_date DATE	--차량 등록 만료일
);
DROP TABLE vehicle;

INSERT INTO vehicle VALUES(1, 'Toyota Camry', 'Sedan', 25000, '2021-01-15', '2023-01-17');
INSERT INTO vehicle VALUES(2, 'Honda CR-V', 'SUV', 30000, '2020-12-10', '2023-12-10');
INSERT INTO vehicle VALUES(3, 'Ford F-150', 'Truck', 40000, '2020-11-05', '2020-12-05');
INSERT INTO vehicle VALUES(4, 'Harley-Davidson Sportster', 'Motorcycle', 12000, '2022-02-20', '2023-02-20');
INSERT INTO vehicle VALUES(5, 'Tesla Model Y', 'SUV', 50000, '2021-03-30', '2024-03-30');
INSERT INTO vehicle VALUES(6, 'Chevrolet Silverado', 'Truck', 35000, '2020-08-15', '2023-08-15');
INSERT INTO vehicle VALUES(7, 'Yamaha MT-07', 'Motorcycle', 8000, '2021-05-01', '2023-02-01');
INSERT INTO vehicle VALUES(8, 'Nissan Altima', 'Sedan', 23000, '2020-07-10', '2023-07-15');
INSERT INTO vehicle VALUES(9, 'Ducati Panigale V4', 'Motorcycle', 25000, '2022-04-05', '2024-04-05');
INSERT INTO vehicle VALUES(10, 'Jeep Wrangler', 'SUV', 35000, '2020-10-01', '2023-11-30');

---

[ 전체 상품 삭제 ]

DELETE vehicle;
DELETE FROM vehicle;

 

 

[ vehicle_id 가 1인 차량 데이터 삭제 ]

DELETE vehicle WHERE vehicle_id = 1;

 

 

[ SUV, Truck 차량 삭제 ]

DELETE vehicle WHERE vehicle_type = 'SUV' OR vehicle_type = 'Truck';
DELETE vehicle WHERE vehicle_type IN ('SUV', 'Truck');

 

 

[ 2022년도 상반기에 제작된 제품 삭제]

DELETE vehicle WHERE manufacture_date BETWEEN 
	TO_DATE('2022-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS')
	AND 
	TO_DATE('2022-06-30 23:59:59', 'YYYY-MM-DD HH24:MI:SS');

 

 

 

 

 

 

 

개인 공부 기록용입니다:)