I would like the user to be able to click a button on the web page that will run a SQL query (canned report) and export the result data to an Excel spreadsheet. The data does not need to display on ...

Nobody ever really wants to move a database, but it is a frequent necessity. Here are the most common options and when to use each one Nobody ever really wants to move a database, but it is a frequent ...

Data Pump doesn't necessarily have to write to files. Now there are options to allow you to export database objects directly into a remote database over SQL*Net. You simple specify the remote option ...

The transaction log file contains the SQL Server transactions of the database. It basically records the database transactions and the changes made by the transactions to the database. The logs are ...

Quest Software recently introduced its latest version of Toad for Oracle, used to manage database objects, create and debug PL/SQL, and create, execute and optimize SQL queries. The database tool is ...