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
  05-19-11 

Oracle Database Backup and Recovery Practices

Apress Publishing 15861

Database failures are often a matter of when, not if. This three-part article series walks you through the best practices for backing up and recovering Oracle Database XE. It is excerpted from chapter 30 of the book Beginning PHP and Oracle: From Novice to Professional, written by W. Jason Gilmore, Bob Bryla (Apress; ISBN: 1590597702).

  05-12-11 

Oracle Date Functions in PL/SQL

Codex-M 33079

In this tutorial you will learn how to use Oracle date Functions using PL/SQL, including: to_date, to_char, sysdate, round, trunc, add_months, months_between, and last_day.

  05-05-11 

Oracle String Functions with PL/SQL

Codex-M 109603

This is an introductory tutorial of the most commonly used Oracle string functions using PL/SQL. Oracle string functions help you become efficient in retrieving string information from an Oracle database.

  04-21-11 

Oracle Debugging Tips using Oracle SQL Developer

Codex-M 59699

Oracle is one of the most important relational database implemented both in big and small corporations. This is a beginner tutorial that will walk you through common debugging techniques and tips in Oracle using SQL Developer.

  04-14-11 

Modifying Oracle PL/SQL Subprograms

Apress Publishing 6371

In this conclusion to a six part series, we look at how to modify, replace, and delete subprograms in Oracle PL/SQL. This article is excerpted from chapter 36 of the book Beginning PHP and Oracle: From Novice to Professional, written by W. Jason Gilmore and Bob Bryla (Apress; ISBN: 1590597702).

  04-07-11 

Oracle PL/SQL Stored Functions

Apress Publishing 21471

In this fifth part of a six part series, we look at how to create and use a stored function in Oracle PL/SQL. This article is excerpted from chapter 36 of the book Beginning PHP and Oracle: From Novice to Professional, written by W. Jason Gilmore and Bob Bryla (Apress; ISBN: 1590597702).

  03-29-11 

Oracle PL/SQL Control Structures and Loops

Apress Publishing 46731

In this fourth part of a six part series, we look at the CASE statement and learn how to create loops in Oracle PL/SQL. This article is excerpted from chapter 36 of the book Beginning PHP and Oracle: From Novice to Professional, written by W. Jason Gilmore and Bob Bryla (Apress; ISBN: 1590597702).

  03-22-11 

Oracle PL/SQL Subprogram Conditionals and Variables

Apress Publishing 19772

This article is excerpted from chapter 36 of the book Beginning PHP and Oracle: From Novice to Professional, written by W. Jason Gilmore and Bob Bryla (Apress; ISBN: 1590597702).

  03-16-11 

Six Must Know Oracle Commands

Codex-M 59757

Oracle is one of the top relational databases in the world and has been used by Fortune 500 companies such as Exxon Mobil, Wal-mart, General Electric and many others. In this tutorial, we will show you six "must know" Oracle SQL commands.

  03-07-11 

Subprocedures and Oracle PL/SQL Subprograms

Apress Publishing 18657

In this second part of a six-part series on Oracle PL/SQL subprograms, you will learn how Oracle implements subprograms, and how to create a stored procedure. This article is excerpted from chapter 36 of the book Beginning PHP and Oracle: From Novice to Professional, written by W. Jason Gilmore and Bob Bryla (Apress; ISBN: 1590597702).

  03-03-11 

Oracle PL/SQL Subprograms

Apress Publishing 15707

PL/SQL subprograms can be thought of as shortcuts that help you to perform certain kinds of Oracle queries less painfully as your applications increase in size and complexity. Keep reading to learn how you can use them to make your programming life a little easier. This article is excerpted from chapter 36 of the book Beginning PHP and Oracle: From Novice to Professional, written by W. Jason Gilmore and Bob Bryla (Apress; ISBN: 1590597702).

  02-24-11 

Transaction Statements in Oracle and PHP

Apress Publishing 12327

In this second part of a two-part series on how to properly handle transactions with Oracle databases, you'll learn how to use rollback statments, the savepoint statement, and how to complete transactions with PHP. This article is excerpted from chapter 33 of the book Beginning PHP and Oracle: From Novice to Professional, written by W. Jason Gilmore and Bob Bryla (Apress; ISBN: 1590597702).

  02-17-11 

Transactions and Databases

Apress Publishing 8368

Properly grouped transactions can enhance the logical consistency of your database. This two-part series will give you an overview of how to use transactions with an Oracle database. It is excerpted from chapter 33 of the book Beginning PHP and Oracle: From Novice to Professional, written by W. Jason Gilmore and Bob Bryla (Apress; ISBN: 1590597702).

  02-10-11 

Auditing to Secure Oracle Database XE

Apress Publishing 12248

In this conclusion to a ten-part article series on securing Oracle Database XE, you will learn about statement auditing, privilege auditing, and more. This article is excerpted from chapter 31 of the book Beginning PHP and Oracle: From Novice to Professional, written by W. Jason Gilmore and Bob Bryla (Apress; ISBN: 1590597702).

  02-03-11 

Roles and Auditing for Oracle Database XE

Apress Publishing 8349

In this ninth part of a ten-part article series on securing Oracle Database XE, you'll learn about default roles, password-enabled roles, and database auditing. This article is excerpted from chapter 31 of the book Beginning PHP and Oracle: From Novice to Professional, written by W. Jason Gilmore and Bob Bryla (Apress; ISBN: 1590597702).

 
More Oracle Articles
Total Oracle Articles = 154

Page 3 of 11
1 2 3 4 5 6 7 

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: