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 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