-
SELECT - 단일테이블 <read> . feat:늦공김부장DB/Oracle(DB) 2023. 7. 6. 15:27
- 명령어
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;'DB > Oracle(DB)' 카테고리의 다른 글
SELECT Subquery (0) 2023.07.07 SELECT - Table join , subquery?(알아보기) (0) 2023.07.07 INSERT<creat> (0) 2023.07.06 connection & table 생성 <creat> (0) 2023.07.06 user 생성<creat> (0) 2023.07.06