Ask the Experts
Ask the Experts
-
Storing and retrieving video clips
-
Implementing a data warehouse: Outsource or in-house with consultants?
-
Closing ref cursor after it's used in a Java program
-
Caching and pinning revisited
-
Exporting data using a WHERE clause
-
FIRST N rows, TOP N rows, LAST N rows, BOTTOM N rows...
-
Max number of constraints, logical/physical activities, selecting duplicate rows
-
Can't use MAX function in the WHERE clause
-
Executing a procedure from a perl script
-
Comparing LDAP and OiD
-
Concatenating all columns generically
-
Object-oriented versus structured methodology
-
COALESCE on three columns
-
Why WHERE cannot be used after GROUP BY
-
Day of the week
-
Age constraint on a date column
-
DELETE or UPDATE, CASCADE or RESTRICT, part 1
-
Hybrid databases explained
-
Pinning and caching
-
Getting a row number in a group
-
Query to find size of BLOB objects
-
Grouping output by week
-
Inserting multiple child rows
-
Setting up automatic e-mail notification of expiring passwords
-
Importing and exporting a database from a remote machine
-
Inserting three columns into one
-
Purpose of a primary key
-
What does SELECT 1 accomplish?
-
Beyond petabytes
-
Trigger to restrict number of rows in a table
-
Inserting a carriage return in an Oracle table
-
Installing 9i: what you need to do
-
Aggregates for date ranges
-
Column names in a UNION
-
Finding the sequence of the last full backup
I have an Oracle database working in archive mode. Could you tell me how to find the sequence of the last full backup? Continue Reading
-
Aggregate functions in a left outer join
-
Last N rows in DB2
-
Closest date before or after a given date
-
Use column alias to query same field names
-
Getting the SQL traffic byte size for session and transaction
-
'RRRR' versus 'YYYY' in the date format
-
Tools to teach normalization
-
Using CASE to change SELECT column values
-
What is the importance of query optimization?
-
Modeling an exclusive OR relationship
-
Why use a "business key" and a "primary key"?
-
The significance of BCNF
-
Rapid application development, structured and soft sytems methods of design
-
Copying tables from one DB to another via database link
-
Tools for reverse engineering a database
-
Indexed views and Oracle
-
Composite foreign keys, Part 1
-
Running SQL*Plus scripts without supplying password
-
Finding rows with non-printable characters in them
-
RAID 3 or 5 for digital video storage
One reader asks, should I use RAID 3 or RAID 5 for Oracle databases? Read the answer from our expert. Continue Reading
-
A one-to-many relationship as a comma-delimited list
-
Workaround for ORA-04043: Can't describe object using db_link
-
Creating a trigger that is executed only after table insert has been committed
-
Database server versus application server
-
Unique indexes and NULLs
-
Checking if row is locked before using it in a procedure
-
Using SEQUENCE in a Java servlet
-
Can I write a trigger that fires at a particular time every day?
-
Getting the table name within a trigger
-
Getting the length of a LONG data type and concatenating LONG with VARCHAR2
-
Inserting LONG RAW data
-
Displaying results horizontally
-
Columns for every day of the month
-
Why is dblink between two instances on same platform slow?
-
Books and authors, many-to-many
-
Getting a full history of all SQL queries run on the database
-
Inserting an Excel file into a BLOB field
-
Updating a BLOB column without BFILE/create directory options
-
Altering maxextents
-
Connecting V$SESSION and V$SQL
-
Operational data store versus a data warehouse
-
Resolving the "ORA-12571: TNS:Packet writer failure" error
-
Custom development versus ETL tool
-
Result set row count along with query results
-
RBS tablespace is full
-
Mutating triggers explained
-
AVG() function on a date field
-
Cumulative sum in Access
-
Determining total number of records in a cursor
-
Anything similar in Oracle to Microsoft's IIF function?
-
Restoring data from a .dmp file using the imp command
-
Knowing when a row is locked by another user
-
Oracle and Sybase outer joins
-
Grouping rows by 5-30 days, 31-60 days, and 61-90 days