Create Table
来源:互联网 发布:货源软件 编辑:程序博客网 时间:2024/04/29 02:37
DECLARE
CURSOR TABCURSOR IS
SELECT COUNT(*) AS COUNTROW FROM USER_OBJECTS WHERE OBJECT_TYPE='TABLE' AND OBJECT_NAME='CS30_CSPURVIEW';
V_SQL VARCHAR2(2000);
BEGIN
FOR TAB IN TABCURSOR LOOP
IF TAB.COUNTROW!=0 THEN
V_SQL:='drop TABLE CS30_CSPURVIEW';
EXECUTE IMMEDIATE V_SQL;
END IF;
END LOOP;
END;
/
CREATE TABLE CS30_CSPURVIEW
(
PURVIEWID NUMBER(10,0) NOT NULL ,
CSID VARCHAR2 (50) NOT NULL ,
STARTIP VARCHAR2 (15) NOT NULL ,
ENDIP VARCHAR2 (15) NOT NULL ,
STARTIPDESC VARCHAR2 (12) DEFAULT '' NOT NULL ,
ENDIPDESC VARCHAR2 (12) DEFAULT '' NOT NULL ,
CONSTRAINT PK_CS30_CSPURVIEW PRIMARY KEY ( PURVIEWID ) ENABLE
);
CREATE INDEX IX_CS30_CSPURVIEW_CSID ON CS30_CSPURVIEW ( CSID );
CREATE INDEX IX_CS30_CSPURVIEW_STARTIPDESC ON CS30_CSPURVIEW ( STARTIPDESC );
CREATE INDEX IX_CS30_CSPURVIEW_ENDIPDESC ON CS30_CSPURVIEW ( ENDIPDESC );
/
DECLARE
CURSOR TABCURSOR IS
SELECT COUNT(*) AS COUNTROW FROM USER_OBJECTS WHERE OBJECT_TYPE='SEQUENCE' AND OBJECT_NAME='CS30_CSPURVIEW_SEQ';
V_SQL VARCHAR2(2000);
BEGIN
FOR TAB IN TABCURSOR LOOP
IF TAB.COUNTROW!=0 THEN
V_SQL:='drop sequence CS30_CSPURVIEW_SEQ';
EXECUTE IMMEDIATE V_SQL;
END IF;
END LOOP;
V_SQL:='create sequence CS30_CSPURVIEW_SEQ increment by 1';
EXECUTE IMMEDIATE V_SQL;
V_SQL:='CREATE OR REPLACE TRIGGER TRG_CS30_CSPURVIEW
BEFORE INSERT ON CS30_CSPURVIEW
FOR EACH ROW
BEGIN
SELECT CS30_CSPURVIEW_SEQ.NEXTVAL INTO :NEW.PurviewID FROM DUAL;
END;';
EXECUTE IMMEDIATE V_SQL;
END;
/
INSERT INTO .... ....;
COMMIT;
drop table "ECM"."CS30_CSPURVIEW" cascade constraints
/
- create table
- CREATE TABLE
- CREATE TABLE
- create table
- Create Table
- Create table
- create table
- CREATE TABLE
- create table
- create table
- CREATE TABLE
- CREATE TABLE
- CREATE TABLE
- Create Table中的秘密!
- php create html-table
- BAAN不能create table?
- mysql create table
- SQLite语法 CREATE TABLE
- 微软帝国大厦将倾?
- 让一切更容易点
- CSS样式覆盖规则
- J2ME 文件上传 实例(FileConnector链接文件系统,非RMS)
- Oracle常用命令(10g)
- Create Table
- 从今天开始慢慢积累
- Centos5.3 oracle11g 安装笔记
- spring/struts2 整合(转载)
- C# 中TreeView组件使用
- 调用webservices服务一个异常处理:org.xml.sax.SAXException: SimpleDeserializer encountered a child element, which is NOT expected, in someth
- 在基督裏凡事都能作(一)
- ArcGIS三维分析之ArcGlobe简要说明
- 最近几天遇到的几个wince奇怪问题