DECLARE V_SQL VARCHAR2(1000);V_SQL_HEAD VARCHAR2(100);V_SQL_TAIL VARCHAR2(10);V_DAY VARCHAR2(8); CURSOR C_CUR IS SELECT TO_CHAR((TO_DATE(‘2012-01‘, ‘yyyy-mm‘) + (ROWNUM - 1)), ‘YYYYMMDD‘) S_DATE FROM DUALCONNECT BY ROWNUM <= LAST_DAY(TO_DATE(‘2012-12‘, ‘yyyy-mm‘)) - TO_DATE(‘2012-01‘, ‘yyyy-mm‘) + 1; BEGIN DBMS_OUTPUT.ENABLE(1000000); OPEN C_CUR;V_SQL_HEAD := ‘PARTITION BY RANGE(ACC...
using Oracle.DataAccess.Client;2 using System;3 using System.Collections.Generic;4 using System.ComponentModel;5 using System.Data;6 using System.Drawing;7 using System.Linq;8 using System.Text;9 using System.Threading.Tasks;
10 using System.Windows.Forms;
11
12 namespace WinForm_CreateGenerate_ForOracle
13 {
14 public partial class Form1 : Form
15 {
16 public Form1()
17 {...
/* 2 * 多条记录连接成一条 3 * tableName 表名 4 * type 类型:可以是insert/update/select之一 5 */ 6 create or replace function my_concat(tableName varchar2,type varchar2) 7 return varchar2 8 is 9 type typ_cursor is ref cursor;
10 v_cursor typ_cursor;
11 v_temp varchar2(30);
12 v_result varchar2(4000):= ‘‘;
13 v_sql varchar2(200);
14 begin
15 v_sql := ‘select C...
table t_OUTString
(
Tname varchar2(50),
OUTString clob,
OUTSTRING2 clob,
createddate date
); create or replace procedure Pro_ExToSql(SStrin in varchar2 ,TString in varchar2) isRString varchar2(30000);RowString varchar2(30000);LeaveString varchar2(30000);midStr varchar2(30000);LeftStr varchar2(30000);RightStr varchar2(30000);V_Cname varchar2(100);V_Cty...
cat awr.sql ######EXEC P_AWR_REPORT(‘201604251000‘, ‘201604251100‘, ‘D_OUTPUT‘, ‘‘, FALSE); FALSE为rac生成awr
EXEC P_AWR_REPORT(‘201604251000‘, ‘201604251100‘, ‘D_OUTPUT‘, ‘‘, FALSE);CREATE DIRECTORY D_OUTPUT AS ‘/oracle/products/11.2/db/scripts/mon/log‘;CREATE DIRECTORY D_OUTPUT AS ‘/oracle/db/scripts/mon/log‘;############sqlplus下新建DIRECTORY后在sqlplus下执行一下存储过程执行...
or replace trigger tri_test
before insert on test
for each row
declare
beginif :new.uuid is null then:new.uuid:=sys_guid();end if;
end tri_test; oracle 中使用触发器自动生成UUID标签:本文系统来源:http://www.cnblogs.com/yshyee/p/5659340.html
利用powerDesigner16.5连接oracle数据库并自动生成表结构图标签:log pow 数据 png 结构 9.png acl images design 本文系统来源:http://www.cnblogs.com/jobs-lgy/p/6364582.html
Table created.
SQL> create table test_jerry2 as select * from dba_objects;
Table created.
SQL> select count(*) from test_jerry where object_id not in (select max(object_id) from test_jerry2 group by owner);
Execution Plan
----------------------------------------------------------
Plan hash value: 3525080607
-------------------------------------------------------------------------------...
create or replace function get_request_code return varchar2 AS2 3 --函数的作用:自动生成订单号4 v_mca_no mcode_apply_01.mca_no%TYPE;5 6 CURSOR get_max_mca_no IS 7 SELECT max(substr(mca_no, 11, 1)) -- 查出的最大单号,截取出最后一位,如:1、2...n 8 FROM mcode_apply_01 9 WHERE substr(mca_no, 3, 8) = to_char(sysdate, ‘Y...
oracle下划线转驼峰select substr(replace(initcap(‘a‘ || ‘t_sys_user‘), ‘_‘, ‘‘), 2) from dual;
驼峰转下划线select regexp_replace(‘tSysUser‘, ‘([[:upper:]])(.)‘, ‘_\1\2‘) "initCustMoney",regexp_replace(‘userId‘, ‘([[:upper:]])(.)‘, ‘_\1\2‘) "custID"from dual;oracle自动生成表转大小写标签:money ini cap regex acl upper 划线 substr reg 本文系统来源:https://www.cnb...
有时候我们需要系统自动定期生成HTML格式的awr报告。定期收集管理。下面为脚本提供给大家,国外大牛写的--
-----------------------------------------------------------------------------------
-- File Name --
------------------------------------------------------------------------------------- File
Name : http://www.oracle-base.com/dba/10g/generate_multiple_awr_reports.sql--
Author : DR Timothy S ...
mapper.xml实例
<insert id="insert" parameterType="net.topcheer.module.entity.TsOperateLog"><selectKey resultType="String" keyProperty="id" order="BEFORE">select rawtohex(sys_guid()) from dual</selectKey>insert into TS_OPERATE_LOG (ID, OPERATE_USER_ID, OPERATE_USER_NAME,IP, DEVICE, BROWSER, OPERATE_CONTENT)values (#{id,jdbcType=VARCHAR}, #{operateUserId,jdbcType=OTHER}, #{operateUserName,jdbcType=...
数据库版本:Oracle 10.2.0.5 rac 操作系统版本:CentOS 5.6-64 1、出现问题: 1)后台alter日志没有任何错误 2)mmon报错内容如 数据库版本:Oracle 10.2.0.5 rac
操作系统版本:CentOS 5.6-64
1、出现问题:
1)后台alter日志没有任何错误
2)mmon报错内容如下
*** KEWRAFC: Flush slave failed, AWR Enqueue Timeout*** 2013-02-17 10:46:15.419*** KEWRAFC: Flush slave failed, AWR Enqueue Timeout*** 2013-02-17 10:47:15.5...
在oracle中sequence就是所谓的序列号,每次取的时候它会自动增加,一般用在需要按序列号排序的地方。 1、Create Sequence 你首 在Oracle中sequence就是所谓的序列号,每次取的时候它会自动增加,一般用在需要按序列号排序的地方。 1、Create Sequence 你首先要有CREATE SEQUENCE或者CREATE ANY SEQUENCE权限, CREATE SEQUENCE emp_sequence INCREMENT BY 1 -- 每次加几个 START WITH 1 -- 从1开始计数 NOMA...
oracle下划线转驼峰select substr(replace(initcap(a || t_sys_user), _, ), 2) from dual;
驼峰转下划线select regexp_replace(tSysUser, ([[:upper:]])(.), _\1\2) "initCustMoney",regexp_replace(userId, ([[:upper:]])(.), _\1\2) "custID"from dual;