Tell me more ×
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.
up vote 2 down vote favorite

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?

Thanks,

Alec Taylor

share|improve this 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
show 1 more comment

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, see the FAQ.

Browse other questions tagged or ask your own question.