recent
Results for >>::: Oracle Database

Read Only Table

10:00 PM
Ready only table, what the heck is ready only table? Well, it is self explanatory by it's name. This table type allows user to SELECT bu...Read More

Dropping Column

10:23 AM
You all have dropped or added a column to an employee table. How long does that take? couple seconds, or may be milli-seconds. ALTER is DDL ...Read More

RowId Vs Index

9:18 PM
and the winner is dbarepublic... I am kidding right? With this article, we will find out who is the real champion among INDEX and ROWID? M...Read More

Renaming Object

9:02 PM
As the title states, it just re-name from old object name to a new object name. Not all Oracle objects can be re-named easily. Oracle Table,...Read More

Slow DELETE

10:38 PM
No one gets a maintenance window for days. The standard maintenance window is 4 hours or less for most companies. There are however applica...Read More

TNSPING Utility

12:02 PM
TNSPING is an Oracle utility to determine if the listener for a service on an oracle network can be reached successfully. This utility is lo...Read More

IN vs EXISTS

10:00 AM
You all may have used IN, NOT IN, EXISTS, and NOT EXISTS or have seen at one point in their IT career. Many believe SQL keyword IN is simila...Read More
Powered by Blogger.