Need help learning how to create stored proceedures and Oracle queries.

Posted on 2011-02-11
Last Modified: 2013-12-19
Does anyone know of any really good simple learning materials, cbts out there that are excellent at helping one learn the ins and outs of Oracle 10 and creating stored procedures in real world environments? Any support is greatly appreciated. Thank you
Question by:ruavol2
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
LVL 74

Accepted Solution

sdstuber earned 417 total points
ID: 34871377
I would start with the Oracle PL/SQL Documentation

and Steven Feurstein's Oracle PL/Programming
and Feurstein's "obsession" web site
LVL 74

Assisted Solution

sdstuber earned 417 total points
ID: 34871409
and, of course,  ask more questions here on Experts-Exchange about specific features or queries you are having trouble with.

and, the best learning is doing,  write some code to do...anything.  Just write.
If you need inspiration,  try to answer other user's questions on EE.

I'm a better developer than I used to be due of answering other people's questions

LVL 35

Assisted Solution

by:Mark Geerlings
Mark Geerlings earned 83 total points
ID: 34873319
Among the published authors that I know of in the Oracle world, Steve Feuerstein certainly is the best.  Maybe his stuff does not qualify as "simple learning material" but it certainly does qualify as the best available. I think his book "Oracle PL\SQL Programming" by O'Reilly is still available.  Check:
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

LVL 74

Assisted Solution

sdstuber earned 417 total points
ID: 34873438
I also recommend Tom Kyte's "Expert Oracle Database Architecture"

for good explanations of many features of Oracle with lots of examples

Author Comment

ID: 34873497
I learn really well by seeing then doing. Used to take cars motorcycles and tractors apart then put them back together. Are their any videos or cbt's dvds out there that you guys know of.

I did just get a book Oracle Database PL/SQL Programming McGraw Hill/Osborne  Oracle Press
Does anyone recommend any tools. I heard that PL/SQl Developer by was a really good deal for the money.
LVL 74

Assisted Solution

sdstuber earned 417 total points
ID: 34873594
Oracle's SQL Developer  is free and not bad

PL/SQL Developer is good

Toad is awesome but expensive
LVL 74

Assisted Solution

sdstuber earned 417 total points
ID: 34873643
Feurstein's PL/SQL obsession has lots of code examples

Look through the PL/SQL zone here on EE, many people have asked "real world" problems and had them answered,  many times the question will be a simple syntax question, but some will include full code examples too.

I wrote a couple of articles that have code examples too
These weren't written to be instructional code, but you're more than welcome to pull them apart and put them back together to see how they work.

A PL/SQL Example of a ftp utility package with snippets of sample usage

A fairly complex SQL query showing several different techniques

Author Closing Comment

ID: 34874065
Very informative thank you.

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
format dd/mm/yyyy parameter 16 60
oracle query 3 35
only show the last 365 days 6 35
DB Shutdown Automatically 11 37
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question