Problem solve
Get help with specific problems with your technologies, process and projects.
Problem solve
Get help with specific problems with your technologies, process and projects.
Can a dimension table be a fact table for another data mart?
Find out if a dimension table can be a fact table for another data mart -- and get an explanation of the answer. Continue Reading
What is electronic vaulting?
Electronic vaulting usually fits between tape backup and disk mirroring as part of an overall data protection plan. Continue Reading
The ETL process and MySQL
Get advice on the ETL process and ETL tools for transforming raw data in MySQL. Continue Reading
-
What are the benefits of a conceptual data model?
Learn the functions and potential benefits of a conceptual data model, from data modeling expert Pete Stiglich. Continue Reading
Data mining tools: Advantages and disadvantages of implementation
Learn the advantages and disadvantages of data mining tools and of implementing data mining technology. Continue Reading
LOB tables missing with exp/imp move of schema
I have a problem when moving a schema using exp/imp. After import, the tables with LOBs are missing.Continue Reading
How to estimate your data deduplication ratio
This tip details the factors that influence data deduplication ratio (the ratio of data before deduplication to the amount of data after deduplication), so you can estimate the data deduplication ratio you can reasonably expect to achieve.Continue Reading
How to increase SGA_MAX_SIZE in Oracle
How to increase SGA_MAX_SIZE in Oracle? I got the error "ORA-03113: end-of-file on communication channel" during startup.Continue Reading
Employees with the same first and last names in SQL
How do I SELECT a list of employees who have the same last and first name in SQL?Continue Reading
When will support for Oracle 9i be discontinued?
When will general support for Oracle 9i be discontinued?Continue Reading
-
Sorting a clob column
I'm trying to sort a column type asc as well as desc. I'm able to sort the clob column desc but not able to sort it asc. Can you please help me out?Continue Reading
Oracle vs. Sybase: 10 reasons to use Sybase on Linux
Despite its fall from market leadership, Sybase is still a strong enterprise offering, says database consultant Dr. Mich Talebzadeh. In this tip, he gives 10 reasons why Sybase on Linux bests other databases, particularly Oracle.Continue Reading
ON DELETE RESTRICT
I would like to know where we use DELETE RESTRICT?Continue Reading
Multiple instances on a single database
Is it possible for Oracle to have parallel servers (single database, multiple instances)? Is it impossible to have the inverse (that is, multiple databases, single instance)?Continue Reading
What is the difference between DB2 UDB and DB2 OS/390?
Database expert Craig Mullins explains the differences between DB2 UDB and DB2 OS/390. He begins by clarifying that the two are comprised of completely different code bases.Continue Reading
Purpose of roll forward and roll backward
What are rolling forward and rolling backward in backup and recovery?Continue Reading
ORA-12801 and ORA-01652 errors on running query
PL/SQL to display all tables
Merging datasets with NULL values
A MERGE may appear to work properly, but it's important you check your target dataset to make sure it does. This tip explains why and how.Continue Reading
Telling EXECUTE IMMEDIATE to commit
How to validate zip code, city, and state code
FIRST N rows, TOP N rows, LAST N rows, BOTTOM N rows...
COALESCE on three columns
Age constraint on a date column
Getting a row number in a group
Checking if row is locked before using it in a procedure
Assignment operators explained