Home arrow Oracle
 

ORACLE HELP, ORACLE TUTORIALS, ORACLE PROGRAMMING, ORACLE TRICKS

RSS For Dev Shed
Oracle introduced the first Relational Database Management system based on the IBM System/R model and the first DBMS using IBM’s Structured Query Language (SQL) technology. In addition to its well-known 10g database, Oracle offers software for managing, sharing and protecting data and information. If your enterprise runs on Oracle, you’ll find what you need to keep it running smoothly here.

  Date Title Author Hits
  01-11-07 

Managing the Oracle HTTP Server

McGraw-Hill/Osborne 75930

Oracle HTTP Server (OHS) takes the Apache Web Server and significantly extends it. This article, the first of a five-part series, introduces you to the server. It is excerpted from chapter five of the book Oracle 10g Application Server Exam Guide, written by Sam Alapati (McGraw-Hill, 2006; ISBN: 0072262710).

  12-20-06 

Loading and Unloading XML Files Using Oracle 10G XE

Jayaram Krishnaswamy 104541

In many cases, exporting a table to create an XML file is easy, but importing an XML file to create a table is much more difficult. This is true for Oracle 10G XE, as you will see in this article.

  11-29-06 

Multi-Table Queries with Oracle 10G XE

Jayaram Krishnaswamy 119120

Queries are quantitative questions you pose to a database. Questions such as "how many employees make more than $20,000.00 a year?" or "which employee has worked for more than two years?" are typical examples. In some cases, to answer questions like the ones above, you may go no further than looking it up in one table. However some questions may need more than one table, and it is not uncommon that several tables must be used to provide the answer.

  11-14-06 

Inserting Sub-Queries in SELECT Statements in Oracle

Jagadish Chatarji 512914

This is the second article in a series concentrating on working with sub-queries in Oracle. My previous article (first in this series) explained the “dual” table in detail and gave a few practical examples of sub-queries. In this article, I shall introduce sub-queries at various interesting places within the same SELECT statement.

  11-07-06 

Stepping through Sub-Queries in Oracle

Jagadish Chatarji 139884

This is the first article in a series concentrating on working with sub-queries in Oracle. Sub-queries really have tremendous depth. In this series I will show you several scenarios where they can be efficiently used to retrieve information from Oracle databases.

  09-26-06 

Importing a CSV Text File into Oracle 10G XE

Jayaram Krishnaswamy 306251

If you need to deal with legacy data by moving it to more recent databases, this article might help. It will show you how to move data from an MS Excel file into an Oracle 10G XE table.

  09-19-06 

Creating a Table using Oracle 10G XE

Jayaram Krishnaswamy 186826

Oracle 10G XE provides a wizard to help you create a table. The wizard walks you through several steps for creating a table, taking you to the next step after you have entered valid entries for the current step. While scripts can be used to create a table, creating a table using the visual, form-based creation process is a lot simpler and less prone to errors. This tutorial describes a table to be created in the HR database with all the necessary ingredients for a typical database.

  08-29-06 

Oracle 10G XE User Management 101

Jayaram Krishnaswamy 91900

If you're a DBA, one of your basic tasks involves managing users: dropping, adding, and changing permissions. Even if you aren't a DBA, if you use a database, you may find it helpful to know the tasks that a DBA performs. This article explains the basics for how to perform these tasks in Oracle 10G XE.

  07-26-06 

Loading Spread Sheet Data into Oracle 10G XE

Jayaram Krishnaswamy 125222

If you have ever loaded data into an Oracle table, you know that it is a rather complicated process. You will be surprised at how much easier it is to do in Oracle 10G XE. Keep reading to find out.

  07-19-06 

Migrating from Oracle 10G XE to SQL Anywhere 10

Jayaram Krishnaswamy 33184

In a previous article, a set of tables from Oracle 10G XE were transferred to SQL 2005 Server using SQL 2005 Server's Export/Import Wizard. This article is about migrating a table from Oracle 10G XE to SQL Anywhere 10.

  07-12-06 

Creating an Oracle Web Service Client for a Web Service Created in VS 2005

Jayaram Krishnaswamy 177073

This tutorial takes you through the process of creating a web service client using the ApplicationBuilder interface in Oracle 10g XE. The client will access the services offered by a web service created using the Visual Studio 2005.

  07-05-06 

Developing Applications on Oracle 10g XE: Generating a Report

Jayaram Krishnaswamy 125926

This tutorial shows you how to create a report based on a table in the Oracle 10g XE database without stepping out of the IDE. It will show you how to manipulate the report and create a UI.

  06-28-06 

SQL Script Support in Oracle 10G Express Edition

Jayaram Krishnaswamy 188303

In an earlier tutorial we saw how to use SQL commands in the Oracle 10g Express Edition, or simply Oracle XE. We also saw how to use the PL/SQL commands as well. In another tutorial we saw how to use the Query Builder, the graphical interface for fashioning and running SQL in the Oracle XE. The present tutorial describes the SQL scripting support in Oracle XE. In order to bring out the basic features of scripting support a few example scripts are considered in the discussion.

  06-21-06 

Step-By-Step Guide to Importing Data from Oracle XE to SQL 2005

Jayaram Krishnaswamy 100431

Many enterprises need to move data from one kind of data source to another. This tutorial guides you through the steps necessary to move data from Oracle XE into a SQL 2005 Server database.

  06-14-06 

Using Query Builder in the Oracle 10g Express Edition

Jayaram Krishnaswamy 112997

In an earlier tutorial we saw how to use SQL commands in the Oracle 10g Express Edition, or simply Oracle XE. We also saw how to use the PL/SQL commands as well. In this tutorial we will see how to use the Query Builder, the graphical interface for fashioning and running SQL in the Oracle XE. The tutorial shows how to interact with the query builder to create a SELECT query in the context of a single table as well as a SELECT query from two related tables.

 
More Oracle Articles
Total Oracle Articles = 154

Page 7 of 11
4 5 6 7 8 9 10 

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: