u010989191的博客

数据库中双引号表示数值 单引号表示格式数据库查询加having进行条件限制

declareerr_num NUMBER;err_msg VARCHAR2(100);Type Search_Result Is Ref Cursor;m_cur Search_Result;begin dbms_output.put_line('begin procedure...'); dbms_output.put_line('-----------------------

-- gotodeclare x number;begin x:=9; <<repeat_loop>> x:=x-1; dbms_output.put_line('x: '||x); if x>0 then goto repeat_loop; end if;end;-- fordeclare x number;begin x:

禁止主外键：declare cursor c_constraints is select * from user_constraints; r_constrains user_constraints%rowtype; sql_str varchar2(100);begin open c_constraints; loop fetch c_constraint

经常需要oracle中的所有的字段的类型更改为另外一个类型，可以考虑利用如下代码：此处的demo为将NVARCHAR2转为VARCHAR2类型并且字段长度保持不变。declare cursor c_tab is select * from user_tab_columns t where t.data_type = 'NVARCHAR2'; r_tab user_tab_columns%ro

http://docs.oracle.com/cd/B28359_01/server.111/b28310/create003.htm#ADMIN11078Create Additional Tablespaces CREATE TABLESPACE apps_tbs LOGGING DATAFILE '/u01/app/oracle/oradata/mynewdb/apps01

call proc_dropifexists('DDINFO'); create TABLE DDINFO( DDCODE VARCHAR2(50) NOT NULL, DDNAME VARCHAR2(50), CREATEOR VARCHAR2(20), CREATETIME DATE, CONSTRAINT PK_DDCODE PRIMARY KEY(DDCODE))

create sequence SEQ_RESOURCEINFO_ORDERNUMminvalue 1maxvalue 99999999start with 1increment by 1nocacheorder;

1.创建procedurecreate or replace procedure proc_dropifexists(p_table in varchar2)isv_count number(10);begin select count(*) into v_count from user_tables where table_name = upper(p_table); i

--获取当前的连接数select count(*) from v$process;--获取最大连接数select value from v$parameter where name='processes';select value from v$parameter where name='sessions';--查询当前哪些用户正在使用数据selec