y541397839的专栏

1 将数据库TEST完全导出,用户名system 密码manager 导出到D:daochu.dmp中    exp system/manager@TEST file=d:daochu.dmp full=y2 将数据库中system用户与sys用户的表导出    exp system/manager@TEST file=d:daochu.dmp owner=(system,sys)

写入   public boolean saveWordFile(String filePath) {<br />        File file = new File(filePath);<br />        Connection conn = getConnection();<br />        try {<br />            java.sql.Statement st = conn.createStatement();<br />            conn.setAu

create public database link WFMLINK_SCH_RES_SITE_DISTANCE   connect to inventory IDENTIFIED by inventory   using '(DESCRIPTION =     (ADDRESS = (PROTOCOL = TCP)(HOST = 11.12.13.50)(PORT = 1521))

http://blog.youkuaiyun.com/xo_zhang/article/details/8395554 http://blog.youkuaiyun.com/pangshaohua/article/details/8544135 http://blog.youkuaiyun.com/magic_elf/article/details/8693327 http://blog.youkuaiyun.com/lich

SELECT *   FROM V$LOCKED_OBJECT A, DBA_OBJECTS B  WHERE A.OBJECT_ID = B.OBJECT_ID    AND B.OBJECT_NAME = 'FND_USER_T'

--创建表1 T_IMTI_TEST create table T_IMTI_TEST(     imti_no number,     imti_name varchar2(200),     imti_desc varchar2(200),     imti_ph_no number ); --创建表2 T_SALT_TEST drop table T_SALT_TEST;

--====================================存储过程=============================================== /* *scm_iss.test_imit_pro1 *无参数存储过程 */ CREATE OR REPLACE PROCEDURE TEST_IMIT_PRO1 AS   P_IMTI_NAME VARCH

/* *scm_iss.test_imti_fun2 *带有输入参数的Function */ CREATE OR REPLACE FUNCTION TEST_IMTI_FUN2(P_NO IN NUMBER) RETURN VARCHAR2 IS   P_IMTI_NAME VARCHAR2(200);   P_IMTI_DESC VARCHAR2(200);   P_RETURN