apex_list_tables
List tables and views in the current Oracle schema with row counts. Filter by name pattern and object type, optionally including column details for schema analysis.
Instructions
List all tables/views in the current Oracle schema with row counts.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| pattern | No | SQL LIKE pattern to filter object names (default: all objects). Examples: "EMP%", "%DEPT%", "HR_%" | % |
| object_type | No | Which objects to list. One of: "TABLE" (default) — only USER_TABLES, "VIEW" — only USER_VIEWS, "ALL" — tables and views combined. Views will have num_rows = NULL. | TABLE |
| include_columns | No | Include column details for each object (default True). Set False for a quick name list only. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |