• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 419
  • Last Modified:

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

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
0
ruavol2
Asked:
ruavol2
  • 5
  • 2
6 Solutions
 
sdstuberCommented:
I would start with the Oracle PL/SQL Documentation
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/toc.htm

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


http://www.toadworld.com/Knowledge/DatabaseKnowledge/StevenFeuersteinsPLSQLObsession/tabid/153/Default.aspx
0
 
sdstuberCommented:
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

0
 
Mark GeerlingsDatabase AdministratorCommented:
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: www.oreilly.com.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
sdstuberCommented:
I also recommend Tom Kyte's "Expert Oracle Database Architecture"

for good explanations of many features of Oracle with lots of examples
0
 
ruavol2Tableau Trainer & Consultant Sales Exec.Author Commented:
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 AllAroundAutomations.com was a really good deal for the money.
0
 
sdstuberCommented:
Oracle's SQL Developer  is free and not bad

PL/SQL Developer is good

Toad is awesome but expensive
0
 
sdstuberCommented:
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
http://www.experts-exchange.com/A_3043.html

A fairly complex SQL query showing several different techniques
http://www.experts-exchange.com/A_3909.html
0
 
ruavol2Tableau Trainer & Consultant Sales Exec.Author Commented:
Very informative thank you.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now