Tuesday, July 31, 2007

Apex sVista #2

I just found out that column FILE_NAME in APEX_WORKSPACE_FILES view (Apex 3.0.0) is mostly empty because the it maps to column TITLE of the underlying table WWV_FLOW_FILE_OBJECTS$.

The good news is that in the latest version of Oracle Application Express (3.0.1), this issue seems to have been solved, but unfortunately i could not check the actual source yet, i could only compare the results of similar queries.

Practically speaking, if you need a list of names of files stored in Apex repository and you haven't migrated to Apex 3.0.1, then you are better off using view WWV_FLOW_FILES, which is available through all Apex versions and contains not only the files associated with an application, but also the spare ones.


Anonymous said...

I really like your blog.. very nice colors & theme.
Did you design this website yourself or did you hire someone to do
it for you? Plz reply as I'm looking to create my
own blog and would like to know where u got this from.


Byte64 said...

Ahaha, thank you for the good joke ;-)

It looks awful, when I'll be in a very good mood may be I'll spend a couple of hours searching for a better template.

Have a nice day.


yes you can!

Two great ways to help us out with a minimal effort. Click on the Google Plus +1 button above or...
We appreciate your support!

latest articles