Watch, Follow, &
Connect with Us

Please visit our new home
community.embarcadero.com.

Public Report
Report From: Conference/US/2006/Delphi    [ Add a report in this area ]  
Report #:  32421   Status: Open
Oracle at Delphi by Jim McKeeth
Project:  Conference Build #:  No
Version:    1 Submitted By:   Christine Ellis
Report Type:  Suggestion / Enhancement Request Date Reported:  8/7/2006 3:16:41 PM
Severity:    Infrequently encountered problem Last Updated: 8/28/2006 1:37:35 PM
Platform:    All platforms Internal Tracking #:  
Resolution: None  Resolved in Build: : None
Duplicate of:  None
Voting and Rating
Overall Rating: (15 Total Ratings)
3.93 out of 5
Total Votes: 2
Description
Oracle at Delphi by Jim McKeeth
TYPE: Regular Session
LEVEL: Advanced
PREREQUISITES: Familiarity with Oracle and Database Development using Delphi
ABSTRACT: Oracle is the Big Iron of databases. This session will mainly focus on how to take advantage of some of Oracle's more powerful and complex features. While the main focus will be Oracle with Delphi developers of other languages will be able to gain something from this session.

Oracle provides a very descriptive data dictionary, but it doesn't do a developer any good if they don't know their way around in it. After a short overview of the data dictionary we will look closely at what kind of data you can get and how to find it. Then we will look at some complex queries which provide some very useful information about your database.

Oracle has a very useful programming language that extends SQL. A quick overview will help developers start to take advantage of programming inside the database.

Histories of Delphi and Oracle
Where Delphi got its name
Inside Oracle's Data Dictionary

DBA, USER and ALL views

Getting the data model
PL/SQL

Retrieving from Delphi

Writing from Delphi

Compiling from Delphi

Programming in Oracle
Triggers
Stored Procedures

.NET Stored procedures
Stored Functions
Calling Delphi from Oracle

From triggers

From stored procedures
Complex calls

After the completion of this session attendees will be ready to take advantage of this advanced functionality of Oracle from Delphi.
SPEAKER BIOGRAPHY: Jim McKeeth is a software developer with over 15 years of experience in developing software and building online communities. He runs the Boise Software Developers Group, Idaho s longest running group of its kind. Jim works at Washington Group International as a Senior Software Engineer. He is a certified trainer and has shared the stage with some of the top trainers on the continent. Jim maintains a number of successful blogs and enjoys spending time with his wonderful family.
Steps to Reproduce:
None
Workarounds
None
Attachment
None
Comments

None

Server Response from: ETNACODE01