Basic Syntax Highlighting and Auto-Completion. Enter key intelligently Auto-completes or Auto-Runs the query. Table names completion NYI.
目前为
Adds in basic Syntax Highlighting and Auto-Completion (which oracle should provide, but doesn't).
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 have been 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.
The CLI should do auto-completion, at least of the table names and columns. Finding the table names the first time is a pain, 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, who will be the only ones actually benefiting from this archaic interface you presented to us. Seriously, give us something closer to an actual command line. This is slow and bulky UI sucks.
Additional problems with Oracle's UI 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, terrible console, object browser, etc.
