Learn some of Oracle's gains

SQL Usage tips in Oracle:

• Use | | As a connector, for example:

selectlast_name| | job_id as "Employees" from Employees;

• When adding aliases to a column, you can enclose it in double quotation marks, which keeps the alias in lowercase, or a space in the middle.
• Output single quotation mark ', double quote '

sql> select "', '" ' fromdual; "'-------'    "

PL/SQL Developer Usage Tips:

• In command window, if the write SQL cannot be executed and you do not want to continue writing, use Shift+esc to terminate, similar to CTRL + C on the command line;
• F8 is a shortcut key for executing SQL statements;
• desc + table Name, you can view the table structure;
• The ED command displays the text editor, which may be useful when writing long-segment SQL, and then use/command execution;

Learn some of Oracle's gains