Ask the Experts
Ask the Experts
-
First and last date of the current month
-
What is a correlated subquery?
What is subquery and correlated subquery? What is the difference between them? Continue Reading
-
Why "select star" is bad
-
Insufficient privileges error ORA-01039
-
Loading text data into Oracle with SQL*Loader
-
Errors when importing from same version
-
Creating a dynamic crosstab query with Oracle, part 1
-
Relating Cartesian product to relational algebra and calculus
-
Importing dump file from Oracle on Linux to Oracle on Windows
-
How to reuse space in Oracle
-
Weighted percentiles, part 1
-
Importing/exporting wrapped PL/SQL procedures
-
Counts and total count in one query
-
Three consecutive days
-
Gaps in sequences
-
Calling a stored procedure in DB2 from Oracle 8.1.7
-
How does RAC handle DML operation in failover?
-
Two foreign keys to the same primary key?
-
The integers table
-
Supertypes and subtypes
-
Oracle Forms Developer script to change Windows resolution
-
Bank statements don't match AP, AR transactions
-
What are modern database management system's applications?
-
How to view report output generated by another user
-
13 steps to replacing small redo log files
-
What is error SP2-0678?
-
26 performance tuning questions and solutions, #1-10
-
What is ORA-06512?
Learn how to solve the ORA-6512 error in this tip on Oracle errors from an expert. Continue Reading
-
Setting up ODBC driver for migration
-
Calculations between two rows in one table
-
Cumulative sums within groups
-
Is RMAN backup smaller than normal OS-level backup?
-
Transitive joins
-
Fixed vs. variable size
-
Moving data from Oracle report to MS Excel
-
Best RAID level for database
-
What's causing unable to extend lob segment error?
-
One column contained in another
-
Getting ORA-00604 error when connecting to database user
-
Help with ORA-06554 regarding package DBMS_STANDARD
-
How to determine what DDL changes have been made
-
Why is database not functioning when SMON is killed
-
Working with Arabic characters in Developer 6i
-
Creating tables in PL/SQL
-
SELECT/INTO and INSERT/SELECT
-
Unable to insert records when using database link
-
UPDATE one table based on a condition in another
-
Date minus number
-
Indexed vs. non-indexed database
-
Accessing an ODBC data source, part 1
-
Dynamic SPOOL file naming
-
Using UNION to make a header
-
How to pass a date to a stored procedure in Oracle9i
-
Using a database link in a SQLLDR control file
-
Seven steps to creating a catalog database
How do I create a catalog database for RMAN backup and recovery? Continue Reading
-
Depersonalizing data
-
Rebuild a table to reduce number of extents
-
Using SQL to update e-mail addresses
-
Why is database hanging?
-
Derived table in DB2
-
Closing custom form window
-
Coding for unique calendar year, part 2
-
Does Oracle reserve space for a VARCHAR2() datatype?
-
Multiple instances vs. single instance
-
Connecting Oracle and Visual FoxPro
-
Subquery or join?
-
Moving partitions
-
Difference between ALL_OBJECTS and DBA_OBJECTS
-
Solving error ORA-3113
The ORA-03113 error comes up when I insert in this table, but on other tables the insert takes place smoothly. Continue Reading
-
Dates and DECODE
-
Fiscal year, ISO week, part 2
-
Converting columns to rows
-
Does Oracle work better on Windows or Unix/Linux?
-
Solving error ORA-12545
-
Cycle relationships in ER diagram?
-
Logical and physical data models explained
-
What's an Oracle instance?
-
Three ways to query a table relationship
-
Combining a LEFT OUTER and INNER join
-
UNION in a subquery
-
A view for a MAX value in any month
-
The Sybase list() aggregate function
-
Table design in OLAP versus OLTP
-
MI, CI and BI
-
Counting number of transactions in a variable time
-
Calculating initial, next and max extents
-
What happens in background when in hot backup mode
-
Specifying conditions in SQL*Loader control file using WHEN clause
-
Nested GROUP BYs
-
DECODE versus CASE
-
PUBLIC versus PRIVATE synonyms
-
Revoking EXECUTE ANY PROCUDURE FROM PUBLIC
-
Resolving the ORA-01002 error
-
Tracing queries in specific schema or database