Supported Databases
Oracle
Extract Oracle schema metadata and generate Oracle-compatible SQL using the Oracle database profile.
Steps
1
Choose Oracle
Select Oracle so metadata queries use Oracle catalogue views and generated SQL uses the Oracle dialect.
2
Confirm the schema owner
Oracle object ownership replaces SQL Server conventions such as dbo. Use the correct owner and object names.
3
Run the extraction query
Execute it in your Oracle database tool and return the reviewed metadata output.
4
Review converted or generated SQL
Check date functions, pagination, identifiers, and Oracle version requirements.
Open the relevant SQL Mocker tool
Continue with this workflow in SQL Mocker when you are ready.