The results of the data query can be exported as CSV or SQL files.
To export data as CSV
1 | Select a view in the User-Defined Data Views log and click the Data button. The results window will display the query results. |
2 | Click the Export As CSV button. |
3 | At the prompt, you can choose to Open or Save the resulting CSV file to your local drive. |
The CSV file will contain the data that is displayed on the results log window. By default, the first 100 lines will be displayed. You can click the Display dropdown (in the upper right corner of the results log window) and choose 200 to display the first 200 lines. When you click Export As CSV, the CSV file will contain the 100 (or 200) lines displayed in the window.
Only the 100 or 200 rows will be exported at a time. You cannot export the entire result of the view (for example, if there are more than 200 rows) in one click. You must export in groups of 200 rows at the maximum and then manually combine the exported results.
To export data as SQL
1 | Select a view in the User-Defined Data Views log and click the Data button. The results window will display the query results. |
2 | Click the Export As SQL button. |
3 | At the prompt, you can choose to Open or Save the resulting SQL file to your local drive. |
This will export your SQL script to create the table required for the data view and the data itself.
Notes on Working with the Oracle Database
|
Oracle Corporation
Primavera Unifier 9.10 • Copyright © 1998, 2012, Oracle and/or its affiliates. All rights reserved.