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.
Using SQL to find the number of Sundays in a month
I want to find out how many Sundays come in any month in SQL. Continue Reading
Regulatory compliance and the DBA: What you need to know
At the top of business executives' minds today is how to meet regulatory compliance and corporate governance rules. New laws are changing the way companies collect, retain and manage information. DBAs need to understand what is happening in the ... Continue Reading
Performance tuning a RAC implementation
The performance tuning methodology for an Oracle Real Application Clusters (RAC) configuration can be broadly categorized into these seven steps. Continue Reading
-
Consistent vs. inconsistent backup
What are consistent and inconsistent backups? Continue Reading
Grid or RAC?
Which is better, RAC or 10g Grid? When to use both or either of these? What are the steps to install 10g Grid? Does it require a special license? Continue Reading
ON DELETE RESTRICT
I would like to know where we use DELETE RESTRICT?Continue Reading
ORDER BY a specified sequence
I'm trying to create an SQL query with the IN clause where I give the IDs to match. Now I want the order of these records to be the same as I give in the IN clause. But it's not happening.Continue Reading
Check if date is greater than 2000 in PL/SQL
How to check if the date is greater than the year 2000 in PL/SQL?Continue Reading
Got CRM? 10 questions to ask before you buy
CRM is a big investment. Consider these strategic and technical questions before you take the plunge.Continue Reading
Standard vs. Enterprise Editions of Oracle
What's the difference between Standard Edition and Enterprise Edition?Continue Reading
-
Difference between function, procedure and trigger
What is the difference between a function, a procedure and a trigger? I know the basic differences, but I would like to know the answers based on the performance tuning aspect.Continue Reading
Easy way to import public synonyms?
Using export/import to update a development database, I normally do a schema (user) import. Is there an easy way to import public synonyms?Continue Reading
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?
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
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
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
Oracle Java application performance, part 2: JDBC driver comparisons
A comparison of the performance of OCI and thin drivers.Continue Reading
Oracle Java application performance, part 1: Creating dynamic strings
Tips about using dynamic strings in Oracle and how they can improve Java application performance.Continue Reading
How can I use INSERT INTO to copy an entire table into another?