Dave Costa questions

Dave Costa answers

• Partitions and High Water Mark in Oracle
• how to append values to a oracle type
• Array over written with last value assigned?
• scalar subquery in if statement Condition in PL/SQL
• Streaming ResultSet Error
• execute immediate over database link
• Oracle proprietary joins- joining on multiple conditions
• Why is the load method of a datatable sometimes so slow?
• Is there an Oracle SQL tool that builds insert statements from a result set?
• oracle insert only time [duplicate]