Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-30-2024 09:46 AM - edited 03-30-2024 09:51 AM
I looked at this post
What I want is to replace the static table name with the table name passed as parameter (param_table_name). Is it possible?
CREATE OR REPLACE FUNCTION mydb.tbl_filter(a_val INT, param_table_name string)
RETURNS TABLE(a INT, b INT)
RETURN SELECT * FROM tbl_filter.param_table_name tf
WHERE tf.a = tbl_filter.a_val;