Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

This question only needs one answer: a list of great resources for getting started with Oracle, including Database Administration, PL/SQL and SQL.

You may find your question has been closed as a duplicate of this one, if so, please don't be offended: we are trying to be as helpful as we can without diluting the expert focus of this site. Closing a question as a duplicate of this one is us saying "What you really need is to spend some time reading some of the best resources available rather than have your specific question answered right now. If you do get through these resources, you'll soon be back with more advanced questions!

share|improve this question
2  
If you are curious why this question exists, please see this on meta and this discussion in The Heap. –  Jack Douglas Jan 4 '14 at 11:52

3 Answers 3

Oracle's official documentation library has some great resources, including:

Oracle 12c official PL/SQL documentation:

PL/SQL 101

This is a twelve part series of articles on understanding and using PL/SQL. It is written by Steven Feuerstein and published in Oracle Magazine.

  1. Building with Blocks
  2. Controlling the Flow of Execution
  3. Working with Strings
  4. Working with Numbers in PL/SQL
  5. Working with Dates in PL/SQL
  6. Error Management
  7. Working with Records
  8. Working with Collections
  9. Bulk Processing with BULK COLLECT and FORALL
  10. The Data Dictionary: Make Views Work for You
  11. Wrap Your Code in a Neat Package
  12. Working with Cursors
share|improve this answer
    
Please feel free to edit in others that come to mind or add your own specific advice useful to the kind of people likely to end up here. –  Jack Douglas Jan 4 '14 at 12:55

When I learned PL/SQL I started with Steven Feuerstein's PL/SQL Best Practices. Several more edition have come out, but it gives you a good perspective on how to think about code.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.