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
Post a Comment