Ask the Experts
Ask the Experts
-
VARCHAR2 vs. NUMBER
What is the correct circumstance to store a numeric string as VARCHAR2 vs. NUMBER? The response I have received before is to store all numeric strings as VARCHAR2 unless the intention is to manipulate the field mathematically; but no reason has ... 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
-
Alternative to LEFT OUTER JOIN?
-
How do I copy an Oracle DB from one server to another?
-
Assertions
-
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
-
Telling EXECUTE IMMEDIATE to commit
-
DIRECT=Y versus DIRECT=N when importing
-
How to validate zip code, city, and state code
-
Inserting the '&' symbol in a string
-
FIRST N rows, TOP N rows, LAST N rows, BOTTOM N rows...
-
Age constraint on a date column
-
COALESCE on three columns
-
Getting a row number in a group
-
What does SELECT 1 accomplish?
-
Closest date before or after a given date
-
Checking if row is locked before using it in a procedure
-
Assignment operators explained
-
How can I use INSERT INTO to copy an entire table into another?