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

JDBCÁ¬½ÓoracleÊý¾Ý¿âÎÊÌâ

Java code:
import java.sql.*;


class xt{

public static void main(String in[]){


try{
Class.forName("oracle.jdbc.driver.OracleDriver");
}catch(ClassNotFoundException cnfe){
System.out.println("can not found!");
}

try{
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@192.168.5.160:1521:orcl","system","manager");

Statement stat=con.createStatement();

//ResultSet res=stat.executeQuery("select * from students;"); //#

//res.next();
//System.out.println(res.getString(1));

}catch(SQLException sqle){
System.out.println("sql error");
}

}
}



ÒÔÉÏ´úÂëÖ´ÐÐ䱨ÈκÎÒì³£.
µ«Ö»ÒªÖ´ÐÐ×¢ÊÍΪ#µÄÄǾä,¾Í»á´òÓ¡"sql error",

Õâô¿´À´,Á¬½ÓÃ²ËÆÃ»ÎÊÌâ,ΪºÎÒ»Ö´ÐÐsqlÓï¾ä¾Í±¨´íÄØ?

Çë¸÷λ°ïæ¿´¿´,лл!

Java code:

¿´´úÂëûʲô´í°É. Êý¾Ý¿â·þÎñÆô¶¯ÁËô?±í´æÔÚô? ǰºóSystem´òÓ¡Ï¿´¿´ ÄľäÈÓµÄÒì³£.



Java code
{{--


Ïà¹ØÎÊ´ð£º

php Öвéѯoracle date ÀàÐÍÊý¾ÝµÄÎÊÌâ?

ÈÕǰÓÃociº¯Êý²éѯoracleÊý¾Ýʱ³öÏÖ¸öÎÊÌ⣬¾ÍÊÇÔÚ²éѯµ½dateÀàÐ͵ÄÊý¾Ýʱ£¬Ê¹ÓÃpl/sql ²éѯoracle¿âÖеÄÊý¾ÝÏÔʾÊÇ
2009-9-29 12:12:12
µ«ÊÇͨ¹ýÓï¾äselect * from tablename ²éѯ£¬Ê¹ÓÃoci_fetch_array£¨£© ......

delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î

delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î

http://blog.csdn.net/zxf_feng/archive/2008/12/21/3571961.aspx
¿´¿´Õâ¸ö

ÒýÓÃ
            vStream := TMemorySt ......

ÇóʹÓÃt-sqlÓï¾ä½«paradoxÊý¾Ýµ¼ÈëoracleµÄ°ì·¨

ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......

oracle impdpÎÊÌâ

Êý¾Ý±Ãµ¼È뱨ÈçÏ´íÎóORA-39016 ²»ÖªµÀÊÇʲôԭÒò,ÇëÖ¸½Ì....  лл'


Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-39016: Operation not supported when job is in EXECUTING ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ