add parametr parser to "Edit Parameters(ctrl+shift+P) window
Then i use query with many param i need write all it into the parameters table hand by hand.
select :p1,:p2,:p3,:p4,:p5,:p6,:p7,:p8,:p9,:p10 from dual
please add textbox what i put m.b. JSON as:
{p1:1,p2:2,p3:3,p4:4,p5:5,p6:6,p7:7,p8:8,p9:9,p10:10} and it asserted to query and used in execute.
And can optuinal add type:
{p1:[1,number],p2:[2,number], p3:3,p4:4,p5:5,p6:6,p7:7,p8:8,p9:9,p10:10} with varchar2 as default
2
votes
DmitryK1
shared this idea