Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

´«ÖDz¥¿Íjavaѧϰ sql³£Óú¯Êý

ÎÒ½ñÌìѧϰÁËsqlÓï¾äµÄ³£Óú¯Êý£¬ÊÇ·ëÍþÀÏʦ½²µÄ£¬ÎÒ×öÁ˼òµ¥µÄ±Ê¼Ç£º
 
Ò»£¬SQLº¯Êý£º
1. ´óСдת»»º¯Êý
   lower ת³ÉСд  
   upper ´óд
   initcap  ½«×Ö·û´®µÄ(ÿ¸öµ¥´ÊµÄ)µÚÒ»¸ö×Öĸ±äΪ´óд,ºóÃæµÄСд
 select initcap('huangHY') from dual
  ½«Ê××Öĸ±ä³É´óд£¬ÆäÓàµÄ±ä³ÉСд
 
2. ×Ö·û´¦Àíº¯Êý
   concat  Á¬½ÓÁ½¸ö×Ö·û´®
   select concat(first_name,last_name) from employees
    substr  ·µ»Ø×Ó×Ö·û´®
     select substr('huangu',2,3) from dual
    length ·µ»Ø×Ö·û´®³¤¶È
    select length('huangyu') from dual
    instr(c1,c2,i,j)   ×Ó´®µÄλÖÃ
    select instr('huangyu','yu',2,3) from dual
    lpad  ²¹³ä
    lpad('husangyu',10,'*') from dual
    rpad
    trim ,½ØÈ¡Á½¶ËµÄ¿Õ¸ñ
     select trim('huangyu') from dual
    replace('wewwew','e','huangyu') Ìæ»»º¯Êý
3.Êýѧº¯Êý
   round(num1,2)   °´Ö¸¶¨µÄСÊýλÊý½øÐÐËÄÉáÎåÈë,δָ¶¨ÔòĬÈÏΪ0
   select round(333.353,2)    333.35
  
   mod(num1,num2) Á½ÊýÏë³ý
4.ÈÕÆÚº¯Êý
   months_between()   ¼ÆËãÁ½¸öÈÕÆÚÏà²î¶àÉÙÔ£¿
   add_months(sysdate,10)¼ÓÊ®¸öÔÂ
   next_day(date,'ÐÇÆÚÎå')
   last_day(syadete) ,¼ÆËãÖ¸¶¨ÈÕÆÚµÄ×îºóÒ»Ìì 
   trunc(date)
   round(date,'YY') ±¾ÄêµÄµÚÒ»Ìì
   round(date,'DD')µ±Ç°ÈÕÆÚ
   round(date,'mm') ±¾ÔµÚÒ»Ìì
   round(date,'dy') ±¾ÖܵÚÒ»Ìì(ÐÇÆÚËĽøλ)
   
5.ת»»º¯Êý
  ÏÔʾµÄÊý¾ÝÀàÐÍת»»£º
  to_char(date,'fmt')
  to_char(sysdate,'yy-mm-dd')
  Êä³öÈÕÆÚµÄ×Ö·û´®±íʾ¸ñʽ£»
 
6.ÐÞ¸ÄΪÖÐÎÄÓïÑÔ»·¾³
   alter session set nls_language='SIMPLIFIED CHINESE'
  
7£¬ ÈÕÆÚµÄÓ


Ïà¹ØÎĵµ£º

º½¿Õ¹«Ë¾¹ÜÀíϵͳ(VC++ ÓëSQL 2005)

ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
      ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃ棬ºóÃæ ......

ÄÚ´æ¼àÊÓ Java Ô´´úÂë

/*
 * @(#)MemoryMonitor.java 1.3 05/11/17
 *
 * Copyright (c) 2006 Sun Microsystems, Inc. All Rights Reserved.
 *
 * Redistribution and use in source and binary forms, with or without
 * modification, are permitted provided that the following conditions are ......

Ubuntu Install Java JDK and JRE

Ubuntu Linux Install Sun Java Development Kit ( JDK ) and Java Runtime Environment ( JRE )
by Vivek Gite
 
Q.
How do I install Sun
Java Development Kit (JDK) and Java Runtime Environment (JRE) under
Ubuntu Linux? It appears that there are multiple JRE installed by
default under Ubuntu. ......

SQL ServerÊÂÎñÈÕÖ¾½éÉÜ

SQL ServerÖеÄÊý¾Ý¿â¶¼ÊÇÓÉÒ»»ò¶à¸öÊý¾ÝÎļþÒÔ¼°Ò»»ò¶à¸öÊÂÎñÈÕÖ¾Îļþ×é³ÉµÄ¡£
¹ËÃû˼Ò⣬Êý¾ÝÎļþÖ÷Òª´æ´¢Êý¾Ý¿âµÄÊý¾Ý£¬°üÀ¨Êý¾Ý¿âÄÚÈݽṹ£¬Êý¾ÝÒ³£¬Ë÷ÒýÒ³µÈµÈ¡£ÄÇôÊÂÎñÈÕÖ¾µ½µ×ÊǸÉʲôµÄÄØ£¿ËüÖ÷ÒªÊÇÓÃÀ´±£´æÊý¾Ý¿âÐ޸ļǼµÄ£¬ÈçÏÂͼ£º
SQL ServerµÄ¹¤×÷Ô­ÀíΪʲôÕâÑùÄØ£¿ÎªÊ²Ã´²»°ÑÊý¾ÝÁ¢¿ÌдÈëÊý¾ÝÎļþÄØ£¿Ô­ ......

´«ÖDz¥¿Íjavaѧϰ sql¼òµ¥²éѯÓï¾ä

½ñÌìÎÒѧϰÁËsqlµÄ¼òµ¥²éѯÓï¾ä£¬
 
һЩ»ù±¾µÄ¸ÅÄ
1                  ϵͳȨÏÞ£ºÊý¾Ý¿âÖеĶÔÏó£¬ ±í£¬´´½¨±í£¬É¾³ý±í
2           ¶ÔÏóȨÏÞ£º¶ÔÊý¾ÝµÄÔö¡¢É¾¡¢¸Ä¡¢²é¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ