For more information about the site, see the Site Index

• Generate flat files from a data warehouse
• Unix script to gather tablespace information
• Get the wait time of a SQL session
• Find all the 'son' constraints
• Last DDL time by tablespace
• Login without knowing password
• Craig Mullins answers your database administration questions
• Using Java stored procedures: AOL instant messaging from Oracle
• Database link without SQL*NET string
• Find tablespaces that are in backup mode
• Stupid check for proper instance
• Using UTL_FILE to find files on the OS
• Guaranteeing a single row SELECT
• Get current SQL from SGA
• Finding and deleting duplicate rows from a table
• Oracle 9i MERGE statement explained
• No quality control
• Keep track of dropped objects
• FOLD_STR function to break SQL at given lengths
• Log switches per day/hour
• Linking SQL Server 2000 to Oracle 8i
• Hiding the Oracle password
• How to find VARCHAR2 columns that contain only numbers
• Metadata API in Oracle 9i
• Copy data from one database (SID) to another database
• Enable all disabled constraints
• Display a number in words
• Copy data from a query to a table in a local or remote database
• Archive log switch history
• An aggregate product function
• Compile all invalid objects
• Removing duplicate tuples
• Finding all possible paths in a MS Project activity network using PL/SQL
• As simple as possible, but not simpler
• Hide a user password
• Monitoring daily archive log switches: Number, size and frequency
• Tip for installing Oracle 8i on Solaris
• List the KEPT status for PL/SQL objects in your database
• Find the total number of opened cursors for any particular user
• Object vs. relational database management systems
• How to query using special characters in Oracle
• Automatically delete archive logs
• Generating DMP files with the date under Unix
• The ODBMS lives! A rebuttal to Fabian Pascal
• Fetching the Nth highest record
• The problem with petabytes
• Creating a link for connecting two databases
• Golf club maker chips out of a SAN trap
• To a hammer, everything looks like a nail: Part II
• How to run two or more databases in different time zones on the same machine
• Optimal size of rollback segments
• Tuning the database cache hit ratio
• How to modify the snapshot structure without dropping the table
• Identify an object's locks in the database
• Successful data mining requires work
• Manage archive redo log files
• Healthcare company cures backup ailment
• Dynamically change NLS_LANG
• Identify missing FK indexes and create indexes to avoid deadlocks
• Size of the database
• How to convert milliseconds to the proper date format
• Check digit function
• Naming a file with a date
• To a hammer, everything looks like a nail: Part I
• Change the font in the SQL*Plus GUI
• Copy the structure of a table
• Listing parameters and their descriptions
• Allow a user to kill certain sessions without giving them the alter system privilege
• RBS monitor to catch ORA-1555 errors
• Time conversions
• Oracle 9i R1 allows any user to access any table
• 13 reasons why normalized tables help your business
• How to find carriage returns in data
• Dynamic time sequence query
• Get EXPLAIN PLAN without running the query
• Grant and create user in one step
• How to avoid 'mutating table' errors
• No supply without demand
• Notify Oracle application users
• Exception handling
• Oracle Java application performance, part 2: JDBC driver comparisons
• Oracle Java application performance, part 1: Creating dynamic strings
• Despite its troubles, Lotus makes comeback with Notes/Domino 6
• Database startup/shutdown UNIX script
• Session time statistics capture
• Creating a table with the AS SELECT clause
• Generate a bar graph for tablespace utilization
• Move multiple tables belonging to a particular schema
• An example of dynamic SQL in PL/SQL
• Comparing trees in the nested sets model
• Another way to initialize variables in SQL*PLUS
• Oracle questions answered
• Your integrity, normalization, and relational model questions answered
• Application inventory script
• Finding ASCII representations of integers via SQL
• An alternative to SQL INSERT statements
• Checking internal concurrent manager status
• Oracle alert log miner
• Converting an adjacency list model to a nested set model
• Crosstab functionality using a view



• More