Running SQL Commands Using the XE Home Page - Administration
In this fourth part of a five-part series on Oracle Database XE Administration, you will learn about the SQL*Plus command on Linux and Windows; you'll also learn how to run SQL commands using the XE home page. This article is excerpted from chapter 28 of the book Beginning PHP and Oracle: From Novice to Professional, written by W. Jason Gilmore and Bob Bryla (Apress; ISBN: 1590597702).
Regardless of whether you are using Linux or Windows, running SQL commands using the GUI follows the same procedure. Figure 28-5 shows the Oracle Database XE home page for the account RJB(you created this account in Figure 27-8 in Chapter 27). Note that for any account other thanSYS,SYSTEM, and other privileged accounts created during installation, you see the Application Builder icon on the Oracle Database XE home page. We’ll tell you more about the icons on the home page later in this chapter in the section “Using Oracle-Supplied Utilities.”
Note Accounts with system privileges can access the Application Builder menu as long as the account is notSYSorSYSTEM.
To execute SQL commands, use the SQL Commands function in the Oracle Database XE Web environment. Click the SQL icon shown in Figure 28-5, then click the SQL Commands icon on the next page to see the SQL Commands page shown in Figure 28-6. Type this command and click the Run button:
select * from hr.employees;
The SQL Commands window returns all rows from the tableHR.EMPLOYEESand formats them using a best-fit method depending on the datatypes and the size of the columns. You can use the scroll bars at the bottom of the browser window to see the remaining columns in the query result.
Alternatively, you can use the down arrow on the right side of each icon to navigate directly to the desired destination page.
Figure 28-5. The Oracle Database XE home page for the user RJB
Figure 28-6. The SQL Commands page
Please check back next week for the conclusion to this article.