C-cC-c compile PL/SQL buffer (must be in plsql-mode) and show errors.C-cC-s show database object definition (retrieved from Oracle).M-RET explain execution plan for command under point.C-S-RET execute command under point and show result table in HTML buffer.in sqlplus-mode or plsql-mode you can easy go to the definition of database object name under point (table, view, synonym, index, trigger, package, function, procedure) in filesystem.if you use plsql.el for editing PL/SQL files, you can compile such sources and error messages will be parsed and displayed for easy source navigation.input buffer for each connection can be saved into file on disconnect and automatically restored during next connect (see ‘sqlplus-session-cache-dir’ variable) if you place some SQL*Plus commands between ‘/* init */’ and ‘/* end */’ comments in saved input buffer, they will be automatically executed on every connect.commands for fetching any database object definition (package, table/index/sequence script).history (log) of executed commands - see ‘sqlplus-history-dir’ variable,.font locking with database object names highlighting,.you can use many SQL*Plus processes simultaneously,.table will be cutted if you try to fetch too many rows (SELECT * FROM MY_MILLION_ROWS_TABLE) current SQL*Plus command will be automatically interrupted under the hood in such cases.tables are parsed, formatted and rendered with colors, like in many GUI programs you can see raw SQL*Plus output also, if you wish.Pezaris, Martin Schwenke), but offers more features: This package was inspired by sqlplus-mode.el (Rob Riepel, Peter D. Moreover, this package complements Lisp : plsql.el (Kahlil Hodgson) upon convenient compilation of PL/SQL source files. Facilitates interaction with Oracle via SQL*Plus.

Toad sql plus