oracle临时表

-- Create tablecreate global temporary table OBMS_TERM_BOOKVIEW(  BOOK_ID      NUMBER,  BOOK_NAME    VARCHAR2(100),  BOOK_AUTHOR  VARCHAR2(150),  BOOK_PRESS   VARCHAR2(150),  BOOK_PRICE   NUMBER,  BOOKTYPE_NAME    VARCHAR2(20),  BOOK_DESC    VARCHAR2(1000),  BOOK_PICTURE VARCHAR2(800),  BOOK_STOCK   NUMBER,  BOOK_TAG     VARCHAR2(100),  BOOK_VISIT   NUMBER,  discCount    NUMBER)on commit preserve rows;