3 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 Application Express.
• 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