For more information about the site, see the Site Index

• Viewing the ORA error in the Windows envionment
• Character to number conversion error
• Using the LIKE clause with indexes
• Creating a database on raw partition
• Changing the character set in 8i
• Managing two databases with Oracle Enterprise Manager
• Installing 9i on PC that already has version 8
• Tablespace explained
• CHAR versus VARCHAR2
• Performing an export on multiple tables
• Using dynamic SQL
• Generating insert scripts from current database values
• Code to stop a referree from being double booked
• Determining if license is named user or processor
• Maximum value in many-to-many relationships
• Ensuring unique primary keys
• Boolean columns
• Selecting time portion of datetime columns
• Latest contract period for each employee
• FIRST N rows, TOP N rows, LAST N rows, BOTTOM N rows...
• TOP-N queries and function-based indexes
• Grouping schemas functionally
• How to find which stored procedure is currently running
• Checking from which file instance started without changing file
• Implementing a data warehouse: Outsource or in-house with consultants?
• Closing ref cursor after it's used in a Java program
• Storing and retrieving video clips
• Error inserting from text items to Excel file
• Universal Installer can't install Windows Oracle 8 ODBC driver
• Trying to remove datafiles from tablespace
• Testing if a string is a number
• Database installation for beginners
• Caching and pinning revisited
• Aggregates by day of week
• Selecting data between certain hours
• Reorganizing a fragmented tablespace
• Creating an AFTER LOGON trigger
• Rule of thumb for bitmap indexes
• Exporting data using a WHERE clause
• Using the EXP command while database is running
• Creating a database with selected database files
• Error using LogMiner, Part 2
• Conditionally summing fields
• Are data warehouses just a passing trend?
• Languages to accompany OCP
• Working with Oracle and Progress
• Dump file format
• Max number of constraints, logical/physical activities, selecting duplicate rows
• Setting up security for the listener
• Known issues with running 8i on Win2000 connecting to version 8 databases
• Regularly transferring data from other databases to Oracle
• Can't use MAX function in the WHERE clause
• Error using LogMiner
• Is Oracle right for brokerage firm requirements?
• Blocksizes for BLOB table
• Logging the command that caused server error
• Getting a single row for cancelled and completed orders by date
• Self-teaching Oracle skills
• Restricting database logon times
• Any restrictions on SHARED_POOL_SIZE or SGA?
• Executing a procedure from a perl script
• Parallelism in 8i/9i, translating SCN
• Comparing LDAP and OiD
• Forgot password for listener
• Representing set of numbers as set of ranges
• Padding numbers with zeros
• Creating aggregate entries where no base data exists
• Concatenating all columns generically
• Check the bits of a numeric field
• Rows having maximum group value in MySQL
• Replicating from SQL Server to Oracle
• Rolling back after a COMMIT
• Finding and adding one to the max_date
• Trigger won't insert into table
• Object-oriented versus structured methodology
• Linking database with C/C++ applications
• Sequences explained
• One-to-one-or-more relationships
• Mass updates affecting users
• Hybrid databases explained
• DELETE or UPDATE, CASCADE or RESTRICT, part 1
• DELETE or UPDATE, CASCADE or RESTRICT, part 2
• Averages over a span of years -- Part 1
• Averages over a span of years -- Part 2
• Crosstab totals per quarter
• Age constraint on a date column
• Installing Informatica and Oracle on same system
• Deleting statistics after analyzing tables
• Merging customer lists
• COALESCE on three columns
• Normalize a column containing a list
• Sorting an E-mail column on Domain name
• How to pronounce SQL
• Why WHERE cannot be used after GROUP BY
• Day of the week
• Design for sales database
• Pinning and caching
• Remotely closing a D2K form
• Insert without a column list
• Optimizer not using indexes



• More