Skip to Main Content

Programming Languages & Frameworks

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Best DB solution

unknown-3181937Mar 9 2016 — edited Mar 9 2016

As T 20 World cup has already begin in India from 8 March 2016 and 16 teams participating in the event . the developers who are finding it hard to manage their website based on Databases , such as T20 WC 2016 , must use Oracle cloud Database for better Flexibility as the flood of traffic can damage your site. one must not take risk in this sense . thanks

Comments

InoL

That is not how APEX works. When you upload a csv file, you can either use the Data Load Wizard or your own process to parse and load the data in the file using APEX_DATA_PARSER.
Oracle Application Express 18: Creating a Data Load Wizard for Your Application (0 Bytes)
APEX_DATA_PARSER : Convert simple CSV, JSON, XML and XLSX data to rows and columns. (0 Bytes)
SQLLoader would typically run on the database server to load a file on the database server. I don't think that is what you are looking for.

User_C0JD6

SQLLoader would typically run on the database server to load a file on the database server. I don't think that is what you are looking for.

this is what i was after tbh. Apex accepting the CSV file as an upload to a director and sql loader getting kicked off. But I’m guessing it will have to be a combination of files uploaded to a directory and a continuous daemon checking for new files and the daemon kicking off the sql loader

AndyH

If you don't want to process the file (using APEX_DATA_PARSER, your own CSV processing, etc.) you could write the uploaded blob to the database file system and then access it as an external table.

User_C0JD6

Thank you Andy and Inoll

InoL

Apex accepting the CSV file as an upload to a director and sql loader getting kicked off.
That seems a bit strange: upload the file to the database (that is what APEX does), write the file to a database directory and then load the file back into the database. I think it is so much easier to skip the part of writing and reading the file from a database directory.
If you really want to do that, I agree with AndyH: access it as an external table, don't use SQLLoader.

1 - 5

Post Details

Added on Mar 9 2016
0 comments
90 views