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

Large Database Features In Oracle

McGraw-Hill/Osborne 188308

When you are working with large databases with Oracle Database 10g, there are certain topics with which you need to be familiar. These topics are covered in this article, the first of two parts. It is excerpted from chapter nine of the book Oracle Database 10g A Beginner's Guide, written by Ian Abramson et al (McGraw-Hill/Osborne, 2004; ISBN: 0072230789).

  11-01-05 

Generic Architecture for Caching Table Data: Hello Cache, How Are You Doing?

Mark Vilrokx 20995

Now that you have set up a functioning cache, are you sure it's giving you the performance enhancements you need? Keep reading to learn three ways to check the performance of your cache.

  10-25-05 

Generic Architecture for Caching Table Data: Keeping It Real (and Small)

Mark Vilrokx 16708

In the third installment of this series we will add some more functionality to the cache that will alleviate some of the drawbacks that we discussed in earlier articles.

  10-20-05 

Row-Level Security with Virtual Private Database

McGraw-Hill/Osborne 215136

Oracle's Virtual Private Database technology provides a logical and elegant method for applying security to the data within database tables. This article explains how VPD can be used to provide row-level security. It was excerpted from chapter 11 of Effective Oracle Database 10g Security by Design, written by David C. Knox (McGraw-Hill/Osborne, 2004; ISBN: 0072231300).

  10-18-05 

Generic Architecture for Caching Table Data: Supercharge Your Cache

Mark Vilrokx 19111

In the first part of this series we started of by putting the basic structures in place for a cache and wrote some code to manage the cache. In this next part, we will extend the functionality of our cache.

  10-11-05 

Generic Architecture for Caching Table Data: Supercharge Your PL/SQL Applications

Mark Vilrokx 40597

In this series I am going to introduce you to a generic PL/SQL caching architecture. The goal is to give you an understanding of how you can store Table data in PL/SQL collections (“the cache”) and how to retrieve data from those same PL/SQL collections. The proposed architecture will be generic enough for you to use throughout your applications everywhere you need to retrieve data from the database (and isn’t that what PL/SQL applications are all about?).

  10-06-05 

Tuning Your Database for Availability

McGraw-Hill/Osborne 126121

When dealing with databases, uptime is not the only issue; if the database is up but slow, the end user will still be unhappy. Fortunately, there are ways to tune an Oracle database to deal with this issue, which is the subject of this article. It is excerpted from chapter three of Oracle Database 10g High Availability with RAC, Flashback and Data Guard, written by Matthew Hart and Scott Jesse (McGraw-Hill/Osborne, 2004; ISBN: 0072254289).

  09-22-05 

Securing the Database

McGraw-Hill/Osborne 112993

If you work with Oracle databases, you will want to know how to secure them. This article focuses on a number of steps you can take, representing the best practices used in organizations today, to secure an Oracle database. It is excerpted from chapter 2 of the book Effective Oracle Database 10g Security by Design, written by David C. Knox (McGraw-Hill/Osborne, 2004; ISBN: 0072231300).

  09-12-05 

Database Interaction with PL/SQL, User-defined Packages

Jagadish Chatarji 109291

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 65234

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 99350

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 75714

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 43378

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 35978

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 69510

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.

 
More Oracle Articles
Total Oracle Articles = 154

Page 9 of 11
6 7 8 9 10 11 

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: