For more information about the site, see the Site Index

• How locks maintain the integrity of a multi-user database environment
• Problem installing 9i on Windows XP
• Can the dat file be deleted?
• Trigger to insert row failed first time, but works fine after
• Does Oracle ignore duplicate rows found in subqueries?
• Oracle 9i versus SQL Server 2000
• Why can't an instance open more than one database?
• Keyword search a memo field in an Access database
• Using generated numbers for primary keys
• Finding all the dates between two dates
• Version numbers explained
• Trigger running a shell process on Unix without pipes
• Script to maintain a partitioned table
• Background processes in an Oracle instance explained
• Connecting different versions of Developer and the database
• Changing the connect internal password
• Database commands
• Sorting substrings of different lengths numerically
• Sorting substrings of different lengths numerically, part 2
• Creating an Oracle synonym to an external MS SQL Server table
• Reducing the size of the database
• Saving files larger than 4K in Oracle 8
• NULL logic
• Tools to help size tables
• Converting values of one column as a separate column
• Shutting down the database with Java
• Removing tables from SYSTEM tablespace
• Matching data coded in databases spread across the country
• Counting rows with unique element in a particular column
• Example of password file creation
• Getting detailed information about SAP's data warehousing product
• Order of selected rows without an ORDER BY clause
• Error trying to drop the test user
• Returning the most recent weekday
• How to change return values using condition statement
• Calculating time differences
• Histograms and bind variables
• Available rooms query for room reservation system
• UNION versus UNION ALL
• Selecting from several tables
• Copying an Oracle database from Solaris to NT
• Why conceptual level is called community level
• Scaling up a database used for Lotus Notes
• Make "inactive" or archive old records to different tables?
• Trying to find the SQL92 and SQL99 specifications online
• Importing a dump file
• What relational means in RDBMS
• Problem with UTL_FILE_DIR
• Instances and processors
• FLUSH command explained
• Sending faxes using database triggers
• Searching for the last character in a string
• Differences between different Oracle versions
• Wrapped procedures not importing into Oracle 9i
• Default passwords for admin accounts
• Querying more than 10 million rows over dblink
• Granting different access rights to SQL and Forms and Reports
• The future for Oracle DBAs
• Fastest way to generate HTML dynamically
• Clusters explained
• Advice for a database design beginner
• Creating a form to view students' marks
• Creating a database for a pizza restaurant
• Oracle backup on Windows 2000 not going through
• Functional dependencies, part 2
• One big consolidated server or a bunch of clustered smaller ones?
• Help with migrating Oracle databases
• Differences between 8.1.7 and 9i
• Granting access to SQL different from access on Forms and Reports
• Determining which columns should be indexed
• More than two tables in an OUTER JOIN
• Row number in a SELECT statement
• Finding out how frequently an index is used
• Firing a trigger on a SELECT event
• Why Oracle?
• Subquery to find at least one
• What should end users do about security?
• What is the capacity of the database engine of Oracle9i?
• Changing a varchar2 field to uppercase
• Anonymous blocks, RDBMS vs. ORDBMS and REF cursors
• Creating more than one instance for a database
• Restricting users at different branches from accessing certain objects
• Is "SERVICE=orcl MANDATORY" only available when using standby database?
• Purchasing Oracle 9i for 100 users
• Mutating table and recursive SQL errors with trigger
• Sending e-mails using database triggers
• Export script for back-up operation on DOS
• Advice for a beginner
• Problems with remote connections to iSQL*Plus
• Checking free space in dictionary and locally-managed tablespaces
• ORA-00406 when trying to create a function index
• Getting accurate measures of table space
• Moving tables without losing attributes
• Restricting connections of clients using SQL*Net
• Using count_distinct on master and detail tables
• How to return a set of records from a PL/SQL procedure
• How many databases should a DBA administer?
• Fetching rows from trees
• Where the result sets of queries are stored
• Guide to indexing



• More