Skip to Main Content

Oracle Developer Tools for VS Code

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!

NLS Masks WIth Extension

User_6BTKCMar 10 2021

Hi All,
Maybe I am just missing something in how the extension works. Here's the situation. In one of the databases I work with (11c in this case) the default NLS Date Format is DD-MON-YY. In the extension if i right click that database and open a new scrap SQL file and do a simple query like:
SELECT some_date_field FROM some_table;
The output comes back in MM/DD/YYYY HH:MI:SS
If I alter session alter session set nls_date_format='YYYY-MM-DD:HH:MI:SS'; or really anything and re-execute the query the results stay in this same format. Is there no way to utilize NLS_DATE_FORMAT in the extension? Maybe some setting I am missing?

This post has been answered by Christian.Shay -Oracle on Mar 10 2021
Jump to Answer

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 10 2021
10 comments
126 views