SQL
文章平均质量分 81
calvin82
这个作者很懒,什么都没留下…
展开
-
130821延迟约束
SQL> alter table calvin.test2 add constraint test2_name_uni unique(name) deferrable initially deferred; Table altered延迟约束,只能在初始创建该约束时候添加,如果是 deferrable initially immediate 则增删改数据会立即检查;如果是def原创 2013-08-21 11:12:19 · 304 阅读 · 0 评论 -
130829大对象
创建大对象表SQL> create table clob_content ( 2 id integer primary key, 3 clob_column clob not null ); Table createdSQL> create table blob_content ( 2 id integer primary key, 3 blob_column原创 2013-08-29 10:37:17 · 363 阅读 · 0 评论 -
130826触发器
创建触发器表SQL> create table product_price_audit ( 2 product_id integer 3 constraint price_audit_fk_products 4 references store.products(product_id),old_price number(5,2), 5 new_price numbe原创 2013-08-26 17:07:11 · 387 阅读 · 0 评论 -
130825包
SQL> create or replace package product_package as 2 type t_ref_cursor is ref cursor; 3 function get_products_ref_cursor return t_ref_cursor; 4 procedure update_product_price( 5 p_product_原创 2013-08-25 14:10:05 · 330 阅读 · 0 评论 -
130823创建函数
SQL> create or replace function circle_area ( 2 p_radius in number 3 ) return number as 4 v_pi number := 3.1415926; 5 v_area number; 6 7 begin 8 v_area := v_pi * power(p_radius原创 2013-08-24 18:48:13 · 410 阅读 · 0 评论 -
130823创建过程
SQL> create or replace procedure update_product_price( 2 p_product_id IN store.products.product_id%TYPE; 3 p_factor in number 4 ) 5 as 6 v_product_count integer; 7 8 begin 9原创 2013-08-24 16:41:30 · 466 阅读 · 0 评论 -
130822游标使用样例
游标用于一次访问一组记录,select语句将列提取到游标中,然后根据游标取得记录;1)声明一些变量,用于保存select语句返回的列值;2)声明游标,并指定select语句为游标赋值;3)打开游标;4)从游标中循环获取记录;5)关闭游标;-- Created on 2013/8/22 by CALVIN declare -- Local variables原创 2013-08-22 18:29:40 · 412 阅读 · 0 评论 -
130822简单循环、while循环和for循环;
简单循环、while循环和for循环;counter :=0;loop counter := counter+1;exit when counter = 5;end loop;counter :=0;while counter < 6 loop counter := counter + 1;end loop;for count2 in 1..5 loopdbms原创 2013-08-22 18:11:30 · 459 阅读 · 0 评论 -
130822创建视图
SQL> create view cheap_product_view as 2 select * from store.products where price View created SQL> select * from calvin.cheap_product_view where rownum原创 2013-08-22 16:03:25 · 420 阅读 · 0 评论 -
130822PLSQL 样例程序
-- Created on 2013/8/22 by CALVIN declare -- Local variables here width integer; height integer :=2; area integer;begin -- Test statements here area := 6; width := area/height; DBMS原创 2013-08-22 18:06:14 · 299 阅读 · 0 评论 -
130821创建索引
SQL> create table calvin.customers as select * from store.customers; Table created SQL> CREATE index customers_last_name_idx on customers(last_name); Index created创建样例表和样例索引;原创 2013-08-21 17:22:08 · 316 阅读 · 0 评论 -
130821生成序列
SQL> create sequence test2_seq start with 10 increment by -1 minvalue 1 maxvalue 10 cycle cache 5; Sequence created SQL> select * from user_sequences; SEQUENCE_NAME MIN_V原创 2013-08-21 17:15:03 · 368 阅读 · 0 评论 -
130831执行计划查看
SQL> set autotrace traceonlySQL> set linesize 300SQL> select * from dba_objects;72390 rows selected.Execution Plan----------------------------------------------------------Plan hash value: 45原创 2013-08-31 13:44:48 · 295 阅读 · 0 评论