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...

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...

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...

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

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