Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Connor McDonald

    Generate password protected file using UTL_FILE

    I have been working on a project to password protect the files generated by Oracle forms and reports. Since this will only be for internal users, I have used PDFUSER, PDFOWNER utilities given by Oracle. The next tasks is to password protect the files generated by UTL_FILE. I trie...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Downloading old oracle software

    I need oracle 8i enterprise edition and Devloper 6i can u teel me the links for them to download I need them very much ...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    RMAN CAPABILITIES

    Hi Tom, good morning My question is very clear and generic, and very important for me due to a current discussión in my team: We have a database in the followint situation, the worst scenario, I guess: - standalone (no RAC, no Dataguard) - Only one disk with all inside: data, fla...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    XMLTYPE returning unknown special character

    Hello Sir, We're using Oracle Database 19C Enterprise edition. We're getting a XML tag in Varchar2 format. Then we're using XMLTYPE to convert that to XML. However, incase when there's special character in the XML tag it's giving a unknown special character in the output. What ca...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Problem with loading data from XML decimal point with german nls-settings

    -- Settings select banner from v$version; --Oracle Database 23c Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free select * from v$nls_parameters where parameter in ('NLS_NUMERIC_CHARACTERS','NLS_TERRITORY','NLS_LANGUAGE'); -- NLS_LANGUAGE GERMAN 3 -- NLS_TERRITORY
    #MISC#
    #ACTIONS#

Upcoming Live Sessions

Upcoming Ask TOM Live report