Are ROWNUM and ROWID the same column?
No. In Oracle DBMS, ROWNUM and ROWID are pseudocolumns that can be accessed in SQL queries, but they aren’t the[…]
Read more
Author: Database Tips
Using a recursive query to create a list of dates
In enterprise database systems, one may commonly find business events (e.g. sales, revenue, etc) associated to dates or months. In[…]
Read more
Filtering data in SQL using Where and Having
The Where clause is one of the mostly commonly used clauses in the SQL language. On the other hand, the[…]
Read more
Getting date and time parts from DateTime and SmallDateTime fields
Microsoft SQL Server supports several data types that can be used to store dates and times. Although some of them[…]
Read more
Database Users and Schemas – concepts and tricks
There is some confusion when dealing with some users and schemas. Some DBMS support several schemas per database, while other[…]
Read more
ORA-01033: ORACLE initialization or shutdown in progress
If you get ORA-01033 error, it means that the Oracle instance you are accessing is being started or shutdown. Then,[…]
Read more
Split brain in Oracle RAC?
In Oracle Real Application Clusters (RAC), two or more instances of an Oracle DBMS manage a single database. It means[…]
Read moreWelcome to Database Tips.Net
Database Tips.net aims to be a useful repository for DBMS users of all skill levels. We presente database tips and[…]
Read more