摘要:
select 'create sequence '||sequence_name||' minvalue 1 maxvalue 999999999999999999999999999 start with 1 increment by 1 cache 20;' from user_sequences 阅读全文
摘要:
比如现在有一人员表 (表名:peosons) 若想将姓名、身份证号、住址这三个字段完全相同的记录查询出来 select p1.* from persons p1,persons p2 where p1.id<>p2.id and p1.cardid = p2.cardid and p1.pname = p2.pname and p1.address = p2.address ... 阅读全文