Ask The Oracle Masters

Recently Answered

	Best 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...
	Between 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...
	redo 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------------------------------------------------...
	Compare 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...
	maximum 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 ...