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
  09-12-05 

Database Interaction with PL/SQL, User-defined Packages

Jagadish Chatarji 91831

This article is part of a series focusing on database interactions with Oracle PL/SQL. In my previous article, we examined named notation, default values of parameters, stored procedures, stored functions and finally took our first look at package and package body. In this article, we will focus completely on package and package body. Before reading this article I suggest you to go through my last three articles in this series thoroughly.

  09-06-05 

Database Interaction with PL/SQL, Named Notations, Storing Procedures and Functions

Jagadish Chatarji 54893

This is part 16 of a series of articles focusing on database interactions with Oracle PL/SQL. In my previous article, we worked with PL/SQL TABLE types in between sub-programs. In this article, we will look into Named Notation, default values of parameters, stored procedures, stored functions and finally introduce the concepts of package and package body.

  08-30-05 

Database Interaction with PL/SQL, Working with TABLE in Sub-programs, Parameter Modes

Jagadish Chatarji 78354

This is part 15 of a series of articles focusing on database interactions with Oracle PL/SQL. In my previous article, we looked at several examples that covered the use of sub-programs. In this article we will work with PL/SQL TABLE types in between sub-programs. We will also discuss IN, OUT and IN OUT types of parameters in this article.

  08-23-05 

Database Interaction with PL/SQL, RECORD and TABLE in Sub-programs

Jagadish Chatarji 48859

This is part 14 of a series of articles focusing on database interactions with Oracle PL/SQL. In my previous article, we concentrated on some tips for using procedures together with the introduction to functions. In this article we will look through several examples that cover using sub-programs in a very effective manner. I suggest you to go through part two in order to follow this article properly.

  08-16-05 

Database Interaction with PL/SQL: Sub-programs in Depth

Jagadish Chatarji 33713

This is part 13 of a series of articles focusing on database interactions with Oracle PL/SQL. In my previous article, we concentrated on procedures and discussed some issues of variable scoping with respect to sub-programs. In this article we proceed with some tips on using procedures together with the introduction to functions.

  08-09-05 

Database Interaction with PL/SQL: Introduction to Sub-programs

Jagadish Chatarji 31252

This is part 12 of a series of articles focusing on database interactions with Oracle PL/SQL. In my previous article, I looked at several examples of explicit cursors. I also introduced the concept of cursors with parameters. In this article we will look into sub-programs. Mainly we will concentrate on procedures and discuss some issues of variable scoping with respect to sub-programs.

  08-02-05 

Database Interaction with PL/SQL: Explict Cursors in Depth

Jagadish Chatarji 48549

This is part 11 of a series of articles focusing on database interactions with Oracle PL/SQL. In my previous article, I introduced the concept of the explicit cursor and looked at several approaches for using the explicit cursors. In this article, we shall delve more deeply into explicit cursors.

  07-26-05 

Database Interaction with PL/SQL, Explicit Cursors

Jagadish Chatarji 115686

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 77874

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 44029

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 116792

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 123595

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 181948

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 83118

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 32283

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.

 
More Oracle Articles
Total Oracle Articles = 146

Page 9 of 10
6 7 8 9 10 



© 2003-2012 by Developer Shed. All rights reserved. DS Cluster 11 - Follow our Sitemap

Dev Shed Tutorial Topics: