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.
Multiple rows with same value in one column
I'm doing a search from one table and my goal is to show only the rows with the same value in one of the columns. I am only interested in seeing the rows for all the emp_no that shows more than once. Continue Reading
DELETE WHERE NOT EXISTS
I have two tables, A1 and A2, and they both have a column called SSn. How will I delete a row from table A2 that doesn't exist on A1? Continue Reading
Converting a column from VARCHAR2 to DATE
I need to convert a date column created using data type VARCHAR2 into data type DATE. Is it possible? Continue Reading
-
LEFT OUTER JOIN on more than two tables
Is it possible to perform LEFT OUTER JOIN in more than two tables? If possible, please give me details. Continue Reading
LEFT OUTER JOIN with ON condition or WHERE condition?
I would like your explanation of the difference between a LEFT OUTER JOIN ON condition and a WHERE condition. Continue Reading
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