While writing the last post about paging queries (can be found here) I checked the 12c new top-n feature.The idea behind this feature is to tell Oracle, in native SQL
While writing the last post about paging queries (can be found here) I checked the 12c new top-n feature.The idea behind this feature is to tell Oracle, in native SQL
In the past few months I had several occasions to use the “rownum” pseudo-column to page a query result set. As we know, a query returns a result set, which
Database Identifiers are basically names of objects in the database, like tables, indexes, etc. There are restrictions about identifiers in Oracle, they can be up to 30 characters, must begin
Many times we need to understand what our server process does. When we run an application flow or in cases we cannot get or analyze a specific query, we turn
Here is a new thing I found out about database processes. If you read my post about listener registration you know about the communication between the database and the listener
This is a post I wrote quite a while ago, and it’s about 11.2 parallel features. It’s a little out dated, now that 12c is out for a while and
As you can probably understand from the title, this is not going to be a regular post (and a bit long as well), as usually my posts are technical. I
Lately I took part in Oracle Real Application Testing Workshop managed by Oracle product management team. I’d like to tell you a little bit about the feature beyond the introduction
Constraint are objects we all know, we use them a lot when creating tables and they allow us to: Keep data integrity at the table level, like disallow null values
Ever used SQL*Loader or temporary tables? Had a problem with file encoding?