Previous Next JavaScript must be enabled to correctly display this content

## 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 AI Database SQL Language Reference for detailed information about SQL statements and other parts of SQL, such as operators, functions, and format models.
- Oracle AI Database Concepts for conceptual information about SQL.
- Oracle AI Database Sample Schemas for information about the `HR` sample schema that is used for examples in this chapter.