PL/SQL project required [message #296125] |
Thu, 24 January 2008 14:03 |
gaurav200x
Messages: 17 Registered: December 2007
|
Junior Member |
|
|
Sir,
I have learnt PL/SQL in oracle 9i. I need a small project (back end only) so that i can master all the concepts so far... It will be great if u can advice some good project, with the required synopsis or provide some web link which has the same. I shall be highly grateful.
|
|
|
|
|
|
Re: PL/SQL project required [message #296290 is a reply to message #296165] |
Fri, 25 January 2008 10:34 |
gaurav200x
Messages: 17 Registered: December 2007
|
Junior Member |
|
|
Michel Cadot wrote on Fri, 25 January 2008 10:56 | In addition to Ross' answer: Database Sample Schemas
Regards
Michel
|
Dear All,
i think u misunderstood me. First of all, I need PROJECTS just to get a good knowledge of all the concepts. If possible a real life scenerio, otherwise, even small ones will do. Just need synopsis for the same and some guidance (only back end)
Secondly, it is for PL/SQL in 9i only.
|
|
|
|
Re: PL/SQL project required [message #296297 is a reply to message #296295] |
Fri, 25 January 2008 11:07 |
gaurav200x
Messages: 17 Registered: December 2007
|
Junior Member |
|
|
Michel Cadot wrote on Fri, 25 January 2008 22:10 | There is the same thing for 9i, just search in the documentation.
Regards
Michel
|
Dear Michael,
I am unable to find any questions/projects in the documentation with the above links. Can u please help me find it.
|
|
|
|
Re: PL/SQL project required [message #296301 is a reply to message #296299] |
Fri, 25 January 2008 11:28 |
gaurav200x
Messages: 17 Registered: December 2007
|
Junior Member |
|
|
varu123 wrote on Fri, 25 January 2008 22:47 | What kind of a project would it be with no front-end?
Buy Ivan Bayross book and practice payroll system,inventory system
|
Yes i do understand that when i say 'only back-end', it does sound weird, but i am planning to do only SQL, PL/SQL and then go for SAP.
Hence, i just wish to do minor projects to strengthen my grasp on the concepts.... Exceptions, composite data types, cursors, exceptions, procedures, functions, packages, triggers, files, etc.
I believe Bayross' book is by BPB publications... I searched for the same on the net, and found 4 relevant titles. Can u help me by giving me the exact name of the book.... which u're talking about.
81-7656-920-8 Professional Oracle Projects (WIN/Linux) Bayross 195/-
81-7656-964-X SQL, PL/SQL - The Prog. Language of Oracle - 3rd Rev. Edn. Bayross 360/-
-7656-870-8 Commercial Applications Development Using Oracle
Developer 9iDS and Oracle 9iAS on Linux Bayross 297/-
81-7656-691-8 Teach Yourself SQL/PL SQL using Oracle 8i & 9i with SQL J Bayross 390/-
|
|
|
|
|
|
Re: PL/SQL project required [message #333807 is a reply to message #333605] |
Mon, 14 July 2008 08:39 |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
I would say, go back to the top of this page and read the topic. You can make believe you were the original poster, then all the answers will now pertain to you. QED.
|
|
|