VG@jishenORCLselect * from LIB_PAGE_CONFIG tVG@jishenORCLselect * from LIB_COM_CONFIG t/@jishenORCLCREATE TABLE "JISHEN"."OPAC_MYBOOKSHELF" ("ID" NUMBER(10,0) NOT NULL ENABLE, "MBTYPE" VARCHAR2(32 CHAR), "RDRID" NUMBER(10,0), "BIBID" NUMBER(10,0), "MBDATE" VARCHAR2(8 CHAR), "MBTIME" VARCHAR2(6 CHAR), "LINKNAME" VARCHAR2(100 CHAR), "LINKURL" VARCHAR2(1024 CHAR), "NOTE" VARCHAR2(500 CHAR)) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 2556,/@jishenORCLCREATE TABLE "JISHEN"."LIB_CIR_PECCANCY" ("ID" NUMBER(10,0) NOT NULL ENABLE, "RDRID" NUMBER(10,0) NOT NULL ENABLE, "PECTYPE" CHAR(1 CHAR) NOT NULL ENABLE, "PECDATE" NUMBER(8,0), "PECSTAMP" NUMBER(16,0), "NOTE" VARCHAR2(30 CHAR), "BIBID" NUMBER(10,0), "HLDID" NUMBER(10,0)) SEGMENT CREATION DEFERRED PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING#/@jishenORCLCREATE INDEX lib_bib_title_idx ON lib_bibliography(title)%;/@jishenORCLCREATE INDEX lib_bib_author_idx ON lib_bibliography(author)'/@jishenORCLCREATE INDEX lib_bib_classno_idx ON lib_bibliography(classno)) /@jishenORCLCREATE INDEX lib_bib_SUBJECT_idx ON lib_bibliography(SUBJECT)+g/@jishenORCLCREATE INDEX lib_bib_ORDERNO_idx ON lib_bibliography(ORDERNO)-[/@jishenORCLCREATE INDEX lib_bib_UNIFIEDNO_idx ON lib_bibliography(UNIFIEDNO)//@jishenORCLCREATE INDEX lib_bibidx_bibid_idx ON lib_biblios_index(bibid)NO)1 R/@jishenORCLCREATE INDEX LIB_BIBLIOS_INDEX_CODE_VALUE ON LIB_BIBLIOS_INDEX(TYPE,VALUE) /@jishenORCLdrop index lib_bib_isbn_idxEX_CODE_VALUE ON LIB_BIBLIOS_INDEX(TYPE,VALUE)!5/@jishenORCLCREATE INDEX lib_bib_isbn_idx ON lib_bibliography(isbn)"A /@jishenORCLdrop index lib_bib_title_idx ON lib_bibliography(isbn)$/@jishenORCLdrop index lib_bib_author_idx ON lib_bibliography(title)&]/@jishenORCLdrop index lib_bib_classno_idx ON lib_bibliography(author)(÷/@jishenORCLdrop index lib_bib_SUBJECT_idxx ON lib_bibliography(classno)*%//@jishenORCLdrop index lib_bib_ORDERNO_idxx ON lib_bibliography(SUBJECT),sԽ/@jishenORCLdrop index lib_bib_UNIFIEDNO_idxON lib_bibliography(ORDERNO)./@jishenORCLdrop index lib_bibidx_bibid_idxdx ON lib_bibliography(UNIFIEDNO)0/@jishenORCLdrop index LIB_BIBLIOS_INDEX_CODE_VALUE_biblios_index(bibid)b2b/@jishenORCLcomment on column PAR_CIR_SPECIAL.SPETYPE is '1ר2ר3'PAR_CIR_SPECIAL */ /*==============================================================*/ create table PAR_CIR_SPECIAL ( CODE VARCHAR2(10 CHAR) not null, SPETYPE CHAR(1 CHAR), LIBCODE VARCHAR2(10 CHAR) not null, NAME VARCHAR2(30 CHAR) not null, RDRTYPE VARCHAR2(500 CHAR) not null, LOCCODE VARCHAR2(32 CHAR) not null, PARAMJSON VARCHAR2(500 CHAR) not null, constraint PK_PAR_CIR_SPECIAL primary key (CODE) )cӔc/@jishenORCLdrop index SPELOAN_BIBID_IDXCIAL.SPETYPE is '1ר2ר3'gh/@jishenORCL/*==============================================================*/ /* Index: SPELOAN_RDRID_IDX */ /*==============================================================*/ create index SPELOAN_RDRID_IDX on LIB_CIR_SPELOAN ( RDRID ASC ) not null, LIBCODE VARCHAR2(10 CHAR), RDRID NUMBER(10) not null, BIBID NUMBER(10) not null, LOANKEY VARCHAR2(50 CHAR), RULECODE VARCHAR2(10 CHAR) not null, LOANDATE VARCHAR2(8 CHAR), LOANTIME VARCHAR2(6 CHAR), RETURNDATE VARCHAR2(8 CHAR), LOCATION VARCHAR2(20 CHAR), RENEWNUM NUMBER(6), NOTE VARCHAR2(100 CHAR), constraint PK_LIB_CIR_SPELOAN primary key (ID) )hfj/@jishenORCL/*==============================================================*/ /* Index: SPELOAN_BIBID_IDX */ /*==============================================================*/ create index SPELOAN_BIBID_IDX on LIB_CIR_SPELOAN ( BIBID ASC )ik/@jishenORCLCALL JISHEN.HANDLESEQ('LIB_CIR_SPELOAN')=======================*/ /* Index: SPELOAN_BIBID_IDX */ /*==============================================================*/ create index SPELOAN_BIBID_IDX on LIB_CIR_SPELOAN ( BIBID ASC )jKl/@jishenORCLdelete from PAR_SYS_SUBMENU where id in (6308)kKl/@jishenORCLInsert into PAR_SYS_SUBMENU (ID, NAME, URL, ICONCLS, MODULECODE, MENUID, SHOWLEVEL) Values (6308, 'ר', 'cir_special.jsp', 'gear', 'par', 6300, 0)ll/@jishenORCLdelete from PAR_SYS_MENU where id in (4250)RL, ICONCLS, MODULECODE, MENUID, SHOWLEVEL) Values (6308, 'ר', 'cir_special.jsp', 'gear', 'par', 6300, 0)mom/@jishenORCLInsert into PAR_SYS_MENU (ID,TITLE, MODULECODE) Values (4250, 'ר','cir')n m/@jishenORCLdelete from PAR_SYS_SUBMENU where id in (4251)ODE) Values (4250, 'ר','cir')ov6n/@jishenORCLInsert into PAR_SYS_SUBMENU (ID, NAME, URL, ICONCLS, MODULECODE, MENUID, SHOWLEVEL) Values (4251, 'ר', 'cirspeloan.jsp', 'vcard-o', 'cir', 4250, 0)pn/@jishenORCLdelete from PAR_SYS_SUBMENU where id in (4252) ICONCLS, MODULECODE, MENUID, SHOWLEVEL) Values (4251, 'ר', 'cirspeloan.jsp', 'vcard-o', 'cir', 4250, 0)qn/@jishenORCLInsert into PAR_SYS_SUBMENU (ID, NAME, URL, ICONCLS, MODULECODE, MENUID, SHOWLEVEL) Values (4252, 'ר', 'registersperead.jsp', 'server', 'cir', 4250, 0)rLTo/@jishenORCLdelete from PAR_SYS_SUBMENU where id in (4408) ICONCLS, MODULECODE, MENUID, SHOWLEVEL) Values (4252, 'ר', 'registersperead.jsp', 'server', 'cir', 4250, 0)so/@jishenORCLInsert into PAR_SYS_SUBMENU (ID, NAME, URL, ICONCLS, MODULECODE, MENUID, SHOWLEVEL) Values (4408, 'ר嵥', 'exp_rdr_speloanlist.jsp', 'list', 'cir', 4400, 0)t#p/@jishenORCLdelete from PAR_SYS_SUBMENU where id in (4509) ICONCLS, MODULECODE, MENUID, SHOWLEVEL) Values (4408, 'ר嵥', 'exp_rdr_speloanlist.jsp', 'list', 'cir', 4400, 0)u#p/@jishenORCLInsert into PAR_SYS_SUBMENU (ID, NAME, URL, ICONCLS, MODULECODE, MENUID, SHOWLEVEL) Values (4509, 'רͳ', 'sta_rdr_speloancount.jsp', 'bar-chart', 'cir', 4500, 0)~h(VG@jishenORCLselect * from LIB_BIBLIOS_INDEX tD, NAME, URL, ICONCLS, MODULECODE, MENUID, SHOWLEVEL) Values (4509, 'רͳ', 'sta_rdr_speloancount.jsp', 'bar-chart', 'cir', 4500, 0)\X2)/@jishenORCLcomment on column OPAC_MYBOOKSHELF.MBTYPE is '0ҵ1RSS' /* Table: LIB_CIR_RESERVE */ /*==============================================================*/ create table OPAC_MYBOOKSHELF ( ID NUMBER(10) not null, MBTYPE CHAR(1 CHAR), RDRID NUMBER(10), BIBID NUMBER(10), MBDATE VARCHAR2(8 CHAR), MBTIME VARCHAR2(6 CHAR), LINKNAME VARCHAR2(100 CHAR), LINKURL VARCHAR2(1024 CHAR), NOTE VARCHAR2(500 CHAR) )]*/@jishenORCL/*==============================================================*/ /* Index: MYBOOKSHELF_RDRID */ /*==============================================================*/ create index MYBOOKSHELF_RDRID on OPAC_MYBOOKSHELF ( RDRID ASC ) not null, MBTYPE CHAR(1 CHAR), RDRID NUMBER(10), BIBID NUMBER(10), MBDATE VARCHAR2(8 CHAR), MBTIME VARCHAR2(6 CHAR), LINKNAME VARCHAR2(100 CHAR), LINKURL VARCHAR2(1024 CHAR), NOTE VARCHAR2(500 CHAR) )^qz+/@jishenORCLDROP SEQUENCE OPAC_MYBOOKSHELF_SEQ=============================*/ /* Index: MYBOOKSHELF_RDRID */ /*==============================================================*/ create index MYBOOKSHELF_RDRID on OPAC_MYBOOKSHELF ( RDRID ASC )_+/@jishenORCLCREATE SEQUENCE OPAC_MYBOOKSHELF_SEQ START WITH 1 MAXVALUE 1000000000000000000000000000 MINVALUE 1 NOCYCLE CACHE 20 NOORDER==============================================================*/ create index MYBOOKSHELF_RDRID on OPAC_MYBOOKSHELF ( RDRID ASC )``/@jishenORCLdrop table PAR_CIR_SPECIAL cascade constraintsITH 1 MAXVALUE 1000000000000000000000000000 MINVALUE 1 NOCYCLE CACHE 20 NOORDERY)&/@jishenORCLdrop index MYBOOKSHELF_RDRIDELF_SEQ START WITH 1 MAXVALUE 1000000000000000000000000000 MINVALUE 1 NOCYCLE CACHE 20 NOORDERJ7,/@jishenORCL/*==============================================================*/ /* Table: LIB_CIR_BLACKLIST */ /*==============================================================*/ create table LIB_CIR_BLACKLIST ( ID NUMBER(10) not null, BCTYPE VARCHAR2(10 CHAR) not null, BCVALUE VARCHAR2(100 CHAR) not null, BCDATE NUMBER(8), BCSTAMP NUMBER(16), NOTE VARCHAR2(100 CHAR), constraint PK_LIB_CIR_BLACKLIST primary key (ID) )P=/@jishenORCLcomment on column LIB_CIR_BLACKLIST.BCVALUE is 'ʶֵ'Q /@jishenORCLCALL JISHEN.HANDLESEQ('LIB_CIR_BLACKLIST') is 'ʶֵ'M./@jishenORCL/*==============================================================*/ /* Index: LIB_CIR_BLACKLIST_BCTYPE_VAL */ /*==============================================================*/ create index LIB_CIR_BLACKLIST_BCTYPE_VAL on LIB_CIR_BLACKLIST ( BCTYPE ASC, BCVALUE ASC )ZM'/@jishenORCLdrop table OPAC_MYBOOKSHELF cascade constraintsO;چ/@jishenORCLcomment on column LIB_CIR_BLACKLIST.BCTYPE is 'IDCARD'[q(/@jishenORCL/*==============================================================*/ /* Table: LIB_CIR_RESERVE */ /*==============================================================*/ create table OPAC_MYBOOKSHELF ( ID NUMBER(10) not null, MBTYPE CHAR(1 CHAR), RDRID NUMBER(10), BIBID NUMBER(10), MBDATE VARCHAR2(8 CHAR), MBTIME VARCHAR2(6 CHAR), LINKNAME VARCHAR2(100 CHAR), LINKURL VARCHAR2(1024 CHAR), NOTE VARCHAR2(500 CHAR) )ab/@jishenORCL/*==============================================================*/ /* Table: PAR_CIR_SPECIAL */ /*==============================================================*/ create table PAR_CIR_SPECIAL ( CODE VARCHAR2(10 CHAR) not null, SPETYPE CHAR(1 CHAR), LIBCODE VARCHAR2(10 CHAR) not null, NAME VARCHAR2(30 CHAR) not null, RDRTYPE VARCHAR2(500 CHAR) not null, LOCCODE VARCHAR2(32 CHAR) not null, PARAMJSON VARCHAR2(500 CHAR) not null, constraint PK_PAR_CIR_SPECIAL primary key (CODE) )d߸d/@jishenORCLdrop index SPELOAN_RDRID_IDXe :f/@jishenORCLdrop table LIB_CIR_SPELOAN cascade constraintsf-^g/@jishenORCL/*==============================================================*/ /* Table: LIB_CIR_SPELOAN */ /*==============================================================*/ create table LIB_CIR_SPELOAN ( ID NUMBER(10) not null, LIBCODE VARCHAR2(10 CHAR), RDRID NUMBER(10) not null, BIBID NUMBER(10) not null, LOANKEY VARCHAR2(50 CHAR), RULECODE VARCHAR2(10 CHAR) not null, LOANDATE VARCHAR2(8 CHAR), LOANTIME VARCHAR2(6 CHAR), RETURNDATE VARCHAR2(8 CHAR), LOCATION VARCHAR2(20 CHAR), RENEWNUM NUMBER(6), NOTE VARCHAR2(100 CHAR), constraint PK_LIB_CIR_SPELOAN primary key (ID) )w%QG@jishenORCLselect count* from LIB_BIBLIOGRAPHY tVG@jishenORCLselect * from LIB_TITLE_NUMBER tyVuVG@jishenORCLselect * from LIB_ACQ_BOOKSELLER tzVG@jishenORCLselect * from LIB_ACQ_COLLECTBIB t{ֵVG@jishenORCLselect * from LIB_ACQ_ORDER t|?IEVG@jishenORCLselect * from LIB_ACQ_RECOMMEND t}VG@jishenORCLselect * from LIB_BIBLIOGRAPHY tƏVG@jishenORCLselect * from LIB_BOOKCLASS tƐVG@jishenORCLselect * from LIB_CAT_INSTITUTIONAL t4VG@jishenORCLselect * from LIB_CAT_SUBJECT t7VG@jishenORCLselect * from LIB_CIR_READER tYޤVG@jishenORCLselect * from LIB_FORMAT_DESIGN tFVG@jishenORCLselect * from LIB_HOLDINGS tf~VG@jishenORCLselect * from LIB_PER_ALLOCATION tby/VG@jishenORCLselect * from LIB_PER_BIND tԐVG@jishenORCLselect * from LIB_PER_CHECK t#VG@jishenORCLselect * from LIB_PER_DETAIL_CHECK tO@jishenORCLselect * from LIB_READER_COUNT tfO@FRXXnJISHENselect * from T_DB_VERSION tT tVG@jishenORCLselect * from TOAD_PLAN_TABLE t]$VG@jishenORCLselect * from PAR_SYS_SUBSYSTEM tg[VG@jishenORCLselect * from PAR_SYS_SUBMENU t ͱM@jishenORCL--½ûûȨ grant select on jishen.UserInfo to test1E,RDRNO,LOGTYPE,LOGDATE,LOGSTAMP,PARENTID) AS SELECT LOG.ID,HLD.BARCODE,RED.RDRNO,LOGTYPE,LOGDATE,LOGSTAMP,PARENTID from lib_cir_log log inner join lib_holdings hld on log.hldid=hld.id inner join lib_cir_reader red on LOG.RDRID = RED.IDRAPHY bib on hld.bibid = bib.idDͱM@jishenORCL--v$UserInfo CREATE OR REPLACE FORCE VIEW UserInfo (rdrno,NAME,RDRFLD1,RDRFLD2,RDRFLD3,RDRFLD4,OTHERNO1,OTHERNO2) AS SELECT rdrno,NAME,RDRFLD1,RDRFLD2,RDRFLD3,RDRFLD4,OTHERNO1,OTHERNO2 FROM lib_cir_reader WITH READ ONLY lib_holdings hld on log.hldid=hld.id inner join lib_cir_reader red on LOG.RDRID = RED.IDRAPHY bib on hld.bibid = bib.id> ӱM@jishenORCL--½ûûȨ grant select on jishen.v$UserInfo to test1E,RDRNO,LOGTYPE,LOGDATE,LOGSTAMP,PARENTID) AS SELECT LOG.ID,HLD.BARCODE,RED.RDRNO,LOGTYPE,LOGDATE,LOGSTAMP,PARENTID from lib_cir_log log inner join lib_holdings hld on log.hldid=hld.id inner join lib_cir_reader red on LOG.RDRID = RED.IDRAPHY bib on hld.bibid = bib.id4 ӱM@jishenORCL--v$UserInfo CREATE OR REPLACE FORCE VIEW v$UserInfo (rdrno,NAME,RDRFLD1,RDRFLD2,RDRFLD3,RDRFLD4,OTHERNO1,OTHERNO2) AS SELECT rdrno,NAME,RDRFLD1,RDRFLD2,RDRFLD3,RDRFLD4,OTHERNO1,OTHERNO2 FROM lib_cir_reader WITH READ ONLYib_holdings hld on log.hldid=hld.id inner join lib_cir_reader red on LOG.RDRID = RED.IDRAPHY bib on hld.bibid = bib.id"αM@jishenORCLgrant select on jishen.UserInfo to test1u& ӱM@jishenORCL--v$BookInfo CREATE OR REPLACE FORCE VIEW v$BookInfo (barcode,title,author,CONTENT,publish,isbn,CLASSNO,status,MEDIATYPE,SENDDATE,LOCATION,CALLNO) AS SELECT barcode,title,author,CONTENT,publish,isbn,CLASSNO,hld.status,MEDIATYPE,SENDDATE,LOCATION, substr(hld.CALLNO,0,1) from lib_holdings hld inner join LIB_BIBLIOGRAPHY bib on hld.bibid = bib.id ӱM@jishenORCL--v$BorrowRecord CREATE OR REPLACE FORCE VIEW v$BorrowRecord (ID,BARCODE,RDRNO,LOGTYPE,LOGDATE,LOGSTAMP,PARENTID) AS SELECT LOG.ID,HLD.BARCODE,RED.RDRNO,LOGTYPE,LOGDATE,LOGSTAMP,PARENTID from lib_cir_log log inner join lib_holdings hld on log.hldid=hld.id inner join lib_cir_reader red on LOG.RDRID = RED.IDRAPHY bib on hld.bibid = bib.id ӱM@jishenORCLgrant select on jishen.v$BookInfo to test1|O ӱM@jishenORCLgrant select on jishen.v$BorrowRecord to test1 ӱM@jishenORCLgrant connect,create synonym to test1@رM@test1ORCLcreate synonym UserInfo for jishen.v$UserInfoaرM@test1ORCLcreate synonym BookInfo for jishen.v$BookInfo:رM@test1ORCLcreate synonym BorrowRecord for jishen.v$BorrowRecordN@test1ORCLselect * from BorrowRecordlO@jishenORCLselect * from LIB_PER_ORDER ty"N@test1ORCLselect * from UserInfoordM@test1ORCLselect * from BookinfozN@test1ORCLselect * from BookInfo0R%8q@FRXXFRXXselect * from M_TRANSFORM_TAG where book_id ='210366'EeO@FRXXFRXXselect * from M_SPECIAL_TAG tOgO@FRXXFRXXselect * from M_TRANSFORM_TAG_BAK t)djO@FRXXFRXXselect * from M_TRANSFORM_TAG_INVENTORY_REC tE:O@FRXXORCLselect * from M_TRANSFORM_TAG tuׁ-O@FRXXORCLSELECT * FROM M_TRANSFORM_TAGP@test1ORCLSELECT b.* FROM BookInfo bAGdr1O@FRXXJISHENSELECT * FROM M_TRANSFORM_TAG%%<6O@FRXXFRXXselect count(*) from M_TRANSFORM_TAG t where BOOK_ID='1705622'7*q"e@JISHENJISHENselect * from PAR_SYS_SUBMENU tt)őpn@FRXXFRXXselect * from M_TRANSFORM_TAG where book_id ='007734'?6O@FRXXFRXXselect count(*) from M_TRANSFORM_TAG t where BOOK_ID='05030049'UA6O@FRXXFRXXselect count(*) from M_TRANSFORM_TAG t where BOOK_ID='061619'C6O@FRXXFRXXselect count(*) from M_TRANSFORM_TAG t where BOOK_ID='061618'mx6O@FRXXFRXXSELECT * FROM M_TRANSFORM_TAGP@test1ORCLSELECT rs.* FROM ( SELECT ROWNUM rn, temp.* FROM ( SELECT b.* FROM BookInfo b) temp ) rs WHERE rs.rn >= 4 and rs.rn <= 16~1P@test1ORCLSELECT rs.* FROM ( SELECT ROWNUM rn, temp.* FROM (SELECT b.* FROM BookInfo b) temp ) rs WHERE rs.rn >= 4 and rs.rn <= 16;YyR@test1ORCLselect * from bookInfo where title = 'ҳгϢ')":R@test1ORCLselect b.* from bookinfo b where b.barcode = '023067'l!BR@test1ORCLselect b.senddate from bookinfo b{XV@FRXXFRXXselect * from m_Transform_Tag where book_id = '061781'gOR@test1ORCLselect b.mediatype from bookinfo b\SR@test1ORCLselect b.* from bookinfo b8V@FRXXORCLSELECT * FROM M_TRANSFORM_TAG WHERE BOOK_PLACE IS NOT NULLuGV@FRXXORCLselect * from m_transform_tag where book_id='021557'Ke@FRXXFRXXselect * from m_transform_tagIWe@JISHENJISHENselect * from LIB_PAGE_CONFIG tr^e@JISHENJISHENselect * from LIB_HOLDINGS t where barcode='023334'fe@JISHENJISHENselect * from LIB_ACQ_BOOKSELLER t e@JISHENJISHENselect * from PAR_CIR_GETGIFT t̖ne@JISHENJISHENselect * from PAR_SYS_LOCATION tHbe@JISHENJISHENselect * from LIB_READER_COUNT t&ae@JISHENJISHENselect * from LIB_PER_DETAIL_CHECK tae@JISHENJISHENselect * from LIB_PER_ORDER tHECK t%Y f@JISHENJISHENselect * from LIB_HOLDINGS tY te@JISHENJISHENselect * from LIB_BOOKCLASS ttzL)e@JISHENJISHENselect * from PAR_CAT_TEMPLATE t -e@JISHENJISHENselect * from PAR_CIR_CIRRULE tx&/e@JISHENJISHENselect * from PAR_CIR_DELAY ttه/e@JISHENJISHENselect * from PAR_CIR_DOCTYPE t/e@JISHENJISHENselect t.*, t.rowid from PAR_CIR_GETGIFT toض0e@JISHENJISHENselect * from PAR_CIR_LOANRULE tˣ1e@JISHENJISHENselect * from PAR_CIR_READERFIELD td`12e@JISHENJISHENselect * from PAR_CIR_READERTYPE tf|3e@JISHENJISHENselect * from PAR_CAT_REPEAT tE tJve@JISHENJISHENselect * from PAR_CIR_SPECIAL tae@JISHENJISHENselect * from LIB_PER_CHECK t{e@JISHENJISHENselect * from PAR_CAT_BARCODE t\,e@JISHENJISHENselect * from PAR_CAT_FOURCORNER t tMI e@JISHENJISHENselect * from TOAD_PLAN_TABLE t+!e@JISHENJISHENselect * from PAR_SYS_SUBSYSTEM tg#e@JISHENJISHENselect * from PAR_SYS_SCHEDULEDTASK tH$e@JISHENJISHENselect * from PAR_SYS_RULELOCATION t2$e@JISHENJISHENselect * from PAR_SYS_OPERLOCATION td%e@JISHENJISHENselect * from PAR_SYS_OPERATOR t%e@JISHENJISHENselect * from PAR_SYS_MENU t[B'e@JISHENJISHENselect * from PAR_PER_FREQUENCY ti'e@JISHENJISHENselect * from PAR_PER_PERTYPE tM(e@JISHENJISHENselect * from PAR_CAT_Z3950 ta4)e@JISHENJISHENselect * from PAR_CAT_SUBFLDHINT t Q4e@JISHENJISHENselect * from LIB_CIR_BONUSLOG t+e@JISHENJISHENselect * from PAR_CAT_INDICATORHINT t.-e@JISHENJISHENselect * from PAR_CIR_AUTOCODE tQ[0e@JISHENJISHENselect * from PAR_CIR_GIFT t 65e@JISHENJISHENselect * from LIB_CIR_CURFINE t !8e@JISHENJISHENselect t.*, t.rowid from LIB_CIR_LOG t  WB9e@JISHENJISHENselect * from LIB_CIR_LOG t ۋ@e@JISHENJISHENselect * from LIB_CIR_PECCANCY ta+Ge@JISHENJISHENselect * from LIB_CIR_RDRINDEX t6uHe@JISHENJISHENselect t.*, t.rowid from LIB_CIR_RDRSUMMARY t-Ie@JISHENJISHENselect * from LIB_CIR_READERINFO tIe@JISHENJISHENselect * from LIB_CIR_READER tKe@JISHENJISHENselect * from LIB_CIR_RESERVE t9Le@JISHENJISHENselect * from LIB_CIR_SPELOAN t-~Le@JISHENJISHENselect * from LIB_CIR_WEBREADER tU-Me@JISHENJISHENselect * from LIB_COM_CONFIG tMe@JISHENJISHENselect * from LIB_HLDLOG t&f@JISHENJISHENselect * from LIB_ACQ_ALLOCATION tWe@JISHENJISHENselect * from LIB_PER_ALLOCATION teZe@JISHENJISHENselect * from LIB_ACQ_COLLECTBIB_IDX tN9`e@JISHENJISHENselect * from LIB_PER_BIND t NLbe@JISHENJISHENselect * from LIB_SYSLOG t!`0ce@JISHENJISHENselect * from LIB_SYS_OPLOG t"=de@JISHENJISHENselect * from LIB_TITLE_NUMBER t#kme@JISHENJISHENselect * from OPAC_BOOKCASE t$Ѱe@JISHENJISHENselect * from LIB_BIBLIOGRAPHY t'7g@FRXXJISHENselect * from m_Transform_Tag where book_id = '201172',d|n@FRXXFRXXselect count(*) from M_TRANSFORM_TAG t/%n@FRXXFRXXselect count(*) from M_TRANSFORM_TAGook_id ='210366'2q@FRXXFRXXSELECT * FROM M_TRANSFORM_TAG WHERE BOOK_ID ='211643'4Ӱh}@FRXXFRXXselect * from M_TRANSFORM_TAG where book_id ='220021'3dz}@FRXXFRXXselect * from M_TRANSFORM_TAG t59)}@FRXXFRXXselect * from M_TRANSFORM_TAG where book_id ='220319'6}@FRXXFRXXselect * from M_TRANSFORM_TAG7}@FRXXFRXXselect * from M_TRANSFORM_TAG where book_id like '%%22%%'