吃货的自我修养的博客

--检查高水位表 SELECT table_name, ROUND ( (blocks * 8), 2) "高水位空间 k", ROUND ( (num_rows * avg_row_len / 1024), 2) "真实使用空间 k", ROUND ( (blocks * 10 / 100) * 8, 2) "预留空间(pctfree) k", ROUND ( ( blocks * 8

一、获取当前时间 date: select sysdate from dual; timestamp: select systimestamp from dual; 二、字符串转date，timestamp date: select to_date('2020-06-09 12:25:23','yyyy-mm-dd hh24:mi:ss') from dual; timestamp: select to_timestamp('2020-06-09 00:00:00...

package lyf; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; //还是用到了sqljdbc4.jar中的com.microsoft.sqlserv...