Explore >> Select a destination
|
You are here 
|
www.greenstechnologys.com | ||
| | | | |
traininginchennai.in
|
|
| | | | | PL/SQL Cursors - Learn PL/SQL programming in simple and easy steps starting with PL/SQL syntax, Environment Setup, Operators, Transactions, Date and Time, data types, variables, constants, records, conditional statements, iterative statements, cursors, procedures, functions, exception handling, triggers, packages, collections, external procedures, arrays, strings, dbms output. | |
| | | | |
kerryosborne.oracle-guy.com
|
|
| | | | | ||
| | | | |
www.craigpardey.com
|
|
| | | | | I came across an interesting problem recently in some JDBC code that was inserting rows into a Netezza database. The Java code was doing something like this: Statement stmt ... for( SomeObject o : listOfObjects) { String sql = "INSERT INTO tbl(col1, col2) values (?,?)"; ... stmt.addBatch(sql); } stmt.executeBatch(); On the "executeBatch()", a SQLException was being thrown that said "failed to create external table for bulk load". What? But it wasn't a bulk load. There were no external tables involved - it was a batch of vanilla inserts. | |
| | | | |
sqlmaria.com
|
|
| | | Database views are a handy tool to help obfuscate complex joins from developers and analysts. However, knowing which view to use can be tricky, especially when faced with multiple views with simila... | ||
