oracle 使用记录

-- 向表中添加主键约束
alter table RETAIL_SHOP_FOLLOW_GOODS
    add constraint Pk_retail_shop_follow_goods primary key (FOLLOW_GOODS_ID);
-- 添加外键
ALTER TABLE RETAIL_SHOP_FOLLOW_GOODS
    ADD CONSTRAINT FK_RETAIL_SHOP_ID FOREIGN KEY (RETAIL_SHOP_ID) REFERENCES RETAIL_SHOP (RETAIL_SHOP_ID);
-- 删除外键
ALTER TABLE RETAIL_SHOP_FOLLOW_GOODS
    DROP CONSTRAINT FK_RETAIL_SHOP_ID;

误删除表数据

/*这里只是查出被删之前的数据，如果要恢复，则把查询出来的数据导出为sql,然后找到原表，重新导入数据即可*/

--闪回到15分钟前
select * from ST_POS_GOODS_DETAIL as of timestamp (systimestamp - interval '15' minute) where GOODS_QTY = 0;
--这里可以使用DAY、SECOND、MONTH替换minute，例如：
SELECT * FROM ST_POS_GOODS_DETAIL AS OF TIMESTAMP(SYSTIMESTAMP - INTERVAL '2' DAY);

查看某个字段增加时间

select * from USER_TAB_COLUMNS where COLUMN_NAME = 'RETAIL_SHOP_STAFF_ID' and TABLE_NAME = 'GLB_GOODS_BATCH';