oracle several SQL commonly used
- 2020-09-16 07:50:13
- OfStack
1 Find the number of records select count(*) from table_name (change to table name)
2 Lookup table data size
select num_rows * avg_row_len
from user_tables
where table_name = 'table_name (change to table name) ';
More can under reference https: / / www ofstack. com article / 7827. htm
2 Lookup table data size
select num_rows * avg_row_len
from user_tables
where table_name = 'table_name (change to table name) ';
More can under reference https: / / www ofstack. com article / 7827. htm