Skip to Main Content

Ask The Oracle Masters

Recently Answered

Recently Answered Report

Chris SaxonBest way to check for existence based on last event date
Hello,I am trying to find out the best way to include a criteria in a sql to check is the latest event for a user has occurred before a specific date.Below is my table setup and brief descriptionUSER_NP => Parent table listing all users (in origina...
Chris SaxonBetween function not working on varchar2 column
Hi Team,We are facing issue while using Between function in our SQL query. We are trying to use Between function on a column which is of datatype VARCHAR2. Data insert in this column can be alphanumeric as well as numeric, But it seems this function is not wor...
Connor McDonaldredo log in nologging mode
I was trying to understand how redo works in nologging mode. Here is a interesting situation i encountered in XE.<code>SQL> @redo_question.sqlTable dropped.Table created.LOG_MODE------------NOARCHIVELOGStatistics------------------------------------------------...
Connor McDonaldCompare execution performance stats between two PL/SQL procedures
Hi From the past I am only aware of Tom Kyte's Runstats package, which allows comparing some performance metrics across two procedures. I also found that the DBMS_SQLPA package also provides a feature that could help in this kind of scenario.For example once y...
Connor McDonaldmaximum row update at a single go in Oracle DB
Hi,We've near to 6 million records in our database and we want to update one specific column value for all the records.query will be like this: update table_xx set column_xx = '' where column_xxx = '';Is there any limitation in Oracle DB? If we run this query ...

Resources