
oracle
tom有了cat
积跬步,以至千里
展开
-
Oracle 按照父子级排序
select *from oes_stage_def where id=#{id} start with depend_on_id is null connect_on_id原创 2022-03-08 14:33:28 · 691 阅读 · 0 评论 -
navicat oracle设置主键自增
#创建一个自增的序列create sequence demo_seq increment by 1 start with 1 nomaxvalue nominvalue nocache;#给表创建触发器create or replace trigger demo_seq before insert on TEST_USER for each row begin select demo_seq.nextval into :new.id from dual; end;...原创 2021-06-08 18:33:55 · 1543 阅读 · 0 评论