´«Ö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£¬ ÈÕÆÚµÄÓ
Ïà¹ØÎĵµ£º
ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃ棬ºóÃæ ......
/*
* @(#)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 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µÄ¼òµ¥²éѯÓï¾ä£¬
һЩ»ù±¾µÄ¸ÅÄ
1 ϵͳȨÏÞ£ºÊý¾Ý¿âÖеĶÔÏó£¬ ±í£¬´´½¨±í£¬É¾³ý±í
2 ¶ÔÏóȨÏÞ£º¶ÔÊý¾ÝµÄÔö¡¢É¾¡¢¸Ä¡¢²é¡ ......