table_exists
Checks whether an Oracle table exists using ALL_TABLES, excluding views, so you can verify table presence without writing a query.
Instructions
Return true if a table exists (checked via ALL_TABLES; views are NOT considered). Use this instead of run_query {SELECT 1 FROM ALL_TABLES WHERE ...}.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | Table name. | |
| schema | No | Schema (owner) of the table. Optional — defaults to the server's current schema; omit rather than guess. |