The Enhanced Editor window is useful when you want to make changes in the SQL code. You can open the Enhanced Editor window from the SQL Editor window at any time.

Non-SELECT SQL statements can be saved to and executed from the Result Manager window. See Saving SQL Code or Output and Doing More with Results for information.

Advanced SQL Editor features print, cut, copy, paste, undo, redo, indent, unindent, search, search and replace, go to line code completion, syntax highlighting and optional line numbering.

Prophecy has announced the release of Prophecy 3.0, to provide first-of-its-kind, low-code SQL capabilities for business data users.