摘要:
业务需要,通过lucene查出符合搜索条件的id,然后在详情表里查出这些id的详情?1SELECT id,QUESTION,QUESTIONCOMMENT FROM "ASKDBA_QUESTION" where ID IN (63,62,65,61,64);其中id是根据搜索的权值进行的排序,sq... 阅读全文
摘要:
首先,创建一张表:CREATE TABLE example(ID Number(4) NOT NULL PRIMARY KEY,NAME VARCHAR(25));然后,自定义一个序列(sequence):CREATE SEQUENCE example_sequenceINCREMENT BY 1 ... 阅读全文