Edit C:\Users\Administrator\AppData\Roaming\PLSQL Developer\PLSRecall.dat
? ??G?jishen ORCL select * from LIB_PAGE_CONFIG t ? ??G?jishen ORCL select * from LIB_COM_CONFIG t ??/?jishen ORCL CREATE 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 255 ?6,/?jishen ORCL CREATE 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 # ??/?jishen ORCL CREATE INDEX lib_bib_title_idx ON lib_bibliography(title) % ;??/?jishen ORCL CREATE INDEX lib_bib_author_idx ON lib_bibliography(author) ' ??/?jishen ORCL CREATE INDEX lib_bib_classno_idx ON lib_bibliography(classno) ) ?/?jishen ORCL CREATE INDEX lib_bib_SUBJECT_idx ON lib_bibliography(SUBJECT) + g??/?jishen ORCL CREATE INDEX lib_bib_ORDERNO_idx ON lib_bibliography(ORDERNO) - ??/?jishen ORCL CREATE INDEX lib_bib_UNIFIEDNO_idx ON lib_bibliography(UNIFIEDNO) / ??/?jishen ORCL CREATE INDEX lib_bibidx_bibid_idx ON lib_biblios_index(bibid) NO) 1 R?/?jishen ORCL CREATE INDEX LIB_BIBLIOS_INDEX_CODE_VALUE ON LIB_BIBLIOS_INDEX(TYPE,VALUE) ??/?jishen ORCL drop index lib_bib_isbn_idx EX_CODE_VALUE ON LIB_BIBLIOS_INDEX(TYPE,VALUE) ! 5??/?jishen ORCL CREATE INDEX lib_bib_isbn_idx ON lib_bibliography(isbn) " A ?/?jishen ORCL drop index lib_bib_title_idx ON lib_bibliography(isbn) $ ??/?jishen ORCL drop index lib_bib_author_idx ON lib_bibliography(title) & ]?/?jishen ORCL drop index lib_bib_classno_idx ON lib_bibliography(author) ( ??/?jishen ORCL drop index lib_bib_SUBJECT_idx x ON lib_bibliography(classno) * %/?/?jishen ORCL drop index lib_bib_ORDERNO_idx x ON lib_bibliography(SUBJECT) , s??/?jishen ORCL drop index lib_bib_UNIFIEDNO_idx ON lib_bibliography(ORDERNO) . ? ?/?jishen ORCL drop index lib_bibidx_bibid_idx dx ON lib_bibliography(UNIFIEDNO) 0 ??/?jishen ORCL drop index LIB_BIBLIOS_INDEX_CODE_VALUE _biblios_index(bibid) b 2??/?jishen ORCL comment 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?/?jishen ORCL drop index SPELOAN_BIBID_IDX CIAL.SPETYPE is '1????2????3?????' g ?h?/?jishen ORCL /*==============================================================*/ /* 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) ) h ?j?/?jishen ORCL /*==============================================================*/ /* Index: SPELOAN_BIBID_IDX */ /*==============================================================*/ create index SPELOAN_BIBID_IDX on LIB_CIR_SPELOAN ( BIBID ASC ) i ?k?/?jishen ORCL CALL JISHEN.HANDLESEQ('LIB_CIR_SPELOAN') =======================*/ /* Index: SPELOAN_BIBID_IDX */ /*==============================================================*/ create index SPELOAN_BIBID_IDX on LIB_CIR_SPELOAN ( BIBID ASC ) j ?l?/?jishen ORCL delete from PAR_SYS_SUBMENU where id in (6308) k ?l?/?jishen ORCL Insert into PAR_SYS_SUBMENU (ID, NAME, URL, ICONCLS, MODULECODE, MENUID, SHOWLEVEL) Values (6308, '??????', 'cir_special.jsp', 'gear', 'par', 6300, 0) l ?l?/?jishen ORCL delete from PAR_SYS_MENU where id in (4250) RL, ICONCLS, MODULECODE, MENUID, SHOWLEVEL) Values (6308, '??????', 'cir_special.jsp', 'gear', 'par', 6300, 0) m ?m?/?jishen ORCL Insert into PAR_SYS_MENU (ID,TITLE, MODULECODE) Values (4250, '????','cir') n ??/?jishen ORCL delete from PAR_SYS_SUBMENU where id in (4251) ODE) Values (4250, '????','cir') o v6n?/?jishen ORCL Insert into PAR_SYS_SUBMENU (ID, NAME, URL, ICONCLS, MODULECODE, MENUID, SHOWLEVEL) Values (4251, '????', 'cirspeloan.jsp', 'vcard-o', 'cir', 4250, 0) p ?n?/?jishen ORCL delete from PAR_SYS_SUBMENU where id in (4252) ICONCLS, MODULECODE, MENUID, SHOWLEVEL) Values (4251, '????', 'cirspeloan.jsp', 'vcard-o', 'cir', 4250, 0) q ??/?jishen ORCL Insert into PAR_SYS_SUBMENU (ID, NAME, URL, ICONCLS, MODULECODE, MENUID, SHOWLEVEL) Values (4252, '????', 'registersperead.jsp', 'server', 'cir', 4250, 0) r LTo?/?jishen ORCL delete from PAR_SYS_SUBMENU where id in (4408) ICONCLS, MODULECODE, MENUID, SHOWLEVEL) Values (4252, '????', 'registersperead.jsp', 'server', 'cir', 4250, 0) s ?o?/?jishen ORCL Insert into PAR_SYS_SUBMENU (ID, NAME, URL, ICONCLS, MODULECODE, MENUID, SHOWLEVEL) Values (4408, '??????', 'exp_rdr_speloanlist.jsp', 'list', 'cir', 4400, 0) t #p?/?jishen ORCL delete from PAR_SYS_SUBMENU where id in (4509) ICONCLS, MODULECODE, MENUID, SHOWLEVEL) Values (4408, '??????', 'exp_rdr_speloanlist.jsp', 'list', 'cir', 4400, 0) u #p?/?jishen ORCL Insert into PAR_SYS_SUBMENU (ID, NAME, URL, ICONCLS, MODULECODE, MENUID, SHOWLEVEL) Values (4509, '??????', 'sta_rdr_speloancount.jsp', 'bar-chart', 'cir', 4500, 0) ~ h(?G?jishen ORCL select * from LIB_BIBLIOS_INDEX t D, NAME, URL, ICONCLS, MODULECODE, MENUID, SHOWLEVEL) Values (4509, '??????', 'sta_rdr_speloancount.jsp', 'bar-chart', 'cir', 4500, 0) \ X2)?/?jishen ORCL comment 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) ) ] ?*?/?jishen ORCL /*==============================================================*/ /* 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+?/?jishen ORCL DROP SEQUENCE OPAC_MYBOOKSHELF_SEQ =============================*/ /* Index: MYBOOKSHELF_RDRID */ /*==============================================================*/ create index MYBOOKSHELF_RDRID on OPAC_MYBOOKSHELF ( RDRID ASC ) _ ?+?/?jishen ORCL CREATE SEQUENCE OPAC_MYBOOKSHELF_SEQ START WITH 1 MAXVALUE 1000000000000000000000000000 MINVALUE 1 NOCYCLE CACHE 20 NOORDER ==============================================================*/ create index MYBOOKSHELF_RDRID on OPAC_MYBOOKSHELF ( RDRID ASC ) ` ?`?/?jishen ORCL drop table PAR_CIR_SPECIAL cascade constraints ITH 1 MAXVALUE 1000000000000000000000000000 MINVALUE 1 NOCYCLE CACHE 20 NOORDER Y ?)&?/?jishen ORCL drop index MYBOOKSHELF_RDRID ELF_SEQ START WITH 1 MAXVALUE 1000000000000000000000000000 MINVALUE 1 NOCYCLE CACHE 20 NOORDER J ?7,?/?jishen ORCL /*==============================================================*/ /* 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 ?=?/?jishen ORCL comment on column LIB_CIR_BLACKLIST.BCVALUE is '???' Q ??/?jishen ORCL CALL JISHEN.HANDLESEQ('LIB_CIR_BLACKLIST') is '???' M ?.?/?jishen ORCL /*==============================================================*/ /* Index: LIB_CIR_BLACKLIST_BCTYPE_VAL */ /*==============================================================*/ create index LIB_CIR_BLACKLIST_BCTYPE_VAL on LIB_CIR_BLACKLIST ( BCTYPE ASC, BCVALUE ASC ) Z ?'?/?jishen ORCL drop table OPAC_MYBOOKSHELF cascade constraints O ;??/?jishen ORCL comment on column LIB_CIR_BLACKLIST.BCTYPE is '?IDCARD' [ ?(?/?jishen ORCL /*==============================================================*/ /* 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) ) a ?b?/?jishen ORCL /*==============================================================*/ /* 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?/?jishen ORCL drop index SPELOAN_RDRID_IDX e :f?/?jishen ORCL drop table LIB_CIR_SPELOAN cascade constraints f -^g?/?jishen ORCL /*==============================================================*/ /* 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?jishen ORCL select count?*? from LIB_BIBLIOGRAPHY t ? ??VG?jishen ORCL select * from LIB_TITLE_NUMBER t y ?u?G?jishen ORCL select * from LIB_ACQ_BOOKSELLER t z ??G?jishen ORCL select * from LIB_ACQ_COLLECTBIB t { ??VG?jishen ORCL select * from LIB_ACQ_ORDER t | ?IE?G?jishen ORCL select * from LIB_ACQ_RECOMMEND t } ??VG?jishen ORCL select * from LIB_BIBLIOGRAPHY t ??VG?jishen ORCL select * from LIB_BOOKCLASS t ? ??VG?jishen ORCL select * from LIB_CAT_INSTITUTIONAL t ? ? 4?G?jishen ORCL select * from LIB_CAT_SUBJECT t ? 7??G?jishen ORCL select * from LIB_CIR_READER t ? Y??G?jishen ORCL select * from LIB_FORMAT_DESIGN t ? F?VG?jishen ORCL select * from LIB_HOLDINGS t ? f??G?jishen ORCL select * from LIB_PER_ALLOCATION t ? by/?G?jishen ORCL select * from LIB_PER_BIND t ? ??VG?jishen ORCL select * from LIB_PER_CHECK t ? #??G?jishen ORCL select * from LIB_PER_DETAIL_CHECK t ? ??O?jishen ORCL select * from LIB_READER_COUNT t ? ?f O?FRXX n JISHEN select * from T_DB_VERSION t T t ? ??VG?jishen ORCL select * from TOAD_PLAN_TABLE t ? ]$?G?jishen ORCL select * from PAR_SYS_SUBSYSTEM t ? g[?VG?jishen ORCL select * from PAR_SYS_SUBMENU t ? ? ?M?jishen ORCL --????????????? grant select on jishen.UserInfo to test1 E,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.ID RAPHY bib on hld.bibid = bib.id ? D? ?M?jishen ORCL --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.ID RAPHY bib on hld.bibid = bib.id ? > ?M?jishen ORCL --????????????? grant select on jishen.v$UserInfo to test1 E,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.ID RAPHY bib on hld.bibid = bib.id ? 4 ?M?jishen ORCL --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 ONLY ib_holdings hld on log.hldid=hld.id inner join lib_cir_reader red on LOG.RDRID = RED.ID RAPHY bib on hld.bibid = bib.id ? "???jishen ORCL grant select on jishen.UserInfo to test1 ? u& ?M?jishen ORCL --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?jishen ORCL --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.ID RAPHY bib on hld.bibid = bib.id ? ? ?M?jishen ORCL grant select on jishen.v$BookInfo to test1 ? |O ?M?jishen ORCL grant select on jishen.v$BorrowRecord to test1 ? ? ?M?jishen ORCL grant connect,create synonym to test1 ? ????test1 ORCL create synonym UserInfo for jishen.v$UserInfo ? a??M?test1 ORCL create synonym BookInfo for jishen.v$BookInfo ? :??M?test1 ORCL create synonym BorrowRecord for jishen.v$BorrowRecord ? ????test1 ORCL select * from BorrowRecord ? l??O?jishen ORCL select * from LIB_PER_ORDER t ? y"?N?test1 ORCL select * from UserInfo ord ? ????test1 ORCL select * from Bookinfo ? z???test1 ORCL select * from BookInfo 0 R%8q?@FRXX FRXX select * from M_TRANSFORM_TAG where book_id ='210366' ? E?eO?FRXX FRXX select * from M_SPECIAL_TAG t ? ?OgO?FRXX FRXX select * from M_TRANSFORM_TAG_BAK t ? )d?O?FRXX FRXX select * from M_TRANSFORM_TAG_INVENTORY_REC t ? E?:O?FRXX ORCL select * from M_TRANSFORM_TAG t ? u??-O?FRXX ORCL SELECT * FROM M_TRANSFORM_TAG ? ??P?test1 ORCL SELECT b.* FROM BookInfo b AG ? dr?1O?FRXX JISHEN SELECT * FROM M_TRANSFORM_TAG ? %%?<6O?FRXX FRXX select count(*) from M_TRANSFORM_TAG t where BOOK_ID='1705622' ? 7*q"??JISHEN JISHEN select * from PAR_SYS_SUBMENU t t ) ??n?@FRXX FRXX select * from M_TRANSFORM_TAG where book_id ='007734' ? ???6O?FRXX FRXX select count(*) from M_TRANSFORM_TAG t where BOOK_ID='05030049' ? U?A6O?FRXX FRXX select count(*) from M_TRANSFORM_TAG t where BOOK_ID='061619' ? ??6O?FRXX FRXX select count(*) from M_TRANSFORM_TAG t where BOOK_ID='061618' ? m??6O?FRXX FRXX SELECT * FROM M_TRANSFORM_TAG ? ????test1 ORCL SELECT rs.* FROM ( SELECT ROWNUM rn, temp.* FROM ( SELECT b.* FROM BookInfo b) temp ) rs WHERE rs.rn >= 4 and rs.rn <= 16 ? ~?1??test1 ORCL SELECT rs.* FROM ( SELECT ROWNUM rn, temp.* FROM (SELECT b.* FROM BookInfo b) temp ) rs WHERE rs.rn >= 4 and rs.rn <= 16 ? ;Y???test1 ORCL select * from bookInfo where title = '???????' ? )"?:??test1 ORCL select b.* from bookinfo b where b.barcode = '023067' ? l?!B??test1 ORCL select b.senddate from bookinfo b ? {X?V?FRXX FRXX select * from m_Transform_Tag where book_id = '061781' ? ?gO??test1 ORCL select b.mediatype from bookinfo b ? \ S??test1 ORCL select b.* from bookinfo b ? ??8V?FRXX ORCL SELECT * FROM M_TRANSFORM_TAG WHERE BOOK_PLACE IS NOT NULL ? uG ?V?FRXX ORCL select * from m_transform_tag where book_id='021557' ? K??e?FRXX FRXX select * from m_transform_tag ?W??JISHEN JISHEN select * from LIB_PAGE_CONFIG t ? ? r^??JISHEN JISHEN select * from LIB_HOLDINGS t where barcode='023334' ? ????JISHEN JISHEN select * from LIB_ACQ_BOOKSELLER t ? ?? ??JISHEN JISHEN select * from PAR_CIR_GETGIFT t ? ????JISHEN JISHEN select * from PAR_SYS_LOCATION t ?Hb??JISHEN JISHEN select * from LIB_READER_COUNT t &???JISHEN JISHEN select * from LIB_PER_DETAIL_CHECK t ????JISHEN JISHEN select * from LIB_PER_ORDER t HECK t % Y? f?JISHEN JISHEN select * from LIB_HOLDINGS t Y t ? ????JISHEN JISHEN select * from LIB_BOOKCLASS t t ? z?)??JISHEN JISHEN select * from PAR_CAT_TEMPLATE t ?-??JISHEN JISHEN select * from PAR_CIR_CIRRULE t x&/??JISHEN JISHEN select * from PAR_CIR_DELAY t t ??/??JISHEN JISHEN select * from PAR_CIR_DOCTYPE t ?/??JISHEN JISHEN select t.*, t.rowid from PAR_CIR_GETGIFT t o?0??JISHEN JISHEN select * from PAR_CIR_LOANRULE t ??1??JISHEN JISHEN select * from PAR_CIR_READERFIELD t d`12??JISHEN JISHEN select * from PAR_CIR_READERTYPE t f|?3??JISHEN JISHEN select * from PAR_CAT_REPEAT t E t ? Jv??JISHEN JISHEN select * from PAR_CIR_SPECIAL t ?a??JISHEN JISHEN select * from LIB_PER_CHECK t ? {? ??JISHEN JISHEN select * from PAR_CAT_BARCODE t ? ?,??JISHEN JISHEN select * from PAR_CAT_FOURCORNER t t ? ?I ??JISHEN JISHEN select * from TOAD_PLAN_TABLE t ? +?!??JISHEN JISHEN select * from PAR_SYS_SUBSYSTEM t ? ??#??JISHEN JISHEN select * from PAR_SYS_SCHEDULEDTASK t ? ?H$??JISHEN JISHEN select * from PAR_SYS_RULELOCATION t ? ?2?$??JISHEN JISHEN select * from PAR_SYS_OPERLOCATION t ? ?d%??JISHEN JISHEN select * from PAR_SYS_OPERATOR t ? ??%??JISHEN JISHEN select * from PAR_SYS_MENU t ? ?B'??JISHEN JISHEN select * from PAR_PER_FREQUENCY t ? i?'??JISHEN JISHEN select * from PAR_PER_PERTYPE t ? M?(??JISHEN JISHEN select * from PAR_CAT_Z3950 t ? a4?)??JISHEN JISHEN select * from PAR_CAT_SUBFLDHINT t Q?4??JISHEN JISHEN select * from LIB_CIR_BONUSLOG t ? ?+??JISHEN JISHEN select * from PAR_CAT_INDICATORHINT t ? ?.-??JISHEN JISHEN select * from PAR_CIR_AUTOCODE t Q?0??JISHEN JISHEN select * from PAR_CIR_GIFT t ?6?5??JISHEN JISHEN select * from LIB_CIR_CURFINE t ?!?8??JISHEN JISHEN select t.*, t.rowid from LIB_CIR_LOG t WB9??JISHEN JISHEN select * from LIB_CIR_LOG t ????JISHEN JISHEN select * from LIB_CIR_PECCANCY t a+???JISHEN JISHEN select * from LIB_CIR_RDRINDEX t 6?H??JISHEN JISHEN select t.*, t.rowid from LIB_CIR_RDRSUMMARY t ?-I??JISHEN JISHEN select * from LIB_CIR_READERINFO t ????JISHEN JISHEN select * from LIB_CIR_READER t ????JISHEN JISHEN select * from LIB_CIR_RESERVE t ?9L??JISHEN JISHEN select * from LIB_CIR_SPELOAN t -~???JISHEN JISHEN select * from LIB_CIR_WEBREADER t U-M??JISHEN JISHEN select * from LIB_COM_CONFIG t ????JISHEN JISHEN select * from LIB_HLDLOG t & ??f?JISHEN JISHEN select * from LIB_ACQ_ALLOCATION t ???JISHEN JISHEN select * from LIB_PER_ALLOCATION t ?eZ??JISHEN JISHEN select * from LIB_ACQ_COLLECTBIB_IDX t N9???JISHEN JISHEN select * from LIB_PER_BIND t NL???JISHEN JISHEN select * from LIB_SYSLOG t ! `0c??JISHEN JISHEN select * from LIB_SYS_OPLOG t " ?=???JISHEN JISHEN select * from LIB_TITLE_NUMBER t # ?m??JISHEN JISHEN select * from OPAC_BOOKCASE t $ ????JISHEN JISHEN select * from LIB_BIBLIOGRAPHY t ' 7????FRXX JISHEN select * from m_Transform_Tag where book_id = '201172' , d?|n?@FRXX FRXX select count(*) from M_TRANSFORM_TAG t / ?%?n?@FRXX FRXX select count(*) from M_TRANSFORM_TAG ook_id ='210366' 2 ???@FRXX FRXX SELECT * FROM M_TRANSFORM_TAG WHERE BOOK_ID ='211643' 4 ?h??@FRXX FRXX select * from M_TRANSFORM_TAG where book_id ='220021' 3 ???@FRXX FRXX select * from M_TRANSFORM_TAG t 5 9)??@FRXX FRXX select * from M_TRANSFORM_TAG where book_id ='220319' 6 ??}?@FRXX FRXX select * from M_TRANSFORM_TAG 7 ? ?}?@FRXX FRXX select * from M_TRANSFORM_TAG where book_id like '%%22%%'
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de