oracle自增主键怎么写 oracle怎么用触发器实现主键自增?
oracle怎么用触发器实现主键自增?实施步骤可参考以下示例。Drop table book—创建table book(bookid VARCHAR2(4)主键,name VARCHAR2(20))-
oracle怎么用触发器实现主键自增?
实施步骤可参考以下示例。Drop table book—创建table book(bookid VARCHAR2(4)主键,name VARCHAR2(20))--create sequence book Seq start with 1 increment by 1--create or replace trigger book在插入到book之前为每行开始选择book下一步分为:新建.bookId从双端--添加数据插入到书本(名称)值(“CC”)插入到书本(名称)值(“DD”)提交