Work around SQL array? -


i have form has 6 different inputs:

form_no   varchar2, form_ver  number,  org_no    varchar2, item_no   varchar2, form_type varchar2, line_no   number 

these inputs stored temp table. need build function takes temp variables temp table validation. need use array hold variables.

i pretty new sql. have had experience in , other coding languages. have realized there not array in sql. wondering if me started or understand how around not using array, , able finish it.

--temp table variables put in      insert temp table         values           (t_form_no,            t_max_form_ver,            t_org_no,            t_item_no,            t_form_type,            t_line_no,  --function  validation_form --need have array here takes in temp variables temp table  --then have validation scripts placed here 

if trying same functionality array temp table can work fine. here how.

create table #foo     (fooid int not null identity (1,1),      field1 varchar(20),      field2 varchar(20),      field3 varchar(20),      field4 varchar(20),      field5 varchar(20)) 

when insert into table #foo, 1st row numeric , additional fields whatever insert them.

is trying acheive?


Comments

Popular posts from this blog

javascript - DIV "hiding" when changing dropdown value -

Does Firefox offer AppleScript support to get URL of windows? -

android - How to install packaged app on Firefox for mobile? -