Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Chris Saxon

    Problem with the pivot and unpivot functions - is it possible to merge numbers with text?

    Hello everyone, I ask for help to solve a problem with the pivot and unpivot functions. is it possible to merge numbers with text? in the result I would like to add the row of the column ects_cod. Thank you<code>CDS_COD;VALORE;31;30;29;28;27;26;25;24;23;22;21;
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Character set of processed file

    Dear Asktom team,We are processing external tables, where it is agreed that the incoming files are in character set EE8SSWIN1250.Nevertheless, it may happen that the incoming file has a different character set. The file is processed, but the characters are scr
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Transition from signle tenant Multitenant database

    Hi TOM,i have been working with single tenant database from the start 8i upto Database version 11.2 , now i need to work with multitenant database 12c and above. i have installed 19c database, but i am having difficulty moving around (login etc)Can you point s
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Job Scheduling

    Hi Tom,can u tell me that how can i scheduled my procedures execution. for example there is a procedure namely 'abc' i want to execute it at 4'o clock every day. it would by highly appreciated if u provide my any code, or reffer documents etc. in this regard.p
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    sql tuning advisor

    Hi Tom,I am not able to understand one thing, I have two test databases, and separate hardware. It is a Server class installation and Enterprise addition, with all default optimizer settings. In one database say db1, when I am running dbms sqltune advisory it
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours Cards

Free training, how-tos and Q&A with Oracle experts, every month! Learn more