Oracle PL/SQL: How Pipelined Table Functions Outperform Regular Ones

·8 views

Oracle PL/SQL offers two types of table functions — regular and pipelined — both capable of returning collections queryable directly in SQL FROM clauses. Regular table functions load the entire result set into PGA memory before returning data, leading to higher memory usage and slower time-to-first-row, making them suitable mainly for small datasets. Pipelined functions, by contrast, stream rows incrementally to the caller using the PIPE ROW construct, significantly reducing memory overhead and improving responsiveness for large ETL or real-time data operations. A key syntax rule requires that the RETURN statement in a pipelined function remain empty — passing a variable causes a PLS-00633 compilation error. Additionally, the TABLE() wrapper mandatory in Oracle 11g and earlier became optional from Oracle Database 12c Release 2 onward.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

KiwiEngine: One Developer's Bet That Shared Foundations Save Creative Time

Developer and creator behind KiwiEngine argues that the true value of a framework lies not just in speeding up current work, but in preventing developers from repeatedly solving the same foundational problems across projects. The author observes that while applications differ in domain and users, the underlying mechanisms — routing, HTTP, configuration, deployment — are often remarkably similar. KiwiEngine is being built around the idea of shared, reusable libraries that improve across multiple projects simultaneously, creating compounding leverage over time. The developer acknowledges a key risk: an overly ambitious framework can become a maintenance burden in itself, which is why KiwiEngine is designed with deliberate boundaries so each component solves only its specific problem. The broader motivation is personal — with limited hours and wide-ranging interests spanning music, teaching, and hardware, the author needs a technical foundation that makes starting new experiments cheap rather than costly.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Developer Guide Warns AI Agent Evals Are Flawed Without Real Latency Testing

A technical post on DEV Community argues that many AI agent evaluations are misleading because they are run locally, where network latency, timeouts, and transport failures never occur. The author contends that localhost testing cannot reproduce critical failure modes such as retry storms, partial response bodies, or deadline misses that appear in real deployments. To address this, the post recommends capturing detailed per-call telemetry including attempt numbers, monotonic timestamps, timeout budgets, abort flags, and HTTP errors on every tool invocation. A sample Python harness called latency_harness.py is provided to illustrate how implausibly fast round trips can be flagged as suspect during evaluation. The author concludes that a green result from a local eval should be treated only as a rehearsal until the agent is tested against an actual remote environment.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Developer Returns After Three-Month Break, Credits Rest for Renewed Creativity

A developer on DEV Community went completely inactive from March 12th after experiencing burnout caused by juggling university studies with personal coding projects and keeping up with new technologies. Feeling overwhelmed, they chose to step away entirely, first redirecting full attention to their academic responsibilities. They then took a holiday, deliberately leaving their laptop behind and disconnecting from tech news and coding altogether. After a few days of rest, travel, and social interaction, their creative motivation returned naturally. Back online, they are encouraging others facing burnout to take guilt-free breaks, arguing that mental downtime is essential for long-term productivity.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Developer releases mini-waf, a lightweight npm package to filter Node.js API requests

A developer has published mini-waf, an open-source npm package that adds web application firewall (WAF) capabilities to Node.js APIs in minutes. The package evaluates each incoming request against configurable rule presets — including protections against SQL injection, XSS, and path traversal — and can block, allow, or log requests accordingly. It supports popular frameworks including Express, Fastify, NestJS, and Koa through dedicated adapters or a core API. Users can select protection levels ranging from low to paranoid, with higher levels enabling more rules at the cost of potential false positives. The developer created the package after finding no suitable lightweight WAF solution tailored to the Node.js ecosystem.

0 comments Read more at DEV Community