justdoit

/home/oracle/server 目录下建立脚本system_bakup.sh source /home/oracle/.bash_profile exp userid=jhyd_hr/jhyd_hr ROWS=Y DIRECT=Y COMPRESS=Y FILE=`date '+/home/oracle/backup/BackupDayOfMonth_%d.DMP'` INDEXE

select a.area_id,a.area_name,a.depth,a.up_area from table1 a where a.area_ids LIKE '%,'||(select a.dept_id from table2 a where login_name='xiajianyi')||',%' ;

CREATE OR REPLACE FUNCTION fn_google2baidu( lon in number, lat in number ) RETURN point is lp point; x_pi number := trunc(3.14159265358979324 * 3000.0 / 180.0,14); theta number; x numbe...

Map rest =new HashMap                 String d ="2018/04/25";                 String sql=" select to_char(ACTIVE_DATE,'yyyy/mm/dd') 时间,a.* from    table a  ";                 System.out.println("sq

在删除数据的时候不小心，把delete语句执行错了，把别的表给delete，而且还执行了commit！真汗.......数据是相当的重要........废话少说了！赶快找方法吧： 第一种： 1.打开Flash存储的权限 ALTER TABLE tableName ENABLE row movement ; 2.把表还原到指定时间点 flashback table tableName to

直接在你原来的select里面加排序就好了

package oracletest; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; public class jdbctest {     public static void ma

create table bak_yy_so_busi_log_577a_201706 nologging as select /*+parallel(a,10)*/busi_log_id,parent_id,create_date,a.org_id,op_id,bill_id,cust_id,business_id, customer_order_id from wzsc.F00_SO_B

CREATE OR REPLACE FUNCTION GetDistance(lat1 number, lng1 number, lat2 number, lng2 ...