PLSQL case study

I am learning PLSQL, when I read the code I can understand well, but I have some problem if I have to write a brand new procedure. Are there any sources or books or case study for me to practice writing the procedures????

thanks

http://tahiti.oracle.com losta stuff there

smontgo,

could you please more specific, I did search in http://tahiti.oracle.com for an hour but I didn't find anything that was related to PLSQL case study.

thanks,

Quote:

---

Originally posted by learning_plsql
could you please more specific, I did search in http://tahiti.oracle.com for an hour but I didn't find anything that was related to PLSQL case study.

---

lemme get this right. You searched metalink for an hour to find examples of how to create a procedure and didn't find anything? You spent an hour looking for a case study and cound't come up with any of your own? I just don't get it.?.?.? :confused: Would you like somebody to post the source code for an entire application?

got to tahiti and list all the book and you'll see

PL/SQL User's Guide and Reference
Supplied PL/SQL Packages and Types Reference

Quote:

---

Originally posted by learning_plsql
I am learning PLSQL, when I read the code I can understand well, but I have some problem if I have to write a brand new procedure. Are there any sources or books or case study for me to practice writing the procedures????

thanks

---

Do you mean that you are looking for example problems to code?

yea, I just want to find the example where so I can practice to code. What Jeff mentioned is not right, I am expecting the source code. I only look for example so I can practice coding myself.

thanks all, including Jeff.

tahiti.oracle.com
asktom.oracle.com

Jeff and all,

I guess I am not clear myself. Any way, I am looking for some sample data and a long with example in common English of what need to be done and I can write PLSQL.

perhaps you dont get it,

everything you want is at the sites mentioned by Jeff

yeah you've been given your answer many times over

if you're looking for sample data you can always do things like
create table my_table as select* from all_objects or if you run the dbca in 9i you have the option to create it with sample hr data (the schemas are fully documented at tahiti as well)

what's so hard to understand :confused: