Oracle queries the names and data of all data tables with IDs greater than 10000

SQL code used to query the names and data of tables with IDs greater than 10000 in Oracle -- query the data with IDs greater than 10000 in all tables and the corresponding table name select 'select id, ''' | table_name | ''' as tablename from '| table_name | 'where id> = 10000 unival' from user_tables; www.2cto.com SQL code -- The result is as follows: 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 .........