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.
Converting from CHAR to DATE datatype
As a time value, I used the CHAR datatype and need to convert to a DATE value while manipulating/computing. How do I use the DATE datatype instead? Continue Reading
Installing 32-bit and 64-bit Oracle on same machine
I have an application that does not support 64-bit Oracle. It needs to run on 32-bit Oracle. Can I install two Oracle engines (32-bit and 64-bit) on the same machine? If so, how can it be done? Continue Reading
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?
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
XML for data architects: Designing for reuse and integration (Chapter 8)
-
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
Find users who have unlimited quota on a tablespace
Here is a query to find users that have unlimited quota on a tablespace.Continue Reading
Telling EXECUTE IMMEDIATE to commit
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