Oracle常用脚本示例
CREATE SEQUENCE s_report_id INCREMENT BY 1 MAXVALUE 999999 START WITH 1;
CREATE SEQUENCE checkup_no_seq NOCYCLE MAXVALUE 999999 START WITH 2;
CREATE OR REPLACE TRIGGER bef_ins_report
BEFORE INSERT ON busi_report
referencing old as old new as new
FOR EACH ROW
BEGIN
new.rep_id = s_report_id.nextval;
END;
CREATE OR REPLACE TRIGGER bef_ins_report
BEFORE INSERT ON busi_report
FOR EACH ROW
DECLARE next_id NUMBER;
BEGIN
SELECT s_report_id.NEXTVAL INTO next_id from dual;
:new.rep_id := next_id;
END;
-------------------------------------------------------------------------
-----触发示例-----
--------------------------------------------------------------------------
CREATE OR REPLACE TRIGGER set_checkup_no
BEFORE INSERT ON checkup_history
FOR EACH ROW DECLARE next_checkup_no NUMBER;
BEGIN
SELECT checkup_no_seq.NEXTVAL INTO next_checkup_no from dual;
:new.checkup_no := next_checkup_no;
END;
--------------------------------------------------------------------------
-----建表删表-----
--------------------------------------------------------------------------
CREATE TABLE busi_report
(
rep_id number(6) NOT NULL,
content varchar2(80) ,
adder varchar2(20) ,
rep_src varchar2(20) ,
add_time date ,
rep_time date ,
PRIMARY KEY (rep_id)
);
drop table BUSI_REPORT
select * from busi_report
insert into busi_report (rep_id, content, adder, rep_src, add_time, rep_time) values(21,'天P有雨','zss','adf',to_date('2002-3-2 12:31
相关文档:
1.在A用户下授权“商户信息表”给B用户
grant all on TBL_INF_MCHNT_INF to B;
commit;
2.在B用户下建立同义词
create synonym TBL_INF_MCHNT_INF for A.TBL_INF_MCHNT_INF;
3. 查询数据库所有同义词select * from sys.synonyms ......
1、创建存储过程
create or replace procedure test(var_name_1 in type,var_name_2 out type) as
--声明变量(变量名 变量类型)
begin
--存储过程的执行体
end test;
打印出输入的时间信息
E.g:
create or replace procedure test(workDate in Date) is
begin
dbms_output.putline('The input date i ......
SQL> create table test2(s1 varchar(10),s2 varchar2(10));
表已创建。
SQL> insert into test2 values('11','111');
已创建 1 行。
SQL> insert into test2 values('22','222');
已创建 1 行。
SQL> CREATE OR REPLACE PACKAGE test222 AS
2 TYPE t_cursor IS REF CURSOR;
3 procedure p_tes ......
Oracle全文索引的STORAGE属性是为了给全文索引生成的辅助表设置存储参数的。
Oracle的全文索引会生成一张或多张辅助表,由于这些表是Oracle自动生成的,用户没有办法直接设置这些表和索引的物理参数,因此Oracle提供了STORAGE属性,专门设置这些辅助表和索引的物理参数。
SQL> SELECT * from TAB;
TNAME ......