진수의 시간은 거꾸로 흘러간다. IT 성장 블로그 진수의 시간은 거꾸로 흘러간다. IT 성장 블로그

Microsoft Windows [Version 10.0.19045.3208] (c) Microsoft Corporation. All rights reserved. C:\Users\Parkjinsu>sqlplus system/1111 SQL*Plus: Release 11.2.0.2.0 Production on 화 7월 25 12:13:51 2023 Copyright (c) 1982, 2014, Oracle. All rights reserved. ERROR: ORA-01017: invalid username/password; logon denied Enter user-name: system Enter password: Connected to: Oracle Database 11g Express Edition..

SELECT * from order_list where coffee != '카푸치노' /*카푸치노가 아닌것 출력*/ ; SELECT * from order_list where coffee in('카푸치노','그린티') ; SELECT * from order_list where coffee in('카푸치노','그린티') /*in 조건은 or이라 보면됨 */ /*where coffee not in('카푸치노','그린티') /*in 조건은 or이라 보면됨 */ ; SELECT * from order_list where coffee like '오렌%' /* 오렌이 포함된 것만 출력*/ SELECT * from order_list where coffee not like '카푸%' /*카푸가 아닌것만 출력*/ --..

EX) UPDATE order_list set name='홍길동형2', price=3300 WHERE cust_id='ID2' ; select * from order_list where cust_id = 'ID2' -=

SELECT ol.*, ci.email, ci.reg_day, cm.kind /*종류 선정 */ from order_list ol, cust_info ci, coffee_menu cm /*테이블 가져오기*/ WHERE ol.cust_id = ci.cust_id and ol.coffee_no=cm.no --and cm.kind='커피' ;

- 명령어 SELECT coffee, kind, to_char(price) FROM coffee_menu -- where kind = '커피' WHERE kind IN ('커피', '에이드') -- where coffee ='카푸치노 ORDER BY coffee DESC; select to_char(reg_day,'yyyy.mm.dd hh24:mm:ss') from cust_info;

/*INSERT INTO table_name(column name, column name) values ( )*/ INSERT INTO coffee_menu (coffee, kind, price) VALUES ('아메리카노','커피',2000); INSERT INTO coffee_menu (coffee, kind, price) VALUES ('카페라떼','커피',3000); INSERT INTO coffee_menu (coffee, kind, price) VALUES ('카푸치노','커피',3000); INSERT INTO coffee_menu (coffee, kind, price) VALUES ('그린티','논커피',3500); INSERT INTO coffee_menu (coffee, kind, pr..

CREATE TABLE coffee_menu ( no number GENERATED AS IDENTITY , coffee VARCHAR2(100) NOT NULL , /*VARCHAR2는 가변 길이를 의미(일반적으로 많이 씀)*/ kind VARCHAR2(100) NOT NULL , price number(11) DEFAULT 0 NOT NULL, /* 숫자타입 number */ reg_day date DEFAULT sysdate NOT NULL , /* 날짜타입 date */ mod_day date DEFAULT sysdate NOT NULL , CONSTRAINT pk_coffee_menu PRIMARY KEY(no) ) ; COMMENT ON TABLE coffee_menu IS '커피/음료 메뉴'..