Ask the Experts
Ask the Experts
-
How to determine what DDL changes have been made
-
Working with Arabic characters in Developer 6i
-
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
-
Using UNION to make a header
-
Dynamic SPOOL file naming
-
Using a database link in a SQLLDR control file
-
Depersonalizing data
-
Rebuild a table to reduce number of extents
-
Seven steps to creating a catalog database
How do I create a catalog database for RMAN backup and recovery? Continue Reading
-
Why is database hanging?
-
Using SQL to update e-mail addresses
-
Derived table in DB2
-
Does Oracle reserve space for a VARCHAR2() datatype?
-
Closing custom form window
-
Multiple instances vs. single instance
-
Connecting Oracle and Visual FoxPro
-
Subquery or join?
-
Difference between ALL_OBJECTS and DBA_OBJECTS
-
Moving partitions
-
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
-
Solving error ORA-12545
-
Does Oracle work better on Windows or Unix/Linux?
-
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
-
Counting number of transactions in a variable time
-
MI, CI and BI
-
Table design in OLAP versus OLTP
-
Calculating initial, next and max extents
-
Specifying conditions in SQL*Loader control file using WHEN clause
-
Nested GROUP BYs
-
DECODE versus CASE
-
PUBLIC versus PRIVATE synonyms
-
Multiple listeners to the same database
-
Tracing queries in specific schema or database
-
'Database level' versus 'instance level'
-
Resolving the ORA-01002 error
-
Revoking EXECUTE ANY PROCUDURE FROM PUBLIC
-
Returning more than one value from PL/SQL procedure
-
Strengths and weaknesses of OLAPInsider
-
SHARED_SERVER_SESSIONS parameter explained
-
Determining if VARCHAR2 column contains valid date
-
Using PL/SQL to read delimited ASCII text files... Part 4
-
Adding a second control file
-
Looking at each value in a VARRAY
-
Resolving the ORA-06508 error
-
Telling EXECUTE IMMEDIATE to commit
-
Getting total number of rows inserted and updated
-
Business Objects as a data warehousing tool
-
Checking if varchar2 column contains only numbers
-
Resolving error ORA-06550
-
Maximun number of columns for a composite primary key
-
Capturing errors from MERGE statement
-
Catching error code that arises in PL/SQL
-
Resolving the TNS-12502 error
-
Resolving the "The instance Oracle VTDBS has been Terminated" error
-
Will tablespace show more free space after deleting records?
-
Running SQL*Loader from within PL/SQL procedure
-
When to use functions and stored procedures
-
Transposing rows and columns in a SELECT statement
-
Sequence of user process, server process, instance and session
-
Resolving an IMP-00002 error
-
Using SQLLDR, EXPORT and IMPORT from a client machine
-
ON DELETE in a many-to-many relationship
-
Errors when running catalog.sql and catproc.sql files
-
Oracle.exe taking 99% of CPU
-
Table comparison stored procedure very slow
-
Sending email from a stored procedure or trigger
-
Format query output as header and detail lines
-
Benefits, costs of running RAC
Could you address the benefits of running RAC with Oracle database servers running on Sun clusters? Continue Reading
-
Data dictionary versus the data directory
-
Lookup table explained
-
Installation error: Java Runtime Environment not found
-
Calling a stored procedure from a trigger
-
Getting IP address, version, server names, etc. with SQL
-
Oracle's equivalent of SQL Server's TOP command
-
200,000-record load taking too long with SQL*Loader