Win a copy of GANs in ActionE this week in the AI forum
or WebAssembly in Action in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Paul Clapham
  • Jeanne Boyarsky
  • Knute Snortum
Sheriffs:
  • Liutauras Vilda
  • Tim Cooke
  • Junilu Lacar
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Joe Ess
  • salvin francis
  • fred rosenberger

Book for SQL and PL/SQL

 
Ranch Hand
Posts: 104
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is there any single good book where SQL and PL/SQL is covered in depth.
 
Bartender
Posts: 2407
36
Scala Python Oracle Postgres Database Linux
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
No, but there are lots of good SQL books, and lots of good PL/SQL books, though.

For SQL in general, you probably need a general introduction to SQL and relational databases. There are lots of these, so maybe ask on the JDBC forum for recommendations.

For SQL with a specific Oracle focus, you could look at the exam guide for the Oracle Certified Associate exams, which will give you all the info on Oracle's implementation of SQL, including any Oracle-specific functions etc.

For PL/SQL there is another Oracle exam guide, but my own favourite is Steven Feuerstein's Oracle PL/SQL Programming, which has been the definitive PL/SQL book for many years in its various editions.

There is also an excellent book called Mastering Oracle PL/SQL by Connor MacDonald which includes some excellent material on high performance PL/SQL for dealing with large volumes of data.
 
They worship nothing. They say it's because nothing lasts forever. Like this tiny ad:
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!