I found a <proficient in Oracle10g PL/SQL programming> on the internet, and I think this book is quite good. It is suitable for programmers who are new to Oracle to read it.
This book starts with some of the most basic knowledge and works with easy-to-understand examples to help you get started with simple knowledge points at and then go deeper step by step, each step will be used in concert with the example to explain to you. One small step at a time is the foundation of the next step, until the usage is relatively advanced.
Oracle10g PL/SQL programming tutorial book PDF: http://www.bkjia.net/thread-2173-1-1.html
This book also has the advantage that its language is very concise, not like some technical books, the technology is not much to talk about, but it is a bit of nonsense. this book can be a non-Nonsense pl SQL explanation. it directly tells you the most essential functional or linguistic phenomena in the most streamlined language. In my opinion, it is very suitable for our programmers who have been caught up by the project duration all day long to read.
This book is also very clear. The first two chapters first tell you what PL/SQL is, and then tell you how to use PL/SQL development tools.
The third chapter is a step-by-step introduction to the basics. from "SQL statement"/"SQL function" to "PL/SQL control structure" to "Exception Handling" to "Stored Procedure"/"function"/"cursor "/" trigger ", etc. along the way, you can have a good grasp of PL/SQL.
It can be said that what programmers need to do at the database level in the development process is nothing more than using this knowledge. It is very rare to use this knowledge. Other deeper things are the work of DBAs.
Objectively speaking, this book still has shortcomings, that is, some of the relatively advanced technologies are not introduced, such as parallel/performance tuning, I have also hardly mentioned any knowledge about database management. but I think this is also related to the positioning of this book. these topics should be of concern to DBAs.
To sum up, this small book <proficient in Oracle10g PL/SQL programming> is suitable for programmers who have no time to study PL/SQL. Of course, it is an entry-level book. if you are familiar with Oracle. this book is not suitable for you.