Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Chris Saxon

    How does the data structure of a compound index in Oracle look like?

    Greetings, How does the data structure of a compound index in Oracle look like? I'm wondering how Oracle is able to use a "skip scan" by using the second entry in a compound index? I know that the first field uses a b-tree structure, but I am unsure how the second field is stored...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Capture user login logout in oracle database

    I got a requirement to capture user login logout timestamp of database in any method like login via application, Sql development tool or any source. the purpose is to track all user login/logout information of database. We tried with logon and log off trigger but issue is log off...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Use UTL_SMTP signed email

    Good Morning. My question is sending signed emails from oracle. We were hoping to utilize an oracle built in functionality but it seems oracle requires a hardcoded passwords. Even oracle support stated I had to hardcode the password. I am coming here because I have been provided ...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    Instead of Trigger

    Hello Tom, What is the practical implementation of Instead of Triggers in the application? Can you provide some practical examples?
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    SqlCLI Apex Export not included Application Audit Informations

    Hi! We have a lot of Apex apps, so we check the LAST_UPDATED_ON value in both the production and dev apps before deploying to production. Like this: select d.APPLICATION_ID , d.APPLICATION_NAME , d.ALIAS , d.OWNER DEV_OWNER , p.OWNER PERP01_OWNER , d.LAST_UPDATED_ON DEV , p.
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours report