Dave Costa questions

Dave Costa answers

• Why does Oracle round up a number with less than 38 significant digits?
• Can I lock rows in a cursor if the cursor only returns a single count(*) row?
• Access cursor by column name dynamically
• How to discover the underlying primary (or unique) key columns from an Oracle view
• Using alias from COALESCE from SELECT in WHERE clause
• How to trim all columns in all rows in all tables of type string?
• Oracle - Convert value from rows into ranges
• Optimizing Oracle stored procedures
• Oracle query with multiple tables
• Preferred way to use the random class