Oracle数据库常用操作 2011.3.10

1.导出数据 exp username/pwd@sid file=c:/temp.dmp tables=table_name;

 

2.导入数据 imp username/pwd@sid file=c:/temp.dmp tables=table_name;

 

3.重命名表

  alter table old_table_name rename to new_table_name;

 

4.select ldap('a', 3, 'b') from dual;

 

5.table to table

 

CREATE OR REPLACE PROCEDURE P_TEMP_INSERTLOGDATA

 AS

  CURSOR c_UserActiveLog IS  SELECT * FROM T_VMS_ACTIVE_USEROPERATELOG;    v_UserActiveLog c_UserActiveLog%ROWTYPE;

BEGIN

    FOR v_UserActiveLog IN c_UserActiveLog LOOP    INSERT INTO T_VMS_ACTIVE_USEROPTTEMP      (SEQUENCEID, OP_TIME, LOG_LEVEL, MODULE_NAME, USERNO, ACTIVITY, DESCRIPTION, OP_RESULT, PARTCOL_DATE)    VALUES      (v_UserActiveLog.SEQUENCEID,       v_UserActiveLog.OP_TIME,       v_UserActiveLog.LOG_LEVEL,       v_UserActiveLog.MODULE_NAME,       v_UserActiveLog.USERNO,       v_UserActiveLog.ACTIVITY,       v_UserActiveLog.DESCRIPTION,       v_UserActiveLog.OP_RESULT,       SUBSTR(v_UserActiveLog.USERNO, -3, 2));    END LOOP;  COMMIT;

END P_TEMP_INSERTLOGDATA;