Know Your Rank
DBARepublic.com • 10:00 AM
Rank calculates the rank of a value in a group of values. Rows with equal values receive equal ranking. It computes the rank of each row ret...Read More
Results for >>:::
Oracle Database
SQL Developer Keyboard Shortcuts
DBARepublic.com • 7:33 AM
Mr Junior wants to take shortcuts in his life but he is families are warning those shortcuts will only take him so far. If you take shortcut...Read More
Are you using TRIM Function enough?
DBARepublic.com • 10:07 AM
Recently, I was working on a big project where I needed to find new data by comparing two tables. The number of new data came out pretty hig...Read More
Task Automation
DBARepublic.com • 10:49 AM
In today's IT world, you will hear the word Automation day in day out. What the hell is Automation and how do you do it? Automation is a...Read More
Sql*Loader Optimization
DBARepublic.com • 8:26 AM
SQL*Loader is an Oracle utility to load data into a database. This utility is used for small or bulk data load which is much faster compared...Read More
Indexed Organized Table (IOT)
DBARepublic.com • 3:08 PM
Index data is stored separately from actual table data on a Heap table which Tom calls it heap fashion. Data are stored where next free blo...Read More
Unloading Data
DBARepublic.com • 2:04 PM
Oracle provides Sql*Loader utility and External table object to load data into a database from a flat text, cvs or any file type. Have your...Read More
NOHUP for DBA & Developer
DBARepublic.com • 10:29 PM
NOHUP is a Linux Command to run a job in the background. Why is it important to DBA and developer? NOHUP stands for "No Hang Up" w...Read More
Bulk Collect and FORALL
DBARepublic.com • 12:42 PM
In this article, we will conduct two or more experiments to check the speed of data Insert. Both the experiments will read data from employe...Read More
Analytic Function – Over Partition
DBARepublic.com • 9:54 PM
Analytic Functions compute an aggregate value based on a group of rows. How are they differ from aggregate functions that you are used to u...Read More
Materialized View Refresh Group
DBARepublic.com • 2:23 PM
Refresh Group: A refresh group is a collection of Materialized Views. Why do you need a refresh group? To maintain the database consistency...Read More
Fast Refreshable Materialized View Problem
DBARepublic.com • 7:47 AM
There are things that schools or training center do not teach you about a Materialized View. They only teach you to create and refresh a fas...Read More
Materialized View - Complete Refresh
DBARepublic.com • 8:06 AM
Have you worked with View before? Yes, I mean just a View not a Materialized View. Let’s refresh the concept of a View before learning abo...Read More
Subscribe to:
Posts
(
Atom
)
