DB/ORACLE

[ORACLE] global temporary table (์ „์—ญ ์ž„์‹œ ํ…Œ์ด๋ธ”)

๋ฐฐ๊ณ ํŒŒ์š” 2023. 8. 29. 19:35
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