sql.txt

oracle sql的一些代码

CREATE GLOBAL TEMPORARY TABLE tracing_tmp_8686_table (question_no VARCHAR2(20),delivery_date DATE,license VARCHAR2(22),trancer VARCHAR2(20) , charge_type VARCHAR2(20) ,repair_type VARCHAR2(20) ,remark VARCHAR2(200),input_date DATE , server_adviser VARCHAR2(20),chief_technician VARCHAR2(20),in_mileage NUMBER(10,2),owner_name VARCHAR2(150),deliverer_phone  VARCHAR2(20) ,deliverer_mobile  VARCHAR2(20),vin  VARCHAR2(20) , brand  VARCHAR2(20),series  VARCHAR2(20) ,model  VARCHAR2(20),ro_no CHAR(19),answer_no  VARCHAR2(20), question_content  VARCHAR2(150),answer  VARCHAR2(150),differ  NUMBER(10,2) )  ON COMMIT DELETE ROWS