![]() ![]() ![]() In Explain Plan Mode, select this button to return to the Query Mode.Ĭlose. (Available in Query and Explain Plan Modes.) In Query Mode, select this button to remove the existing SQL Command String and Results. (Only available in Query Mode.) Select this button to copy and paste the entire query results into the desired format.Ĭlear. Once the file is exported to the defined location, it can then be viewed, emailed, etc.Ĭopy. (Available in Query and Explain Plan Modes.) Select to export the results to a user-defined location (the default is D:\MICROS\OPERA\Export\ \\operasql) as a text. (Only available in Query Mode.) Rolls back the current transaction and causes all the updates made by the transaction to be discarded.Įxport. All changes made by the transaction become visible to others and are guaranteed to be durable if a crash occurs. (Only available in Query Mode.) Commits the current transaction. ![]() Having the SQL Command Statements display here makes the OPERA SQL tool more convenient for support purposes.Ĭommit. Selecting this button displays similar information as that in the User Activity Log screen ( Miscellaneous>User Activity Log). The History button is available for users granted the permission GENERAL>SHOW SYSTEM LOG. (Only available in Query Mode.) Displays the OPERA SQL History screen where previously executed SQL Command Statements display (those executed since v5.0.04.01 implementation only). With the SQL Editor, database administrators can find code, change it and create a release script for it, all from the same application. (Only available in Query Mode.) SQL Editor is an explorer and code editor combined for the OPERA SQL Server databases. (Only available in Query Mode.) Begin and carry through to completion the SQL command string. The only buttons available in the Explain Plan mode are Clear, Export, and Close. The Result Grid will display the Explain Plan. To view the Explain Plan for the query, place your pointer in the area above the Execute SQL button and select Alt and click. The Explain Plan mode screen can be accessed after a query has been made in Query Mode and at least one row appears in the Results grid. View the outcome of a particular SQL action, operation, or command. Enter the SQL Command String in this area. SQL Command String Window (Upper window). For more detailed information on other available functionality in this mode, see Buttons. Query Mode DescriptionĪt the Query Mode screen, you can enter SQL Command Strings and view results. 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 Xs (except for the last 4 digits) expiration dates will be masked with Xs (expired dates are shown as EXP). Users who view the User Activity Log for statements run from the OPERA SQL utility must be granted the permission GENERAL>SHOW SYSTEM LOG. If a statement is not successful due to syntax errors or other issues, the statement will not be logged. The User Log will contain the user ID, workstation, date and time, the statement text, and type of statement, i.e. See Explain Plan Mode below.įor security purposes and to be PCI compliant, each successful SQL statement the user runs through OPERA SQL is recorded and saved for a limited time in the User Activity Log. The Explain Plan mode is available after a query has been made (SQL command string entered and Execute SQL selected). In this mode you can make queries and use all of the functions available with the OPERA SQL utility. The Query Mode is available when users first access OPERA SQL. The OPERA SQL utility has two modes: Query Mode and Explain Plan Mode. Access the OPERA SQL tool by selecting Utilities>Tools>OPERA SQL. When the user permission UTILITIES>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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |