728x90
CREATE GLOBAL TEMPORARY TABLE TB_TEMP
(
ID VARCHAR2 (4),
NAME VARCHAR2 (20)
)
ON COMMIT DELETE ROWS
๐ ?
- ใ ใ
์ถ์ฒ :
http://www.gurubee.net/article/82439
https://m.blog.naver.com/regenesis90/222198156918
https://jhnyang.tistory.com/505
http://www.gurubee.net/article/80251
https://goddaehee.tistory.com/165
https://recollectionis.tistory.com/157
http://soen.kr/book/sql/book/12-2.htm
https://solbel.tistory.com/861
๊ฐ๋ฐ ๊ณต๋ถ๋ฅผ ์ํ ๋ธ๋ก๊ทธ ์ ๋๋ค.
์ค๋ฅ๊ฐ ์๋ค๋ฉด ๋๊ธ๋ก ์๋ ค์ฃผ์ธ์!
๊ฐ์ฌํฉ๋๋ค.

728x90
'DB > ORACLE' ์นดํ ๊ณ ๋ฆฌ์ ๋ค๋ฅธ ๊ธ
[ORACLE] ํ๋ก์์ ์์ ํ ์ด๋ธ๋ช ๋ณ์ ์ฒ๋ฆฌํ๊ธฐ. (0) | 2023.09.14 |
---|---|
[ORACLE] ์ผํ(,)๋ก ๋์ด ์๋ ๊ฐ์ ์ด๋ก ๋ฐ๊พธ๊ธฐ (0) | 2023.09.14 |
[์ค๋ผํด] db link (0) | 2023.08.21 |
[ORACLE] INSERT ALL (:: ์ฌ๋ฌ๊ฐ์ INSERT๋ฅผ ํ๋ฒ์ ์ฒ๋ฆฌ.) (0) | 2023.07.18 |
[ORACLE] ์ฃผ๋ง๊ณผ ๊ณตํด์ผ ๋ ์ง๋ง ๊ตฌํ๊ธฐ(CONNECT BY LEVEL) - 2 (0) | 2023.06.14 |