The AskTOM team is taking a break over the holiday season, so we're not taking questions or responding to comments. Please have a happy and safe festive season and as always, thanks for being a member of the AskTOM community.
Thanks for the question, Batzorig.
Asked: April 08, 2024 - 7:13 am UTC
Last updated: April 09, 2024 - 12:47 pm UTC
Version: 23.1.0.097
Viewed 1000+ times
create or replace function num_rows ( tab dbms_tf.table_t ) return clob sql_macro as begin return ' select count(*) from tab '; end; / select * from num_rows ( hr.employees ); COUNT(*) ---------- 107 select * from num_rows ( hr.departments ); COUNT(*) ---------- 27
Complete documentation on Securefiles and Large Objects here