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.
at

2 comments:

  1. AnonymousMonday, 14 August, 2017

    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.

    kudos

    ReplyDelete
  2. Byte64Tuesday, 15 August, 2017

    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.

    Flavio

    ReplyDelete

I appreciate your comment however bear in mind that I might not have the time to reply soon.
Normally I do not reply to all comments but I am glad if you found something useful or if you learned something new, in that case I strongly encourage you to promote the article with the +1 google button.
Flavio