Longlee database top menu
Login
id   pw     |        
Database °­Á ¸ñ·Ï
 
longlee.net ˼
µ¥ÀÌÅͺ£À̽º Áß½ÉÀÇ
IT°ü·Ã Àü¹® °­Á ½ÎÀÌÆ®ÀÔ´Ï´Ù.

ȸ¿ø°¡ÀÔÀ» ÇϽøé
´Ù¾çÇÑ ¹«·á °­ÁÂÄÁÅÙÃ÷¸¦
°æÇèÇϽǼö ÀÖ½À´Ï´Ù
<< ¹«·áȸ¿ø°¡ÀÔ >>

longlee.net ˼
ȸ¿ø ¿©·¯ºÐµé²²¼­
¿î¿µÇØ°¡´Â ½ÎÀÌÆ®ÀÔ´Ï´Ù.
  Since 2005/03/01


Oracle
  JOIN (INNER / CROSS / OUTER )
  °èÃþÇü Äõ¸®(Hirearchical Query)
  Grouping Sets °­Á°¡ µî·ÏµÇ¾ú½À´Ï´Ù
  ROLLUP °ú CUBE °­Á°¡ µî·ÏµÇ¾ú½À´Ï´Ù
  Group by ¿Í Having °­Á°¡ µî·ÏµÇ¾ú½À´Ï´Ù
  ¿À¶óŬ ±×·ì ÇÔ¼ö °­Á°¡ ¾÷µ¥ÀÌÆ® µÇ¾ú½À´Ï´Ù
  Decode ¿Í Case ¹® °­Á°¡ ¾÷µ¥ÀÌÆ® µÇ¾ú½À´Ï´Ù
  ¿À¶óŬ º¯È¯ÇÔ¼ö °­Á°¡ ¾÷µ¥ÀÌÆ® µÇ¾ú½À´Ï´Ù
¼³¹®Á¶»ç

´ç½ÅÀÇ µ¥ÀÌŸº£À̽º ¼öÁØÀº?
ÃæºÐÈ÷ ¾Ë°íÀÖÀ¸¸ç ÁÖº¯¿¡ µµ¿òÀ» ÁÖ°íÀÖ´Ù
Tuning/ModelingÀÇ ±íÀÌÀÖ´Â ÀÌÇØ ÇÊ¿ä
DB¸¦ ¾î´ÀÁ¤µµ ÀÌÇØÇÏ°í ¾÷¹«¿¡ È°¿ë
±âº» SQL Á¤µµ¸¸ ÀÌÇØÇÏ°íÀÖ´Ù
óÀ½ Á¢ÇØ °øºÎÇغ¸°í ½Í´Ù
 
  Student Studnet 30.88%
  Programmer Programmer 38.75%
  SE SE 6.54%
  DBA DBA 5.14%
  PM PM 2.94%
  CEO CEO 0.66%
  ºñÀü¹®°¡ ºñÀü¹®°¡ 15.07%
³² ¿©
Ñû (80.36%) åü (19.63%)
ÁغñÁßÀÔ´Ï´Ù ÁغñÁßÀÔ´Ï´Ù ÁغñÁßÀÔ´Ï´Ù
CopyRight Longlee.net
    www.longlee.net
    © 2005 longlee.net all rights reserved.
°æ±âµµ ¼º³²½Ã ºÐ´ç±¸       °³ÀÎÁ¤º¸ º¸È£ Ã¥ÀÓÀÚ @Longlee
°³Àΰ­Á ½ÎÀÌÆ®       Email :LONGLEE