4 Using SQL Commands

Using SQL commands you can create, edit, view, run, and delete database objects.

• About SQL Commands
  You can use SQL Commands to create, edit, view, run, and delete database objects.
• Accessing SQL Commands
  Learn how to access SQL Commands.
• About the SQL Commands Home Page
  Learn about the SQL Commands home page.
• Using the Command Editor
  You use the command editor in SQL Commands to execute SQL commands within Oracle APEX.
• Saving an SQL Command
  You can save commands you enter in SQL Commands.
• Copying a Command
  Click Saved SQL from the SQL Commands page, click the name of the command to load into command editor, enter a name, and click Save.
• Viewing Results
  When you execute a SQL command, the results display in the display pane at the bottom of the SQL Commands home page.
• Using Explain Plan
  Explain plan parses a query and records the plan that Oracle devises to execute it.
• Using Saved Commands
  You can access the commands you save and commands saved by other users in the same workspace.
• Using SQL Command History
  You use SQL Command History to access commands you have executed in SQL Commands.

See Also:

• Oracle Database SQL Language Reference for detailed information about SQL statements and other parts of SQL, such as operators, functions, and format models.

• Oracle Database Concepts for conceptual information about SQL.

• SQL*Plus User's Guide and Reference for information about SQL*Plus, Oracle's version of SQL.

• Oracle Database Sample Schemas for information about the HR sample schema that is used for examples in this chapter.