MyeclipseÖÐÁ¬½ÓOracleµÄ¾µä´úÂë
package cn.edu.bit.test;
import java.sql.*;
public class Jdbc {
public static void main(String[] args)
{
try{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
System.out.println("×¢²á³É¹¦");
String URL = "jdbc:oracle:thin:localhost:1521:orcl";
String user = "username"; //Á¬½ÓÊý¾Ý¿âµÄÓû§Ãû
String password = "password";//Á¬½ÓÊý¾Ý¿âµÄÃÜÂë
Connection conn = DriverManager.getConnection(URL, user, password);
System.out.println("Á¬½Ó³É¹¦");
Statement st;
st = conn.createStatement();
ResultSet rs;
rs = st.executeQuery("select * from scott.project");
while(rs.next()){
System.out.println(rs.getString("time"));
}
}catch(Exception e)
{ e.printStackTrace();
System.out.println("Á¬½Óʧ°Ü");
}
}
}
Ïà¹ØÎĵµ£º
41.SYSDATE
ÓÃÀ´µÃµ½ÏµÍ³µÄµ±Ç°ÈÕÆÚ
SQL> select to_char(sysdate,dd-mm-yyyy day) from dual;
TO_CHAR(SYSDATE,
-----------------
09-05-2004ÐÇÆÚÈÕ
trunc(date,fmt)°´ÕÕ¸ø³öµÄÒªÇó½«ÈÕÆÚ½Ø¶Ï,È ......
OracleÊý¾Ý¿âµÄÆô¶¯Óõ½Á˳õʼ»¯²ÎÊý£¬Ò»°ãÇé¿öÏ¿ÉÒÔÔÚsqlplusÀïÓÃshow parameter À´»ñµÃ¡£¶øOracleÊý¾Ý¿âΪÁËdebug »òÕß½â¾öÒ»Ð©ÌØÊâµÄÎÊÌ⣬»¹ÌṩÁËһЩÒÔ“_”¿ªÍ·µÄÒþº¬²ÎÊý¡£ ÍøÂçÉÏÓÐһЩscript¿ÉÒÔÈÃÎÒÃÇÇáËɼì²éÕâЩÒþº¬²ÎÊý. ÏÂÃæÎÒÃÇÀ´Ïêϸ½éÉÜÒ»ÏÂÈçºÎÖ±½ÓÔÚsqlplus ÓÃshow parameterÀ´»ñÈ¡Òþº¬²ÎÊý ......
µ±ÎÒÃÇÃæ¶Ô Êý°ÙÍòÊýǧÍòÐÐÁеÄÊý¾Ý¿â±íµÄʱºò£¬¶øÄãÓÖÏ£ÍûÄܽ«Êý¾Ý¾¡¿ìµÄµ¼³ö³Étxt¸øÄãµÄÀϰ壬ÓÐÈí¼þ»òÕ߯äËû¶«Î÷µ¼³öÀ´¾ÍÏԵñȽÏÓôÃÆÁË£¬ÒòΪÀϰåÒª³ÔÎç·¹ÁË£¬Ëû¿É²»Ï£ÍûÔÚϰàµÄʱºò»¹Ìýµ½ÄãÔÚ˵£¬Êý¾ÝÕýÔÚµ¼³öÖС£
ÓÚÊÇÎÒÃÇÀûÓÃÁË£¬ËÙ¶ÈתÈëÕýÌâÁ˰¡¡£
ÐèÒªµÄÄ£¿é£º
DBI£»
#!/usr/bin/pe ......
http://hi.baidu.com/fyears/blog/item/5ef68ac3feb9a45db219a836.html
select object_id,session_id,locked_mode from v$locked_object;
¡¡¡¡select t2.username,t2.sid,t2.serial#,t2.logon_time
¡¡¡¡from v$locked_object t1,v$session t2
¡¡¡¡where t1.session_id=t2.sid order by t2.logon_time;
alter system ki ......