- 博客(4)
- 资源 (11)
- 收藏
- 关注
原创 创建Oracle物化视图
create materialized view MViewNamerefresh complete on demandstart with to_date('01-01-2012 00:00:00', 'dd-mm-yyyy hh24:mi:ss') next SYSDATE + 1/24asselect ...
2012-06-08 17:37:31 217
原创 创建存储过程
Create PROCEDURE [dbo].[procGetData]( @Days int ) ASBEGIN-- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; if @Days is null s
2012-03-02 11:00:44 248
原创 创建表约束
USE [dbName]GO/****** 对象: Index [PK_tbName] 脚本日期: 03/01/2012 11:38:39 ******/ALTER TABLE [dbo].[tbName] ADD CONSTRAINT [PK_tbName] PRIMARY KEY CLUSTERED ( [Field1] ASC, [Field2] ASC
2012-03-01 11:41:55 199
原创 创建触发器
1.Oracle 触发器CREATE OR REPLACE TRIGGER TG_MTL_B_U_PACKINFO BEFORE update or insertON t_stateFOR EACH rowbegin --if nvl(:new.item_po_no,'/') != nvl(:old.item_po_no,'/') then :new.lastupdate
2012-03-01 11:25:16 277
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人