231 reputation
14
bio website
location
age
visits member for 1 year
seen Dec 11 '12 at 17:25
stats profile views 10

May
9
awarded  Yearling
Nov
30
accepted Load Numerical Column with Variable Comma
Nov
30
comment Load Numerical Column with Variable Comma
OK, this works; I ended up doing something similar before seeing your answer. I guess, at first, my brain had been looking for a way of using the format model to 'logically' say that the value may or may not contain commas.
Nov
29
asked Load Numerical Column with Variable Comma
Sep
5
accepted Regular Expression Difficulty
Sep
5
asked Regular Expression Difficulty
Aug
30
comment Using Multi-table Insert for Parent and Child Table
@VincentMalgrat: I'm inserting rows returned by a subquery. It is this subquery that determines the parent-child relationship; two insert statements wouldn't work.
Aug
29
comment Using Multi-table Insert for Parent and Child Table
@Phil: Yes I am.
Aug
29
asked Using Multi-table Insert for Parent and Child Table
Aug
27
comment Limiting Generated Sequence Values in Multi-table Insert
clever workaround!
Aug
27
accepted Limiting Generated Sequence Values in Multi-table Insert
Aug
21
comment Limiting Generated Sequence Values in Multi-table Insert
true, I'm not particular about that though. I just constructed this scenario as a MWE.
Aug
21
comment Limiting Generated Sequence Values in Multi-table Insert
What's wrong with mixing currval and 'nextval`?
Aug
21
comment Limiting Generated Sequence Values in Multi-table Insert
By "the most recently generated value but not a new one" I mean the currval of the sequence; I'm not sure what was not understood about that. And, no, I cant afford to do it in PL/SQL.
Aug
21
asked Limiting Generated Sequence Values in Multi-table Insert
Aug
16
accepted FORALL on Nested Collections
Aug
15
comment FORALL on Nested Collections
Wouldn't the third option be most efficient since all inserts are done by means of FORALLs; hence, less context switches?
Aug
14
comment FORALL on Nested Collections
maybe I'll settle for two FORALLs: one for outer_tab and one for inner_tab?
Aug
14
asked FORALL on Nested Collections
Aug
8
accepted Retrieve Indices of Associative Array as Collection