Basic Syntax Highlighting and Auto-Completion. Enter key intelligently Auto-completes or Auto-Runs the query. Table names completion NYI.
当前为
Console Enhancements for iacademy.oracle.com
Adds in basic Syntax Highlighting and Auto-Completion.
Enter key intelligently Auto-completes or Auto-Runs the query.
Table names completion is NYI.
While its possible to do, table name completion would:
1) Cause delay in first load of the SQL Command Center
2) Require caching tables/columns locally to reduce lag, and thus need to intelligently sync the cache somehow.
3) Require permanent storage to remove lag between reloads/restarts.
I personally believe that all of these changes should be implemented by oracle into their site. Justification below
The CLI does not support running multiple queries. As such, it should auto-run by default when enter is pressed. Or when the query is properly closed with a semicolon and enter is pressed(Give us something closer to an actual command line).
The CLI should do auto-completion, at least of the table names and columns. Finding the table names the first time is difficult, especially since queries against user_tables and other dictionaries causes the site to reject all repeated queries. Claiming the estimated run-time of the query exceeds the 2 minute cap.
Syntax highlighting isn't necessary, but its a big help. Especially for anyone with little to no experience programming.
Additional UI downfalls that we do not address:
Comments conditionally work. (Only '--' comments work, and its finky about what lines you can put them on)
All methods of looking up available tables have a 30 seconds to 2 minute delay, an may time out all subsequent queries.
