Oracle SQL Environment Commands Every Developer Should Know for Interviews

·59 views

Oracle SQL*Plus and SQL Developer offer several environment control commands that shape how scripts execute and how output is displayed. Commands like SET DEFINE OFF prevent the ampersand character from being misread as a substitution variable prefix, which is critical in automated deployment pipelines handling URLs or company names such as AT&T. Performance-related commands such as SET TIMING ON and SET FEEDBACK help developers benchmark queries and monitor result counts directly from the command line. Display commands including SET LINESIZE, SET PAGESIZE, and SET LONG control output formatting and the handling of large data types like CLOBs and XMLType. A key distinction for interviews is that these SET commands are client-side parameters and do not influence server-side execution plans, unlike bind variables which promote plan reuse in the database's Shared Pool.

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)

OpenAI's AI pipeline reports 948 distinct Linux kernel root vulnerabilities for $1.2M

In a mid-October run, an unreleased OpenAI cyber model generated 948 distinct local privilege escalation flaws in the Linux kernel, each with a path to root access. The total API cost was about $1.21 million, roughly $1,280 per vulnerability. The pipeline narrowed the kernel to code reachable by unprivileged users, then had agents validate flaws in virtual machines and attempt root exploits, with common protections like KASLR, SMEP, and SMAP enabled. The bugs are local rather than remote, so an attacker would still need an initial foothold, and the findings are counted as vulnerabilities rather than merged fixes. OpenAI says human engineers review exploits and patches before disclosure, starting with the most severe cases and sending reports to kernel maintainers gradually.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Detecting silent failures in AI agents with traces and evaluation events

AI agents can return a successful HTTP 200 with no exception and no error span, yet still give a wrong or incomplete answer, which keeps monitoring dashboards green. The article proposes tracing every agent step, separating technical errors from content errors, and attaching an evaluation result to each trace. It relies on OpenTelemetry GenAI conventions, including agent and tool-call spans and a gen_ai.evaluation.result event that records quality scores. Capturing tool arguments and results is opt-in because it may expose sensitive data, so it is recommended only on a masked sample. A broken evaluator is recorded as an error rather than treated as a correct answer.

0 comments Read more at DEV Community

ProgrammingHacker News ·

Merz Says Google Cloud Meets Sovereignty Standards for Intelligence Agencies

German Chancellor Friedrich Merz has stated that Google Cloud is sovereign enough to be used by intelligence agencies. The remark addresses the ongoing debate in Germany over how much control government bodies must retain over their digital infrastructure. It reflects a stance that a US-based cloud provider can meet the country's sovereignty requirements for sensitive security work. The source article, published by heise, provides further details on the context of the statement.

0 comments Read more at Hacker News

ProgrammingDEV Community ·

Freezing design tokens so AI agents can't edit shared styling scales

An agent asked to adjust spacing in a checkout header also changed a shared spacing token, which unintentionally affected other pages like settings. The author now freezes token and theme files by default for agent-driven UI work, allowing edits only to named component paths. Token changes require an explicit unlock, such as a human prompt or a separate pull request. When a design needs a new token, the agent is instructed to stop and propose the change in writing rather than editing the shared scale. The approach is paired with PR template checks, CI warnings, and review guidelines to keep token changes separate from feature work.

0 comments Read more at DEV Community