Oracle查询所有表id大于10000的数据表名和数据

Oracle查询所有表id大于10000的数据表名和数据

Sql代码

-- 查询所有表id大于10000的数据以及对应表名称

select 'select id,'''||table_name||''' as tablename from '||table_name||' where id>=10000 union ' from user_tables;

www.2cto.com

Sql代码

-- 显示结果如下：

select id,'AUTH_MEMBER_ROLE' as tablename from AUTH_MEMBER_ROLE where id>=10000 union

select id,'AUTH_ORGANIZATION' as tablename from AUTH_ORGANIZATION where id>=10000 union

select id,'AUTH_PERMISSION' as tablename from AUTH_PERMISSION where id>=10000 union

select id,'AUTH_PRODUCT' as tablename from AUTH_PRODUCT where id>=10000 union

select id,'AUTH_PRODUCT_ABOUT'as tablename from AUTH_PRODUCT_ABOUT where id>=10000 union select id,'AUTH_ROLE' as tablename from AUTH_ROLE where id>=10000 union

select id,'AUTH_USER' as tablename from AUTH_USER where id>=10000 union

.........