On Tuesday, June 15, 2021, Yambu <hyambu(at)gmail(dot)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.