³âµµº¯°æ ÀÛ¾÷°ü·Ã Ãß°¡°øÁö µå¸³´Ï´Ù.
´Ù½Ã È®ÀÎµÈ »çÇ×ÀÔ´Ï´Ù. ¾Æ·¡ÀÇ ÀÛ¾÷À» ¹Ýµå½Ã Ãß°¡ ó¸® ºÎʵ右´Ï´Ù..
¹é¾÷Àº ÇʼöÀÔ´Ï´Ù!!! ¹Ýµå½Ã ¹é¾÷¹Þ°í ÀÛ¾÷Çϼ¼¿ä~
¾÷¹«¿¡ ºÒÆíÀ» µå·Á¼ Á˼ÛÇÕ´Ï´Ù.
exp db°èÁ¤/db¾ÏÈ£ file=2009_cabinet.dmp tables=folder,apprfolder compress=n buffer=1024000
1. 2008³â ÀÌÀü ±â·Ï¹°Ã¶ÀÌ 2009³â¿¡ ´Ù½Ã º¸ÀÌ´Â ¹®Á¦
sql> update apprfolder set endyear='2008' where prodyear='2008' and fldrid in (select fldrid from folder where applid=7010);
sql> update folder set year='2008' where substr(fldrid,7,1)='8' and applid='7010' and fldrid in
(select fldrid from apprfolder where prodyear='2008' and endyear='2008');
sql> commit;
2. 3202¿¡·¯ ¹ß»ý
- folder°¡ Á¦´ë·Î »ý¼ºµÇÁö ¾Ê¾Æ¼ ¹ß»ýÇÑ °ÍÀ¸·Î ¹ß°ßµÇ¸é ¾Ë·ÁÁֽñ⠹ٶø´Ï´Ù.
3. ±ÇÈ£¼ö Ãß°¡µÈ ±â·Ï¹°Ã¶ÀÌ 2009³â¿¡ º¸ÀÌ¸é µû·Î Á¤¸®ÇÏ¿© ¾Ë·ÁÁֽñ⠹ٶø´Ï´Ù.
|
|