Results 1 to 10 of 10
  1. #1
    Join Date
    Dec 2010
    Location
    Leipzig (Germany)
    Posts
    12

    Question Unanswered: export with Application Express

    Hello,

    in Oracle Application Express can be export the contents of the tables in txt files. What kind of a command is use? I would like him to use into a self-written program.

    the menu:
    Home> Utilities> Data Load / unload> Discharge> Unload As text

  2. #2
    Join Date
    Feb 2004
    Location
    Chennai
    Posts
    53
    -Mathan
    For a quick pocket reference of oracle refer http://pocketoracle.blogspot.com/

  3. #3
    Join Date
    Dec 2010
    Location
    Leipzig (Germany)
    Posts
    12
    Yes. This is.
    Unloading Data

    You can use the Unload page to export the contents of a table to a text file or XML document.

    Topics in this section include:

    *

    Unloading a Text File
    *

    Unloading to an XML Document

    See Also:
    "Choosing the Right Import/Export/Load/Unload Option"
    Unloading a Text File

    Use the Unload to Text Wizard to export the contents of a table to a text file. For example, you could export an entire table to a comma-delimited file (.csv).

    To unload a table to a text file:


    1.

    On the Workspace home page, click the Utilities icon.
    2.

    Click Data Load/Unload.
    3.

    Click Unload.
    4.

    Click Unload To Text.

    The Unload to Text Wizard appears.
    5.

    Follow the on-screen instructions.

    You select the schema and choose the table and columns to be exported. Additionally, you can specify the type of separator to be used to separate column values and also whether column text strings are identified using single or double quotation marks.
    Unloading to an XML Document

    Use the Unload to XML Wizard to export the contents of a table to an XML document adhering to the Canonical XML specification.
    I want to import the data into a PostgreSQL database. What a command uses Application Express in this "Unloading"?

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Why do you care?
    You can use the Unload page to export the contents of a table to a text file or XML document.
    Bold is what you get as a result. I guess that you should care about how to "import" a text or XML (created by Apex) file into PostgreSQL.

  5. #5
    Join Date
    Dec 2010
    Location
    Leipzig (Germany)
    Posts
    12
    I am writing a thesis on database migration. Due to the completeness, I will include this command.

  6. #6
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Oh, I see ...

    I wouldn't know the answer. Perhaps you could ask on Oracle Technology Network Apex forum; I know that some people who actually develop Apex visit that forum, so - you might get the information you are looking for.

  7. #7
    Join Date
    Dec 2010
    Location
    Leipzig (Germany)
    Posts
    12
    I can not log into the forum. There is always a mistake. I use letters and numbers, and more than 8 characters. Nevertheless, to say it again and again that something is wrong with my password.

  8. #8
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    I can login; no problem at all.

    Go to About your Oracle.com account page; search for "ORACLE.COM LOGIN FAQ's" and follow the link here:
    What if I’m getting an ‘Invalid Username’ error message?

    Please submit a Help Request so that we can assist you in accessing your account.
    Best of luck!

  9. #9
    Join Date
    Dec 2010
    Location
    Leipzig (Germany)
    Posts
    12
    Is there perhaps packages that can make this unloading?

  10. #10
    Join Date
    Jun 2011
    Posts
    1
    I am writing a thesis on database migration.
    Last edited by careboy; 06-15-11 at 12:32.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •