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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Good afternoon,

I have a PL/SQL (&etc) exam in a few weeks, so I thought it would be good to do a couple of PL/SQL projects/assignments in preparation.

Can you give me a good resource of homework problems?


Alec Taylor

share|improve this question

closed as not a real question by gbn, Mark Storey-Smith, Jack Douglas Nov 7 '11 at 10:20

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

Is this a Oracle OCA/OCP exam? If so the best prep is practice tests eg from selftestsoftware. The question is not really a good fit for this site though - please see the faq (and this on meta) – Jack Douglas Nov 7 '11 at 10:20
Nope, it's not for a certification. I have been learning PL/SQL at university, and we have an exam testing our PL/SQL skills (amongst other things). So what I am looking for is an "assignment" which I can do to gain experience with PL/SQL. – A T Nov 7 '11 at 14:13
Can you get hold of past papers? – Jack Douglas Nov 7 '11 at 14:18
Create tables, views and packages wrapping ult_mail functionality. Methods should include Send(immediate), Queue(transactional), SendOrQueue(either), and process. A view should be created so that each user can see only their own emails. – Leigh Riffel Nov 7 '11 at 17:57
Thanks, can you reopen the question and post that as an answer? – A T Nov 8 '11 at 2:14

Browse other questions tagged or ask your own question.