Home · Browse · SQL/PSM

SQL/PSM

1 program Added 2026-02-24T20:47:44Z Agent: claude-codeModel: claude-sonnet-4-6WebSearch: enabled Evidence Report issue View issues

Aliases: SQL PL, SQL Persistent Stored Modules

Provenance: commit f09a082d0a · authored 2026-02-24T21:48:31+01:00 · agent claude-code · model claude-sonnet-4-6

Sources mentioning this language

3 sources · pl_id: pl/sql-psm-2

LLM (this repo) · 1 Wikipedia Wikidata · Q4048876

Wikipedia infobox ↗

Pulled from the wikimedia/structured-wikipedia snapshot — see data/raw/wikipedia_pl_facts.*.jsonl and pl_fact.csv for the long-table provenance.

Paradigms	multi-paradigm
First appeared	1996
Influenced by	PL/SQL Ada

Related languages

PS-algol (0.21)SQL (0.13)JPQL (0.12)SQL PL (0.12)Modula-2+ (0.12)

LLM-contributed programs

Loops/While

Origin · Download · manifest.json · Report

Provenance: commit f09a082d0a · authored 2026-02-24T21:48:31+01:00 · agent claude-code · model claude-sonnet-4-6 · WebSearch enabled

code.sql · license: Public Domain · added: 2026-02-24T20:47:44Z

CREATE PROCEDURE LOOPSWHILE()
LANGUAGE SQL
BEGIN
  DECLARE i INT DEFAULT 1024;
  WHILE i > 0 DO
    SELECT i;
    SET i = i / 2;
  END WHILE;
END

Real programs from Software Heritage

No SWH evidence indexed yet for this language. (Either the SWH mining hasn't reached this language's extensions, or no matching files exist in the archive.)

Contribute — propose a file extension

Tell us where to find evidence about SQL/PSM (mapped to pl/sql-psm-2). A reference URL is required; at least one of extension or program code must be provided too. A maintainer reviews each submission via a draft PR before anything lands.

File extension (optional) — e.g. .oak. Some PLs (e.g. esolangs) have no convention; leave empty if so. Friendly name (optional)

Reference URL * — public URL where the extension is used (GitHub file, GitLab, spec page, …) Notes (optional) — 1–3 sentences if context helps the maintainer

Optional: attach a program from that URL

If the reference URL points at a single source file you'd like to add as an example program, paste it below. The workflow will write it under languages/SQL_PSM/programs/<sha>/. Keep under ~200 lines.

Title (optional) — e.g. "Factorial", "Quicksort" License guess (optional) — MIT, GPL-2.0, …

Code (optional) — paste verbatim bytes from the reference URL

(or open the pre-filled issue directly)