Simple DB Access

Serge Aleynikov serge@REDACTED
Sat Aug 5 02:53:39 CEST 2006


Christian S wrote:
> edbc:execute("SELECT * FROM foo WHERE id = $1", [Id])

One comment about a nice feature to have in edbc that I believe is 
specific to OCI - array DML inserts, where bind variables can contain an 
array of values.  This saves quite a bit on network round trips when 
inserting hundreds / thousands of records

edbc:execute_array(
     "insert into foo (field1, field2) values (:1, :2)",
     [ [ 1, 2, 3, 4 ], ["a","b","c","d"] ]
).

Serge



More information about the erlang-questions mailing list