oracleÁ¬½ÓÊý¾Ý¿â²âÊÔ´úÂë
oracleÁ¬½ÓÊý¾Ý¿â²âÊÔ´úÂë
/**
*
* ˵Ã÷£º
* £¨1£©±¾ÀýʹÓÃJDBC_ODBCÇŽøÐÐÊý¾Ý¿âÁ¬½Ó£¬¹Ê´ËÐèÒªODBCÊý¾ÝÔ´
* £¨2£©±¾ÀýÖÐSQLΪ¸üÐÂÓï¾ä£¬¹Ê´ËʹÓÃÔØÌåµÄexecuteUpdate·½·¨£¬²¢ÇÒ·µ»ØÊÜÓ°Ïì¼Ç¼Êý
* (3) ÅäÖÃÁ¬½ÓORACLEµÄodbcÊý¾ÝÔ´ora
*/
//µ¼ÈëËùÐèÀà°ü
import java.sql.*;
public class JdbcTestOra2 {
public static void main(String args[]) {
try {
//×°ÔØÇý¶¯³ÌÐò
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//½¨Á¢Êý¾Ý¿âÁ¬½Ó
Connection con =
DriverManager.getConnection("jdbc:odbc:ora","scott","tiger");
//´´½¨SQLÓï¾äÔØÌå
Statement st = con.createStatement();
//Ö´ÐÐSQLÓï¾ä£¬½ÓÊÕÖ´Ðнá¹û
int rs = st.executeUpdate("update emp set
comm=1000");
//´¦Àí½á¹û
System.out.println("Ð޸ļǼÊý£º"+rs);
//ÊÍ·ÅÊý¾Ý¿â×ÊÔ´£¬×¢Òâ˳Ðò
st.close();
con.close();
}
catch (Exception e) {
e.printStackTrace(System
Ïà¹ØÎĵµ£º
ÐÞ¸Äoracle 10gµÄ×Ö·û¼¯
ÐÞ¸ÄÊý¾Ý¿â×Ö·û¼¯Îª£ºZHS16GBK
Ê×ÏÈÓÃscott&tiger&orclµÇ¼µ½sql/plus
²é¿´·þÎñÆ÷¶Ë×Ö·û¼¯
SQL > select * from
V$NLS_PARAMETERS;
Ð޸ģº
$sqlplus /nolog
SQL>conn / as sysdba
Èô
´ËʱÊý¾Ý¿â·þÎñÆ÷ÒÑÆô¶¯£¬ÔòÏÈÖ´ÐÐ SHUTDOWN IMMEDIATE Ãü
Áî¹Ø±ÕÊý¾Ý¿â·þÎñÆ÷£¬È»ºóÖ´ ......
--ÈçºÎÓÃgrade±íµÄ×ÊÁÏÈ¥¸üÐÂusertable±íµÄ×ÊÁÏ£¨ÓйØÁªµÄ×Ö¶Îuserid£©
update usertable u set u.grade =
(select g.grade from grade g where g.userid = u.userid);
--ÈçºÎʹ²éѯ½á¹û×Ö¶ÎÉú³ÉÐòºÅ
select rownum, t.* from sm_t_pad_new t
--ÈçºÎ¿ìËÙ×öÒ»¸öºÍÔ±íÒ»ÑùµÄ±¸·Ý±í
create ......
The DB File Sequential Read wait event generally indicates a single block read (an index read,
for example). A large number could indicate poor joining orders of tables or unselective indexing.
This number will certainly be large (normally) for a high-transaction, well-tuned system. You ......
ÒòΪºÜÉÙÓõ½, ËùÒÔ¼¸ºõÍü¼ÇÁËÕ⼸¸öº¯Êý, ²»¹ýËüÃÇ»¹ÊǺÜÓÐÓõÄʹÓÃËüÃÇ¿ÉÒÔ´ó´ó¼ò»¯Ò»Ð©SQLÎĵÄÓï·¨, ÖÁÓÚЧÂÊÎÊÌâ, ÈçCCWËù˵ËüÃǺÍEXISTS, IN Ö®ÀàûÓÐʲô²î±ð, ¶øÇÒÒª¾ßÌåÎÊÌâ¾ßÌå·ÖÎö
ÆäÖÐANYºÍSOMEÔÚÒâ˼ÉÏÊÇÏàͬµÄ, ¿ÉÒÔÏà»¥Ìæ´ú.
¾Ù¼¸¸öÀý×ÓÀ´ËµÃ÷ALLºÍANYµÄÓ÷¨
1. SELECT * from TABLEA WHERE FLD > AL ......
Navicat for xxx ÊÇÒ»¸öÓÅÐãµÄÊý¾Ý¿â¹ÜÀí¿Í»§¶Ë£¬ÓÐ MySQL¡¢Oracle µÈ°æ±¾¡£½¨Òé´ó¼Ò×îºÃÓà Enterprise °æ±¾£¬¹¦ÄÜÈ«ÃæÒ»Ð©£¬µ«½ÏÖ®ÓÚÃâ·ÑµÄ Lite °æ£¬ÆóÒµ°æ¿ÉÊÇÒª»¨Òø×ÓÂòµÄ¡£
°²×° Navicat for Oracle ºó£¬Ê×ÏÈÐèÒª½¨Ò»¸ö“Á¬½Ó”£¬×÷Ϊij¸ö¹ÜÀíÈÎÎñµÄ±êʶ£¬ÒòΪ×÷Î ......