#814 in Computers & technology books
Use arrows to jump to the previous/next product
Reddit mentions of Oracle PL/SQL Programming: Covers Versions Through Oracle Database 12c
Sentiment score: 3
Reddit mentions: 4
We found 4 Reddit mentions of Oracle PL/SQL Programming: Covers Versions Through Oracle Database 12c. Here are the top ones.
Buying options
View on Amazon.comor
O Reilly Media
Specs:
Height | 9.11 Inches |
Length | 7.14 Inches |
Number of items | 1 |
Weight | 4.13 Pounds |
Width | 2.37 Inches |
False. Oracle is a RDBMS. To query an Oracle DB, you use SQL, just like you do with almost all other RDBMS. Granted, each DB can have its slightly different syntax, but it's generally all the same.
PL/SQL is a object-oriented procedural language for SQL and the Oracle database. This is similar (but much more powerful and feature rich) to SQL Server's T-SQL. It's modeled after the language Ada, which in turn is modeled after Pascal.
Get familiar with the anonymous block and DBMS_OUTPUT.PUT_LINE. Toad is by far your best (although super pricey) IDE for PL/SQL and it's debugger is great.
Make sure to pick up a copy of this book. It's seriously the only book that I've ever seen multiple copies of at every single job I've had. My current job actually calls it "Steve's Book" and it's often referred to as the PL/SQL Bible:
Oracle PL/SQL Programming
I've been a PL/SQL developer for the past 10 years and I would say the best topics you could study up on to prepare are:
I would recommend reading the Oracle PL/SQL documentation - lots of good documentation here
Another excellent resource is this book
Best of luck to you!
On Oracle? Best book SQL / PL/SQL book I've ever bought : Excuse the lack of hyperlink, on my phone. http://www.amazon.co.uk/gp/aw/d/1449324452/ref=mp_s_a_1_1?qid=1394853719&sr=1-1&pi=AC_SX110_SY165
Yes you need to find the materials and book the exams yourself.
The materials generally consist of books which you read and practice examples from. If you are curious I can give you some recommendations however none of them are free.
This is a pretty good book for the first exam (half this book) and you can't get away with programming in PL/SQL without reading [this] (http://www.amazon.co.uk/gp/aw/d/1449324452/ref=mp_s_a_1_1?qid=1417646086&sr=8-1&pi=AC_SY200_QL40)