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
  07-26-05 

Database Interaction with PL/SQL, Explicit Cursors

Jagadish Chatarji 129078

This article introduces the concept of explicit cursor. We will also examine different approaches to work with explicit cursor. This builds on the concept or cursors, which I looked at in my previous article along with looking at SQL cursor and cursor attributes.

  07-19-05 

Database Interaction with PL/SQL, Introduction to Cursors, Implicit Cursors

Jagadish Chatarji 89682

This is part nine of a series of articles focusing on database interactions with Oracle PL/SQL. In my previous article, we looked at different tips for using nested blocks together with exceptions. In this article, we will see how to handle exceptions centrally and have a look at cursors; we will also receive an introduction to the SQL cursor.

  07-12-05 

Database Interaction with PL/SQL: Nested Blocks in Depth

Jagadish Chatarji 68281

This is part eight of a series of articles focusing on database interactions with Oracle PL/SQL. In my previous article, I gave an introduction to user defined exceptions and nested blocks in PL/SQL. In this article, we will look into handling more than one exception and different tips on using nested blocks.

  07-05-05 

Database Interaction with PL/SQL: User defined Exceptions, Nested Blocks

Jagadish Chatarji 143188

This is part 7 of a series of articles focusing on database interactions with Oracle PL/SQL. In my previous article, I gave an introduction to exception handling and went through some predefined exceptions. In this article, we will focus on user defined exceptions in PL/SQL and some tips for working with exceptions efficiently.

  06-28-05 

Database Interaction with PL/SQL: Pre-defined Exceptions

Jagadish Chatarji 179282

This is part 6 of a series focusing on database interactions with Oracle PL/SQL. The previous articles discussed several types of collections in PL/SQL. Now Jagadish will look into exception handling using the predefined exceptions available in Oracle PL/SQL.

  06-21-05 

Database Interaction with PL/SQL: Nested Tables

Jagadish Chatarji 225777

This series has been focusing on database interactions with Oracle PL/SQL. Having just covered OBJECT TYPE in Oracle and both SQL and PL/SQL ways of working with OBJECTs in the last article, we will now learn about using NESTED TABLE with OBJECT TYPES from both SQL and PL/SQL point of views. We will also discuss FOR loops with an inline SELECT statement. This article is the fifth in this series.

  06-14-05 

Database Interaction with PL/SQL: OBJECT and OBJECT

Jagadish Chatarji 103959

Jagadish Chatarji has been writing about database interactions with Oracle PL/SQL. The last part examined using TABLE, RECORD and NESTED TABLES with PL/SQL. This one now introduces OBJECT TYPE in Oracle, and explains both SQL and PL/SQL ways of working with OBJECTs. This article is the fourth in the series.

  06-07-05 

Database Interaction with PL/SQL, part 3

Jagadish Chatarji 38453

Jagadish Chatarji has been writing about database interactions with Oracle PL/SQL. The last part started on TYPE, RECORD, and TABLE declarations of PL/SQL. This one now goes further into TABLE, RECORD, and using them together. It will also introduce NESTED TABLES.

  05-31-05 

Database Interaction with PL/SQL, part 2

Jagadish Chatarji 76193

This article picks up where part one left off. You will learn more about how to use %ROWTYPE and %TYPE, and be introduced to TYPE, RECORD, and TABLE declarations in PL/SQL.

  05-24-05 

Database Interaction with PL/SQL, part 1

Jagadish Chatarji 75151

This first article in a series focusing on database interactions with Oracle PL/SQL serves as a good introduction to the topic. It mainly focuses on the basics of retrieving information from the Oracle database using the SELECT..INTO statement, as well as two attributes, namely "%TYPE" and "%ROWTYPE." Readers should have some knowledge of RDBMS, Oracle SQL, and some very fundamental grounding in PL/SQL.

  05-05-05 

The Oracle Application Server 10g Infrastructure

McGraw-Hill/Osborne 144387

If you need to handle the administration and management of Oracle Application Server 10g, this article covers the metadata repository (iasdb), the Single Sign-On (SSO) security framework, and the Oracle Application Server 10g Management Services. It is excerpted from chapter 2 of the book, Oracle Application Server 10g Administration Handbook, written by John Garmany and Donald Burleson (McGraw-Hill/Osborne, 2004; ISBN: 0072229586).

  03-16-05 

Introduction to SQL

O'Reilly Media 89237

Interested in learning more about the SQL language? Read on to learn some of the useful features of this language. This article is excerpted from Mastering Oracle SQL by Sanjay Mishra and Alan Beaulieu (O'Reilly, 2004; ISBN 1590593006).

  01-03-05 

Oracle Stored Procedures

Mooh The Cow 4673460

So what's this business with Oracle allowing programmers to put programs in databases? That's right. They're called Oracle stored procedures, and they're quite useful. Mooh the Cow walks you through writing, creating, debugging, and deleting a procedure.

  10-19-04 

Mastering the WHERE Clause

O'Reilly Media 272188

Gain the full power of SQL to write queries in an Oracle environment with this updated book (new information on Oracle 10g). This chapter focuses on the role of the WHERE clause in SQL statements and the various options available when building a WHERE clause. (Mastering Oracle SQL by Sanjay Mishra and Alan Beaulieu, O'Reilly, ISBN: 596006322.)

  09-01-04 

Availability and Recovery

McGraw-Hill/Osborne 257105

Oracle Database 10g comes with a number of new features such as new features in flashback, Data Guard and transaction recovery monitoring. Also covered here are RMAN improvements and general database recovery improvements. (From the book, Oracle Database 10g New Features, by Robert Freeman, McGraw/Hill-Osborne, 2004, ISBN: 0072229470.)

 
More Oracle Articles
Total Oracle Articles = 154

Page 10 of 11
7 8 9 10 11 

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: