On Tuesday, June 15, 2021, Yambu <
hyambu@gmail.com> wrote:
Hello
Is it possible to have as input to a function , a whole table contents, if the table is a small lookup table?
Something like this
CREATE or replace function test (IN (select * from table1) )
No. Function arguments are data types, not contents. Queries go inside the function body.
David J.