ws61925的博客

--查找所有定时作业的信息 select * --job,next_date,next_sec,failures,broken from user_jobs --建一张测试表 create table b( id varchar(20), name varchar(30), telphone varchar(30) ); --...

create database link 名称 connect to 连接数据库的用户名 identified by 密码 using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 连接数据库得地址)(PORT = 1521)) ) (CONNECT_DATA = (SE...

取一个一维数组中的最大值greatest SELECT Greatest('a','x','fit','xa') FROM dual; 取一个一维数组中的最小值least SELECT Least('a','x','fit','xa','ab') FROM dual; 全角的数字/字母/标点符号转半角to_single_byte SELECT To_Single_By...

create or replace procedure pro_test_cursor is cursor userRows is select * from I_SKYEMPLOYEE@mthhr ise where ise.modified = '2' ; begin for userRow in userRows loop update skyemployee...