Subscriber Count


Subscribe to Posts by Email


12c Database : Network enhancements – DEFAULT_SDU_SIZE to 2M

How many you know this structure at first glance, I am sure the old DBA junkies will say what this called immediately, but for those who does not know this diagram is called Network OSI diagram for Oracle and layers between client and database servers and how oracle connects.

Oracle uses different methods […]

12c Database : Limiting rows using fetch clause

Do you want to restrict row results not to display/retrieve fully?

Until 11g, Oracle uses Top -n query method to retrieve top or bottom set of data using rownum, dense, rank etc.

But this has limitation when order is required for that data and also an inline view is required and complex to write.

For […]