Ask the Experts
Ask the Experts
-
Creating a form to view students' marks
-
Creating a database for a pizza restaurant
-
Row number in a SELECT statement
-
Active and inactive records
-
Lock conversion/promotion defined
-
Creating more than one instance for a database
-
Creating a sequence for a varchar in PL/SQL
-
Changing a varchar2 field to uppercase
-
Scrollable cursors in Oracle
-
Number of seconds since a certain date in Oracle
-
Getting a ref cursor from a PL/SQL table
-
Finding rows in parent tables with no corresponding entries in child table
-
Problems with cursor example in Oracle 8i
-
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
-
More on ISBN as a primary key
-
GROUP BY and ORDER BY
-
Grouping by hour
-
Data type for telephone numbers
-
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
-
Working with dates where year, month and day are separate columns
-
COALESCE and dates
-
Connecting a C or C++ program to the database
-
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
-
Resolving the "ORA-01034: ORACLE not available" error
-
Birthdays in the next two weeks
-
Using SQL to forecast growth
-
Using SQL to forecast growth, part 2
-
ALTER TABLE EMP CACHE vs. ALTER TABLE EMP STORAGE
-
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
-
Building a human resources data warehouse
-
Calculating quartiles
-
Displaying time ranges based on login, logout
-
Copying an entire table to another table
-
Finding and deleting duplicate records in a table
-
Trouble with TRUNCATE in a procedure
-
The v$process table explained
-
TEMP tablespace, but no TEMP.dbf file
-
The pros and cons of UNION
-
How writers do not block readers in Oracle
-
Database instance and listener explained
-
Foreign keys and triggers for referential integrity explained
-
What is a primary key? Composite PK? Foreign key? Tuple?
-
Converting a character column containing dates to a DATE column in Oracle
-
Using ISNULL or NULLIF to prevent division by zero
-
MS Access, MS SQL Server and Oracle compared
-
Maximum number of rows in Microsoft Access
-
Joining tables based on partial matches
-
Sequences and indexes explained
-
Calculating percentiles in SQL
-
How does WHERE EXISTS ( SELECT NULL... ) work?
-
SQL Plus won't run trigger
-
Cursors: %type and %rowtype explained
-
Selecting records that exist in two tables
-
Selecting and comparing data from two different databases
-
Returning number of rows to a REF CURSOR
-
Writing a trigger to update column in table when that table is updated
-
Engine-based vs. code-generating ETL tools
-
Returning records where column has carriage return line feed
-
Nth maximum record in Sybase
-
Three-way join
-
Can there be too many columns in an index?
-
Minimum server requirements for installing Oracle 9i
-
Getting the sum of two count rows returned in the union query
-
Requirements questionnaire template
-
Getting the 10th row of a table
-
Inserting DB2 dates into COBOL variables
-
Forward and backward scrolling cursors
-
Writing a query to return invoices that are 30 or 60 days past due
-
The most important reporting and query tools
-
Resolving a 4031 error
-
Solution for a Microsoft OLE DB ODBC unspecified error