Home arrow Site Administration arrow Page 2 - Oracle Database XE: SQL and SQL Plus

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

  1. Oracle Database XE: SQL and SQL Plus
  2. Running SQL Commands Using the XE Home Page
By: Apress Publishing
Rating: starstarstarstarstar / 1
October 14, 2010

print this article



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
escort Bursa Bursa escort Antalya eskort


- Coding: Not Just for Developers
- To Support or Not Support IE?
- Administration: Networking OSX and Win 7
- DotNetNuke Gets Social
- Integrating MailChimp with Joomla: Creating ...
- Integrating MailChimp with Joomla: List Mana...
- Integrating MailChimp with Joomla: Building ...
- Integrating MailChimp with Joomla
- More Top WordPress Plugins for Social Media
- Optimizing Security: SSH Public Key Authenti...
- Patches and Rejects in Software Configuratio...
- Configuring a CVS Server
- Managing Code and Teams for Cross-Platform S...
- Software Configuration Management
- Back Up a Joomla Site with Akeeba Backup

Developer Shed Affiliates


Dev Shed Tutorial Topics: