Oracle中用PL/SQL的表的增删改查和数据的增删改查

迷总

已于 2022-07-21 09:05:26 修改

阅读量317

点赞数 1

文章标签： oracle sql 数据库

于 2022-07-19 15:49:04 首次发布

本文链接：https://blog.csdn.net/qq_43243673/article/details/125873720

版权

表

表的创建

CREATE TABLEEDS_TEST_SAMPLE (
ID_ VARCHAR2(32) NOT NULL,
ENT_ID_ VARCHAR2(32),
ENT_NAME_ VARCHAR2(100),
QZH_ID_ VARCHAR2(100),
QZH_NAME_ VARCHAR2(100),
TENANT_ID_ VARCHAR2(64),
CREATE_TIME_ DATE,
CREATE_BY_ VARCHAR2(32),
UPDATE_BY_ VARCHAR2(32),
UPDATE_TIME_ DATE,
CONSTRAINT PK_EDS_TEST_SAMPLE PRIMARY KEY (ID_)
);
COMMENT ON TABLE EDS_TEST_SAMPLE IS ‘测试例子管理’;
COMMENT ON COLUMN EDS_TEST_SAMPLE.ID_ IS ‘主键’;
COMMENT ON COLUMN EDS_TEST_SAMPLE.ENT_ID_ IS ‘档案库ID’;
COMMENT ON COLUMN EDS_TEST_SAMPLE.ENT_NAME_ IS ‘档案库名称’;
COMMENT ON COLUMN EDS_TEST_SAMPLE.QZH_ID_ IS ‘全宗号’;
COMMENT ON COLUMN EDS_TEST_SAMPLE.QZH_NAME_ IS ‘全宗名称’;
COMMENT ON COLUMN EDS_TEST_SAMPLE.TENANT_ID_ IS ‘租户ID’;
COMMENT ON COLUMN EDS_TEST_SAMPLE.CREATE_TIME_ IS ‘创建时间’;
COMMENT ON COLUMN EDS_TEST_SAMPLE.CREATE_BY_ IS ‘创建人’;
COMMENT ON C