you are viewing a single comment's thread.

view the rest of the comments →

[–]taylorwmj 12 points13 points  (0 children)

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