Unit 12.1. What PL/SQL Server Pages Are

What PSPs Are

PL/SQL Server Pages (PSPs) are Oracle’s PL/SQL scripting (programming/developing) solution for server-side Web application development. They enable PL/SQL programmers to develop Web pages with dynamic content by embedding PL/SQL scripts in HTML pages. After these scripts are loaded into the database, they can then be executed when Web clients request the pages these scripts paint.

PSP pages are HTML pages with embedded PL/SQL scripts that are distinguished from the HTML content. This appearance of separation of application logic (embedded PL/SQL scripts) from the presentation logic (HTML) makes the development and maintenance of PSP pages easy. PSPs can be thought of as the reverse of PL/SQL ...

Get Oracle® Web Application Programming for PL/SQL® Developers now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.