๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ

DB ๊ธฐ๋ณธ1

[ORACLE] SELECT ๋ช…๋ น์–ด ๊ธฐ๋ณธ ์‚ฌ์šฉ :: ๋งˆ์ด์ž๋ชฝ ORACLE SELECT ๋ช…๋ น์–ด ๊ธฐ๋ณธ ์‚ฌ์šฉSQL Query๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์—์„œ ํ™•์ธํ•˜๊ณ  ์‹ถ์€ ๋ฐ์ดํ„ฐ๋ฅผ ์›ํ•˜๋Š” ํ˜•ํƒœ๋กœ ๋ณด๊ธฐ์œ„ํ•ด์„œ๋Š” SELECT ๋ช…๋ น์–ด๋ฅผ ์•Œ์•„์•ผํ•œ๋‹ค. SELECT ๋ช…๋ น์–ด๋Š” CRUD์—์„œ 'R'์— ํ•ด๋‹นํ•˜๋Š” READ๋ถ€๋ถ„์œผ๋กœ ๋ฐ์ดํ„ฐ๋ฅผ ์ฝ์„๋•Œ ์‚ฌ์šฉํ•˜๋ฉด ๋œ๋‹ค. ํ•ด๋‹น๊ธ€์—์„œ๋Š” Oracle 11g ๋ฒ„์ „์„ ์‚ฌ์šฉํ•˜๊ณ  HR๊ณ„์ •์˜ ๊ธฐ๋ณธ ํ…Œ์ด๋ธ”์„ ์‚ฌ์šฉํ•˜์—ฌ ์‹ค์Šตํ–ˆ์Šต๋‹ˆ๋‹ค. TABTAB์„ ์กฐํšŒํ•˜์—ฌ ์ ‘์†ํ•œ ๊ณ„์ •์ด ์†Œ์œ ํ•˜๊ณ  ์žˆ๋Š” ํ…Œ์ด๋ธ”์„ ํ™•์ธํ•  ์ˆ˜ ์žˆ๋‹ค. QUERY1SELECT * FROM TAB;cs RESULT DESCDESC ๋ช…๋ น์„ ์‚ฌ์šฉํ•˜์—ฌ ํ•ด๋‹น ํ…Œ์ด๋ธ”์˜ ์ •๋ณด๋ฅผ ์†์„ฑ ๋ฐ ํƒ€์ž…์„ ๊ฐ„๋žตํ•˜๊ฒŒ ํ™•์ธํ•  ์ˆ˜ ์žˆ๋‹ค. ๋ช…๋ น : DESC [ํ…Œ์ด๋ธ”]; QUERYEMPLOYEES ํ…Œ์ด๋ธ”์˜ ์ •๋ณด๋ฅผ ํ™•์ธํ•œ๋‹ค.1DESC EMPLOYEES.. 2019. 9. 8.