Hi friends, I collect a large amount of data every day, from various tables,
I like to create a function has two in parameter (table name & date field) and it's out parameter should be row count as the follow: create or replace function TABLE_ROW_COUNT (v_table IN VARCHAR2, v_date_col IN varchar2) return number is Result number; begin v_count NUMBER; BEGIN SELECT COUNT(*) INTO Result FROM v_table WHERE v_date_col >= trunc(SYSDATE-1); return(Result); end ; the problem it doesn't accept table name as variable, is their any other way around it, many thanks in advance, Best Regards, Iyad -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en