Solved

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

Posted on 2011-02-11
9
409 Views
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
0
Comment
Question by:ruavol2
  • 5
  • 2
9 Comments
 
LVL 73

Accepted Solution

by:
sdstuber earned 417 total points
ID: 34871377
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
 
LVL 73

Assisted Solution

by:sdstuber
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

0
 
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: www.oreilly.com.
0
 
LVL 73

Assisted Solution

by:sdstuber
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
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:ruavol2
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 AllAroundAutomations.com was a really good deal for the money.
0
 
LVL 73

Assisted Solution

by:sdstuber
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
0
 
LVL 73

Assisted Solution

by:sdstuber
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
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
 

Author Closing Comment

by:ruavol2
ID: 34874065
Very informative thank you.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

919 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now