Running SQL Commands Using the XE Home Page - Administration

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.

>>> More Site Administration Articles          >>> More By Apress Publishing

blog comments powered by Disqus