Ask the Experts
Ask the Experts
-
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
-
Using SEQUENCE in a Java servlet
-
Checking if row is locked before using it in a procedure
-
Unique indexes and NULLs
-
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
-
Books and authors, many-to-many
-
Why is dblink between two instances on same platform slow?
-
Columns for every day of the month
-
Inserting an Excel file into a BLOB field
-
Getting a full history of all SQL queries run on the database
-
Altering maxextents
-
Connecting V$SESSION and V$SQL
-
Updating a BLOB column without BFILE/create directory options
-
Operational data store versus a data warehouse
-
Resolving the "ORA-12571: TNS:Packet writer failure" error
-
Custom development versus ETL tool
-
RBS tablespace is full
-
Mutating triggers explained
-
AVG() function on a date field
-
Cumulative sum in Access
-
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
-
Concatenating a string to a number
-
Querying remote schema using dblink
-
Assignment operators explained
-
Displaying the output of PL/SQL procedures
-
Maximum number of columns in a primary key
-
Finding all the dates between two dates
-
Resolving the ORA-03114 error
-
Can the dat file be deleted?
-
Does Oracle ignore duplicate rows found in subqueries?
-
Background processes in an Oracle instance explained
-
Available rooms query for room reservation system
-
Creating a form to view students' marks
-
Creating a database for a pizza restaurant
-
Differences between different Oracle versions
-
Creating a sequence for a varchar in PL/SQL
-
Active and inactive records
-
Lock conversion/promotion defined
-
Changing a varchar2 field to uppercase
-
Creating more than one instance for a database
-
Scrollable cursors in Oracle
-
Getting a ref cursor from a PL/SQL table
-
Finding rows in parent tables with no corresponding entries in child table
-
Storing and retrieving mathematical formulas
-
Problem with dblink: ORA-02085
-
Is there a way to stop a rollback?
I have a table with 10 partitions. Each partition has 1 milion rows. I wanted to delete rows with rid=1, which are in partition 1. It was taking a long, long time. So I killed the session. Now my database is rolled back, all the rows deleted. Continue Reading
-
SUM() and MAX() at the same time
-
ORA-00604: error with recursive SQL
What is the ORA-00604 error in Oracle? Learn about this Oracle error in a tip from expert Brian Peasland. Continue Reading
-
Best backup strategy for a data warehouse
-
Searching on CLOB columns
-
Working with dates where year, month and day are separate columns
-
More on ISBN as a primary key
-
GROUP BY and ORDER BY
-
Connecting a C or C++ program to the database
-
Grouping by hour
-
Data type for telephone numbers
-
COALESCE and dates
-
Finding the total number of constraints on all tables of the database
-
Copying rows between tables with mismatched columns
-
Updating multiple columns from another table
-
Resolving error ORA-12545
-
Using the WHEN_TAB_PAGE_CHANGED trigger
-
Select 3rd, 4th, 5th of 100 rows
-
Hardware requirements for constructing and developing a data warehouse
-
Data warehouse for hospital patient information
-
Missing triggers in an Oracle dump
-
Oracle Forms/Reports vs. Crystal Reports
-
Birthdays in the next two weeks
-
Using SQL to forecast growth
-
Using SQL to forecast growth, part 2
-
Exporting a stored procedure/function/package
-
Inserting whole rows into tables without denoting column names
-
A Master/Detail report using SQL
-
Are COUNT and DISTINCT SQL-92 compliant?
-
Sorting the days of the week with Monday first
-
Calculating quartiles
-
Displaying time ranges based on login, logout
-
Building a human resources data warehouse
-
Copying an entire table to another table