Connor and Chris will both be at AI World from October 12 to October 17 , the premier Oracle conference of 2025. If you're in Vegas, please come say Hi or pop into our sessions
Thanks for the question, nikoloz.
Asked: April 11, 2025 - 6:24 pm UTC
Last updated: April 14, 2025 - 7:05 am UTC
Version: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.14.0.0.0
Viewed 1000+ times
create table t1 ( id number, my_varchar2 varchar2(50) ); insert /*+ append */ into t1 (id, my_varchar2) select level, 'some data ' || level from dual connect by level <= 5000; commit; select table_name, num_rows, notes from user_tab_statistics where table_name = 'T1'; TABLE_NAME NUM_ROWS NOTES ---------- ---------- ------------------------- T1 5000 insert into t1 select level+5000, 'more data ' || level || level from dual connect by level <= 1000; commit; select table_name, num_rows, notes from user_tab_statistics where table_name = 'T1'; TABLE_NAME NUM_ROWS NOTES ---------- ---------- ------------------------- T1 5000 T1 6000 STATS_ON_CONVENTIONAL_DML
Check out more PL/SQL tutorials on our LiveSQL tool.
PL/SQL reference manual from the Oracle documentation library