For more information about the site, see the
Novice server advice for creating Web portal site
Access command button to cancel an Add New Record
Which DBMS should I use for textile mill project?
What is a foreign key?
Function for calculating elapsed time between two dates/time variables
Oracle 8i vs. Informix 7.3, part 2 of 2
Oracle 8i vs. Informix 7.3
Outer join syntax
Denormalizing a result set
Automatically install application database schema
Rewrite query in 7.3.4 without Function Based Indexes
Items with sales above $10,000.00
An Accounts Receivable report in one query
Selecting random rows
Conditional values in the SELECT list
Physical backups in Oracle 8i
How can I take a tablespace backup using the export utility in Oracle8i?
How do I configure Oracle 8 client on a Windows 95 machine?
Advanced error checking using a trigger
Write this query to make use of an index
Migrating Oracle 7.3 to 8i
Platform for implementing a 100 GB database on Oracle 8i/9i
Developing medical college site with access to data
How can I create a database in Oracle programmatically?
Oracle 8i security
Web-based tool to manage information in hosted Oracle database
How do I put days of the week in order...Monday, Tuesday, Wednesday, etc?
Database design for Web page search function
What is the maximum number of indices a table can have?
Linking two databases by relating two tables
Is it possible to import data from Excel into Access?
How can I use INSERT INTO to copy an entire table into another?
Returning a specified number of rows
Apostrophes in input
Wrong answer for MOD function?
Difference between two dates using office hours
Resetting rollback segments
How can I find a record in a table that is accessed by more than one user concurrently?
How to get the last 50 rows in a table
Exporting and compressing file
Loading data with command prompt
Problems with database upgrade
Difference between clustered and non-clustered indexes
Conflict resolution method for two-way replication
Changing back-end to Oracle 8i
Closed vs. open security policies and permissions in an RBAC role hierarchy
High water limits for simultaneous database connections and transactions per second speed ratings
Creating XML CLOBs on Oracle 8i
What is Explain Plan in Oracle, & how do we use it?
Upgrading OEM from v2.1 to v2.2
Reinstalled NT but lost Oracle 8
Conflict resolution in two-way replication
Why are there and what is the effect of having blank rows in an Oracle table?
Final confinuation of 4/30 question re: Oracle installation in Compaq ASE Cluster/RAID
Restoring and exporting tables
Creating a password file and running it as default
How to tune Perl program for managing structured data
Formatting field to insert e-mail hyperlink
Where to find information on the Pickler Method
SQL trace for one session
What does null mean?
Is there a SQL-specific way to control record locking?
Display number of records in a field in a different table
Extracting data from RDBMS to CD-ROM and building Delphi application
Pursuing DBA as a career
Can I use a subselect statement?
Hit an error
Education tracks to become an Oracle DBA
Tips for Oracle software installation in a RAID environment
Obtaining certification as an Oracle DBA
CASE methodologies presented by Oracle
Modifying a table to include 3 columns, one of which is a BLOB
How do I make a character field numeric in the Proc SQL statement?
How to speed up loading production data into test database
What are MAEs in the Internet?
How to graphically monitor jobs
What is the Boyce-Codd normal form?
How to return rows that show names with apostrophes
Supporting domains and SQL92 or SQL3 compatible servers
Is the following correct?
Converting a database to any ODBC-compliant database
How to resize the columns in a given table
Does the lack of domains hurt SQL?
Developing a flexible data model to be customized by the customer
Comparison between Oracle 8i and MS SQL Server
Estimating table and tablespace size
Adding tables that will have AccountID as a foreign key
How to find the first 5 highest salaried employees in each department
Joining two tables but including the most recent row for each
Information on minimum hardware and/or RAM requirements
Is it necessary for a table always to have a primary key?
Tools for design information with SSADM or Barlow methods
Advantages and disadvantages of ndexed and hashed file access methods
Delete properties of Master/Detail relationship
Writing an SQL query that shows suppliers of only best shops in specific state
Deadlock error when a specific batch process runs in parallel
How to query the catalog/system tables to establish the number of databases on the server
Reorganizing data to optimize performance