Opera SQL

When the user permission OPERA SQL is active the Opera SQL utility real-time diagnostic and resolution tool for Oracle databases is available only to Oracle database administrators for researching and resolving database errors and performance issues.

Note: When the General>Mask Credit Card Number application parameter is set to Y or N, regardless of whether you have Reservations>Credit Card Information Edit permission, credit card numbers will be masked with X's (except for the last 4 digits); expiration dates will be masked with X's (expired dates are shown as EXP).

Opera SQL Screen

SQL Command String Window. Place to enter the SQL Command String.

Result. View the outcome of a particular SQL action, operation, or command.

Function Button

Execute SQL. Begin and carry through to completion the SQL command string.

SQL Editor. SQL Editor is an explorer and code editor combined, for the Opera SQL Server databases. With it, database administrators can find code, change it and create a release script for it, all from the same application.

Change User. Displays the Login screen to login to a different property.

Commit. Commits the current transaction. All changes made by the transaction become visible to others and are guaranteed to be durable if a crash occurs.

Rollback. Rolls back the current transaction and causes all the updates made by the transaction to be discarded.

Export. Select to export the results to a user-defined location (the default is D:\MICROS\Opera\Export\ <schema_name>\ <resort>\operasql)as a text. Once the file is exported to the defined location, it can then be viewed, emailed, etc.

Close. Close the SQL Editor.