随笔分类 -  Oracle

摘要：Read The Code!#!/usr/bin/python#coding=utf-8import threadingimport osimport time#用户名user = 'username'#密码passwd = 'password'#备份保存路径savepath = '/home/oracle/orcl_bak/'#要备份的表tables = ' tables=department,employee'#备份周期circle = 2.0#备份命令global bak_commandbak_command = ' 阅读全文

摘要：-- 先创建包CREATE OR REPLACE PACKAGE mypackage AS TYPE mycursor IS REF CURSOR;END;--创建分页存储过程CREATE OR REPLACE PROCEDURE splitpage(v_tableName IN VARCHAR2,v_pageSize IN NUMBER,v_pageNow IN NUMBER,v_myTotalRows OUT NUMBER,v_myTotalPageCount OUT NUMBER,v_cursor OUT mypackage.mycursor)ISv_sql VARCHAR2(1000) 阅读全文