Everything about PL/SQL

🧭 Start here: a 6-step reading path

1. Read the overview: PL/SQLA 5-minute orientation
2. Skim a recent paper: RESDSQL: Decoupling Schema Linking and Skeleton Parsing for Text-to-SQLInfluential work since 2022
3. Pick up a classic book: Oracle PL/SQL LanguageThe most-reprinted book on the subject
4. Read the landmark paper: Scalable SQL and NoSQL data storesCited 930 times
5. Go sideways: Cursor (databases)A closely related topic
6. Go sideways: Stored procedureA closely related topic

🏆 Landmark papers (most cited)

• Scalable SQL and NoSQL data stores

  Rick Cattell · 2011 · ACM SIGMOD Record · 930 citations

• Text-to-SQL Empowered by Large Language Models: A Benchmark Evaluation

  Dawei Gao, Haibin Wang, Yaliang Li · 2024 · Proceedings of the VLDB Endowment · 338 citations

• SQL databases v. NoSQL databases

  Michael Stonebraker · 2010 · Communications of the ACM · 311 citations

• On optimizing an SQL-like nested query

  Won Kim · 1982 · ACM Transactions on Database Systems · 277 citations

• A critique of ANSI SQL isolation levels

  Hal Berenson, Phil Bernstein, Jim Gray · 1995 · ACM SIGMOD Record · 274 citations

• Spatial SQL: a query and presentation language

  M.J. Egenhofer · 1994 · IEEE Transactions on Knowledge and Data Engineering · 246 citations

• Towards practical differential privacy for SQL queries

  Noah Johnson, Joseph P. Near, Dawn Song · 2018 · Proceedings of the VLDB Endowment · 206 citations

• A survey on deep learning approaches for text-to-SQL

  George Katsogiannis-Meimarakis, Georgia Koutrika · 2023 · The VLDB Journal · 190 citations

🆕 Influential since 2022

• RESDSQL: Decoupling Schema Linking and Skeleton Parsing for Text-to-SQL

  Haoyang Li, Jing Zhang, Cuiping Li · 2023 · Proceedings of the AAAI Conference on Artificial Intelligence · 188 citations

• CodeS: Towards Building Open-source Language Models for Text-to-SQL

  Haoyang Li, Jing Zhang, Hanbing Liu · 2024 · Proceedings of the ACM on Management of Data · 143 citations

• SQL and NoSQL Database Software Architecture Performance Analysis and Assessments—A Systematic Literature Review

  Wisal Khan, Teerath Kumar, Cheng Zhang · 2023 · Big Data and Cognitive Computing · 135 citations

• Detection of SQL Injection Attack Using Machine Learning Techniques: A Systematic Literature Review

  Maha Alghawazi, Daniyal Alghazzawi, Suaad Alarifi · 2022 · Journal of Cybersecurity and Privacy · 106 citations

• The Dawn of Natural Language to SQL: Are We Fully Ready?

  Boyan Li, Yuyu Luo, Chengliang Chai · 2024 · Proceedings of the VLDB Endowment · 98 citations

📚 Books worth reading

• Oracle PL/SQL LanguageSteven Feuerstein · 1999
• Oracle PL/SQL ProgrammingSteven Feuerstein · 1995
• Oracle PL/SQL by exampleBenjamin Rosenzweig, Elena Silvestrova · 2003
• Oracle PL/SQL Best PracticesSteven Feuerstein · 2001
• Oracle PL/SQL for dummiesMichael Rosenblum, Paul Dorsey · 2006
• Oracle PL/SQL Built-insSteven Feuerstein · 1998
• 📕Oracle Database 11g R2Sideris Courseware Corporation · 2011
• Oracle PL/SQL ProgrammingSteven Feuerstein, Bill Pribyl · 1997

Ranked by number of editions on Open Library, a rough measure of how lasting a book is.

🔗 Related topics

• Cursor (databases) In computer science, a database cursor is a mechanism that enables traversal over the records in a database. Cursors facilitate processing in conjunction…
• Stored procedure A stored procedure (also termed prc, proc, storp, sproc, StoPro, StoredProc, StoreProc, sp, or SP) is a subroutine available to applications that access…
• Database trigger A database trigger is procedural code that is automatically executed in response to specific events on a table or view in a database. Triggers are commonly…
• Prepared statement In database management systems (DBMS), a prepared statement, parameterized statement, (not to be confused with parameterized query) is a feature where…
• Harbour (programming language) Harbour is a computer programming language, used mainly to create database/business programs. It is a modernised cross-platform version of the older Clipper…
• Java Database Connectivity Java Database Connectivity (JDBC) is an application programming interface (API) for the Java programming language which defines how a client may access…
• PL/pgSQL PL/pgSQL (Procedural Language/PostgreSQL) is a procedural programming language supported by the PostgreSQL ORDBMS. It closely resembles Oracle's PL/SQL…
• SQL Plus SQL Plus is the most basic Oracle Database utility, with a basic command-line interface, commonly used by users, administrators, and programmers. SQL Plus…