Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Chris Saxon

    Is it safe to use ROWID to locate a row?

    Hi Tom, I'm looking at a client application which retrieves several columns including ROWID, and later uses ROWID to identify rows it needs to update: update some_table t set col1=value1 where t.rowid = :selected_rowid Is it safe to do so? As the table is being modified, can ROWI...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Chris Saxon

    to_char manipulates DST times ?

    Hello Tom, I have one column INTERVAL_TIME with datatype as TIMESTAMP(0) and stores data in 15 mins interval time. Since there was DST on 13 March 2016 , the interval was store at 1:45 AM and next interval at 3:00 AM. But when i am applying to_char on the column , the result is a...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    External table in a PL/SQL procedure

    Hi Tom – My task: move several dozen text file imports from SQLLDR (on AIX) into callable PL/SQL procedures. The text files are static in structure with daily refreshes of the contents. The contents are loaded into individual tables in our 19c EE database. The solution appeared t...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Running Total

    Hello Sir, Could you give a simple example of running total on emp table FOr example, running total of sum (sal + comm) department wise? thanks
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Maximum number of concurrent sessions in multi instance database

    Hi, We have Oracle 12C on 2 instances. I know GV$license can give maximum number of concurrent sessions since start of instances. But is there a way to get maximum we had accessing the database from both together ? Syed
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours Cards

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