Technical Blog

Oracle ADF Enterprise Application Development - Made Simple: Successfully As such from the Oracle Certified Associate, Java S...

In ALL_ARGUMENTS table lists the arguments of the procedures and functions that are accessible to the current user In DBA_ARGUMENTS tabl...

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...