(ÁÖ)Æ÷¿ÍÀÎµå ½Ã½ºÅÛ Forewind System -Ä¿¹Â´ÏƼ
·Î°í
¸ÞÀÎ À̹ÌÁö

ÀÚÀ¯°Ô½ÃÆÇ
Áú¹®°ú´äº¯
ÀÚ·á½Ç

°øÁö»çÇ×

¹è³Ê
HOME > Ä¿¹Â´ÏƼ > °øÁö»çÇ×

·Î±×ÀÎ
Á¦¸ñ
  [°øÁö] ³âµµº¯°æ°ü·Ã Ãß°¡ÀÛ¾÷ ÇÊ¿äÇÕ´Ï´Ù.
À̸§
  ±¸Á¤¸ð  ÀÛ¼ºÀÏ : 2009-01-01 08:58:53  Á¶È¸ : 7862 

³âµµº¯°æ ÀÛ¾÷°ü·Ã Ãß°¡°øÁö µå¸³´Ï´Ù.

´Ù½Ã È®ÀÎµÈ »çÇ×ÀÔ´Ï´Ù. ¾Æ·¡ÀÇ ÀÛ¾÷À» ¹Ýµå½Ã Ãß°¡ ó¸® ºÎʵ右´Ï´Ù..

¹é¾÷Àº ÇʼöÀÔ´Ï´Ù!!! ¹Ýµå½Ã ¹é¾÷¹Þ°í ÀÛ¾÷Çϼ¼¿ä~  

¾÷¹«¿¡ ºÒÆíÀ» µå·Á¼­ Á˼ÛÇÕ´Ï´Ù.

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³â¿¡ º¸ÀÌ¸é µû·Î Á¤¸®ÇÏ¿© ¾Ë·ÁÁֽñ⠹ٶø´Ï´Ù.




[°øÁö] 2009³â »ý»êÇöȲº¸°í ÁøÇà°ü·Ã
[°øÁö] 2008³â ÇϰèÈÞ°¡ °ü·Ã


Copyright 1999-2021 Zeroboard / skin by ko7ko