Êý¾Ý¿âÊÇoracle10g_home2, lib°üÊÇojdbc14.jar,
tomcatµÄconf/context.xml
XML code:
<Context>
<Resource name="jdbc/oracleds" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30"
maxWait=&q ......
¿ÉÒÔÔÚ£ºxp¡¢windows2008ϰ²×°Âð£¿
Èô¿ÉÒÔ£¬ÔÚÄÇÀïÓÐÏÂÔØ£¿
лÁË
http://www.oracle.com/technology/software/products/database/index.html
ÔÝδÌṩwindowsƽ̨°æ±¾¡£
ÎÞÏÞ¾«²Ê£¬ÖµµÃÆÚ´ý£¡
×°LINUX
ԽѧԽӦ¸ÃѧϰLINUX»òÕßUNIXϲÙ×÷
windowsƽ̨,ÊÇ·ñÒÔºó£¬ÓпÉÒÔÌṩ£¿
LINUX¶¼Ã»Ó ......
ÎÒµÄpb9連設ÖÃÍê連½Ó參數£¬connect using sqlca£»
²é¿´sqlca.sqlcode發現時為0µÄ£¬µ«ÊÇǶÈëʽµÄsql¾ÍÊÇ執Ðв»ÁË£¬
string ls
select material_id into :ls from material_info where rownum =1 ;
²é¿´ls¾¹È»為¿Õ£¬sqlca.sqlcode $ ......
select /*+index_ffs(tn codeË÷ÒýÃû)*/
count(1)
from t_tablename tn
where tn.code like dep.depcode || '%'
and round(to_number(tn.date1-tn.date2)* 1440) & ......
ÓÐûÓа취ͨ¹ýÒ»ÌõSQL²éÕÒ³ö°üº¬Ð¡Ð´×ÖĸµÄ¼Ç¼¡£¡£ ÇëÖ¸½Ì£¡~
select * from table1 where name like ¡®%[a-z]%¡¯;
ÒýÓÃ
816
SELECT * from table_name
WHERE colname LIKE '%chr(97)%' OR colname LIKE '%chr(98)%' OR ... OR colname LIKE '%chr(122)%';
......
³õѧoracle£¬ÎÒ×°µÄÊÇoracle 10g£¬µ«ÔÚ±¾±¾ÉÏÌ«³ÔÄÚ´æÁË£¬ÏëÆ½Ê±¹Ø±ÕûÓõķþÎñÏî
ÓõÄʱºòÔÙ°ÑËüÃÇ´ò¿ª£¬µ«³õѧ£¬²»¸ÒËæ±ã¹Ø±Õ£¬ËùÒÔÔÚÕâÀïÎÊϸ÷λ£¬Ò»Ï½ø³Ì¶¼ÊÇ×öʲôÓõģ¿
×îºÃÄÜÏêϸµã½â´ð£¬Ð»Ð»ÁË~
OracleDBConsoleorcl
OracleJobSchedulerORCL
OracleOraDb10g_home1iSQL*Plus ......