Data conversion steps for Oracle and FoxPro Databases

Since the Oracle data format is different from the general microcomputer format, Oracle data cannot be directly called. Although Developer 2000, a front-end development tool provided by Oracle, can access Oracle data and has data access interfaces, however, these data formats are not commonly used by computers. (The author uses the Oracle 7.3 database and HP-UNIX system .)

Sometimes, to facilitate business, Oracle data needs to be converted to a microcomputer for processing. Newspapers and Magazines once introduced some methods, but it is troublesome to implement them. After many experiments, to sum up a simple and practical method, only a few general software can convert Oracle data into the data used by the microcomputer *. dbf file.

The procedure is as follows:

1. Use Oracle's sqlplus tool to extract Oracle data:

Select dwdm, dwmc, count from dwjbb where dzrq is NULL; dwdm dwmc countpdy000239 investment enterprise Materials Company Yi Timber Corporation Yi Petrochemical Products Co. Ltd. Yi Materials Company Yi junma yuan Economic Development Corporation Service Company 1112.02pdy000570 meiya Co., Ltd. 8674.72 dwdm dwmc countpdy000829 Yi Xing Development Co., Ltd. company 476.58

Save the above query records to a text file (dwxx. lst) by outputting the redirection command spool, and transmit dwxx. lst to the local hard disk through FTP.

1 2 Next Page

[Content navigation]
Page 1: Data Conversion steps for Oracle and FoxPro Databases	Page 1: Data Conversion steps for Oracle and FoxPro Databases