当前位置：网站首页>Collection of common SQL statements

Collection of common SQL statements

2022-04-23 17:11:00 【ZHZHK001】

Query the current user ： Number of rows in all tables

Apply to ：oracle

select t.table_name,t.num_rows from user_tables t ORDER BY num_rows DESC ,table_name

If the above sql No queries , Run the above sentence again after executing the following script 【 I can run it directly 】

create or replace function count_rows(table_name in varchar2,
                                      owner      in varchar2 default null)
  return number authid current_user IS
  num_rows number;
  stmt     varchar2(2000);
begin
  if owner is null then
    stmt := 'select count(*) from "' || table_name || '"';
  else
    stmt := 'select count(*) from "' || owner || '"."' || table_name || '"';
  end if;
  execute immediate stmt
    into num_rows;
  return num_rows;
end;

Reference resources ：https://www.cnblogs.com/luxd/p/6141476.html

版权声明
本文为[ZHZHK001]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204230553251565.html

边栏推荐

猜你喜欢

随机推荐