Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : Oracle

ÓÃÁ¬½Ó³ØÁ¬½Óoracle³ö´í,°ïæ¿´¿´

Êý¾Ý¿âÊÇ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 ......

Oracle Database 11g(11.2.0.1.0)µÚ2°æ

¿ÉÒÔÔÚ£ºxp¡¢windows2008ϰ²×°Âð£¿
Èô¿ÉÒÔ£¬ÔÚÄÇÀïÓÐÏÂÔØ£¿
лÁË
http://www.oracle.com/technology/software/products/database/index.html

ÔÝδÌṩwindowsƽ̨°æ±¾¡£

ÎÞÏÞ¾«²Ê£¬ÖµµÃÆÚ´ý£¡

×°LINUX
ԽѧԽӦ¸ÃѧϰLINUX»òÕßUNIXϲÙ×÷

windowsƽ̨,ÊÇ·ñÒÔºó£¬ÓпÉÒÔÌṩ£¿
LINUX¶¼Ã»Ó ......

pb9連½Óoracle數據庫

ÎÒµÄpb9連設ÖÃÍê連½Ó參數£¬connect using sqlca£»
²é¿´sqlca.sqlcode發現時為0µÄ£¬µ«ÊÇǶÈëʽµÄsql¾ÍÊÇ執Ðв»ÁË£¬
string ls
select material_id into :ls from  material_info where rownum =1 ;
²é¿´ls¾¹È»為¿Õ£¬sqlca.sqlcode $ ......

oracle²»×ßË÷ÒýµÄÎÊÌâ¡£ÔÚÏߵȡ£¼±£¡£¡£¡£¡

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) & ......

Oracle 8.1.6 ÈçºÎ²éÕÒ×Ö·û´®ÖÐÊÇ·ñº¬ÓÐСд×Öĸ£¿

ÓÐûÓа취ͨ¹ýÒ»Ìõ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£¬ÎÒ×°µÄÊÇoracle 10g£¬µ«ÔÚ±¾±¾ÉÏÌ«³ÔÄÚ´æÁË£¬ÏëÆ½Ê±¹Ø±ÕûÓõķþÎñÏî

ÓõÄʱºòÔÙ°ÑËüÃÇ´ò¿ª£¬µ«³õѧ£¬²»¸ÒËæ±ã¹Ø±Õ£¬ËùÒÔÔÚÕâÀïÎÊϸ÷λ£¬Ò»Ï½ø³Ì¶¼ÊÇ×öʲôÓõģ¿

×îºÃÄÜÏêϸµã½â´ð£¬Ð»Ð»ÁË~

OracleDBConsoleorcl

OracleJobSchedulerORCL

OracleOraDb10g_home1iSQL*Plus ......
×ܼǼÊý:1827; ×ÜÒ³Êý:305; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [112] [113] [114] [115] 116 [117] [118] [119] [120] [121]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ