Check the trace file for the session. SELECT value FROM v$diag_info WHERE name = 'Default Trace File'; VALUE --- /u01/app/oracle/diag/rdbms/cdb1/cdb1/trace/cdb1_ora_15539.trc 1 row selected. SQL> Perform a 10053 trace of the statement. ALTER SESSION SET EVENTS '10053 trace name ...
Information in this document applies to any platform. Symptoms ORA-918 reported with Row Limiting Clause. The query works fine without the Row Limiting Clause. Test case: Cause Sign In To view full details, sign in with your My Oracle Support account. Register Don't have a My Oracle ...
Reports usages of multiple row limiting clauses in a single query. Example (Microsoft SQL Server): create table foo(a int); select top 1 * from foo order by a offset 10 rows fetch next 20 rows only; The SELECT TOP clause is used to specify that only 1 record must be returned. The ...