Technical Blog

select * from v$system_event;  -- query to get the oracle system event select * from ( select d.*,rank() over(order by cpu_time desc) rk...

Query to avoid the logical duplicate records .(Technically these records are not duplicate ie: we can avoid records using the distinct ke...

Composite partitioning is a partitioning technique that combines some of the other partitioning methods. The table is initially partitione...