Oracle file Export

$ cat Me.sql
Set echo off
Set term off
Set Line pages 0
Set Feedback off
Set Heading off
Set Trimspool on
Spool/aiapp/tungsten/shell/o2m/test.sql
Select ' INSERT into Res_d_mphone (serial_number,moffice_id,code_state_code,busi_type_code,use_type_code,code_type_ Code,stock_id,pool_code,city_code,eparchy_code,province_code,number_source,is_assign,is_prettynum,is_prepare_ Match,is_prepare_open,is_lock,reserve_time,time_in,staff_id,batch_id,remark) VALUES ("' | | serial_number| | "," | | moffice_id| | "," | | code_state_code| | "," | | busi_type_code| | "," | | use_type_code| | "," | | code_type_code| | "," | | stock_id| | "," | | pool_code| | "," | | city_code| | "," | | eparchy_code| | "," | | province_code| | "," | | number_source| | "," | | is_assign| | "," | | is_prettynum| | "," | | is_prepare_match| | "," | | is_prepare_open| | "," | | is_lock| | "," | | reserve_time| | "," | | time_in| | "," | | staff_id| | "," | | batch_id| | "," | | remark| | '); From Res_d_mphone_bak;
Spool off
Set Trimspool off
Set heading on
Set feedback on
Set term on
Set echo on
Exit

Oracle file Export