Home arrow Oracle arrow Page 4 - Learning to Query in Oracle XE

Example 3: Dual Tables - Oracle

Querying the database is one of the most common tasks that you may have to carry out routinely. This tutorial shows you the options for running SQL queries and how to run the queries against the database in the Oracle Express Edition, Oracle XE for short.

TABLE OF CONTENTS:
  1. Learning to Query in Oracle XE
  2. Running SQL Queries
  3. An Example from PL/SQL
  4. Example 3: Dual Tables
By: Jayaram Krishnaswamy
Rating: starstarstarstarstar / 26
June 07, 2006

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

Another of Oracle's very useful constructs is the Dual table. This is a table with just one column into which you can stuff your own value. Here is what you will get when you describe the Dual table.

 If you were to use a select query, Select 'hello' from dual, it would return 'Hello' in the Dummy column.

An example of using Dual

You could run a math function to be evaluated into dummy as shown in the next picture.

Summary

The SQL Command window of Oracle XE has is an extremely intuitive and user-friendly interface to run SQL, PL/SQL queries. The results of running a query against the database are provided in a single, tabbed window. The SavedSQL and history features provide links that will help refining and back tracking previously run queries.



 
 
>>> More Oracle Articles          >>> More By Jayaram Krishnaswamy
 

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort
   

ORACLE ARTICLES

- Oracle Java Security Woes Continue
- Oracle's New IaaS Cloud Option: There's a Ca...
- Oracle Acquires Eloqua to Boost Cloud Presen...
- Choosing Innovation: Oracle Survey Insights
- Oracle Fixes Privilege Escalation Bug
- Oracle`s Communications Service Availability...
- Oracle Releases Exalytics, Taleo Plans
- Oracle Releases Communications Network Integ...
- Oracle Releases Communications Data Model 11...
- Oracle Releases PeopleSoft PeopleTools 8.52
- Oracle Integrates Cloudera Apache Distro, My...
- Oracle Releases MySQL 5.5.18
- Oracle Announces NoSQL Database Availability
- Sorting Database Columns With the SELECT Sta...
- Retrieving Table Data with the LIKE Operator

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: