Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn more
Paul W's user avatar
Paul W's user avatar
Paul W's user avatar
Paul W
  • Member for 1 year, 2 months
  • Last seen this week
4 votes

How to query in the given order

4 votes

How to locate a procedure in the body of a trigger

3 votes

How to find out when Oracle table statistics became stale?

2 votes

Validate "insert", "update", "delete" in the body of a trigger

2 votes
Accepted

Getting wrong/misleading info related to oracle table index

2 votes

How to clean sysaux table in Oracle 19c SE2

2 votes
Accepted

Oracle - How to find out who is causing LOCKED(TIMED) in user account?

2 votes

How to view data of a failing row in a view

1 vote

Oracle trigger is fired more times then expected

1 vote

DBMS_SCHEDULER running 10 instance of the same job

1 vote
Accepted

rebuild index in Oracle

1 vote

Failing to insert into table getting error: ORA-00600: internal error code, arguments: [ktssinseg2]

1 vote
Accepted

Why is the SYS user granted both the DBA role and the SYSDBA privilege?

1 vote

Can a foreign key refer to a subset of parent table's rows? (Value domain constraint)

1 vote

Query a table with association to itself

1 vote
Accepted

Wrong cardinality estimation after gathering statistics ORACLE

1 vote

SQL breaking my query where there is NULL value

1 vote

How to update table keeping data available to users (Oracle)?

1 vote
Accepted

Oracle Batch Deletion

1 vote

Any way to debug an Oracle Sequence?

1 vote

sqlplus / as sysdba Connected to an idle instance

1 vote

how best to have a record versioning or tracking in relational database?

1 vote

Oracle partition strategy suggestions

1 vote
Accepted

PL/SQL dynamic Index loop based on list variable

0 votes

Does Oracle database server stored runtime dynamic SQL?

0 votes

What is the performance implication of composite index column ordering on inserts?

0 votes
Accepted

Need help with DBMS_COMPRESSION.GET_COMPRESSION_RATIO

0 votes
Accepted

Oracle statement inserting duplicate data

0 votes

How to search text in oracle view

0 votes

How to COPY table privileges dba_sys_privs into different table in Oracle