Oracle
Oracle is an American multinational technology company engaged in the development and sale of enterprise software, database management systems, and cloud computing services. Its flagship product, Oracle Database, is a widely used relational database system. The company also provides enterprise application software suites such as ERP and CRM, as well as cloud infrastructure services. Oracle holds stewardship over the Java programming language and the MySQL database, and serves large enterprises and government organizations worldwide.
Core Facts
Tech giants controlling AI infrastructure include Microsoft, Google, Meta, and NVIDIA.
In 2021, the U.S. Supreme Court ruled 6-2 that Google's use of the Java API constituted fair use.
In the Agent context, an oracle refers to the authoritative adjudicator used by the system to determine whether a task is complete, whose key properties include determinism (the same input necessarily yields the same conclusion) and being unmanipulable by the Agent (the judgment does not go through natural language and does not depend on another model's understanding).
Timeline (last 90 days)
Java Champion is a community honorary title sponsored by Oracle, awarded to developers with notable contributions and influence in the Java community.
This test targeted only the Oracle dialect, and the two rules were distilled from manual analysis of failure cases; for other dialects such as MySQL and PostgreSQL, whether similar high-frequency error patterns exist requires separate attribution analysis.
Oracle prohibits the AS keyword before table aliases and has strict restrictions on using words such as DATE and NUMBER as column names (double quotes required).
schemagate's solution is: when the target database is Oracle, explicitly tell the model two rules in the prompt (no AS before table aliases, quote reserved words such as DATE/NUMBER when used as column names), while leaving prompts for other databases unchanged.
After injecting two Oracle-specific rules into the prompt, first-attempt failed queries dropped from 694 to 85.
Of the 694 queries that failed on the first attempt, 100 errors were because the model used columns named DATE or NUMBER without quotes, while these two words are reserved words in Oracle.
Of the 694 queries that failed on the first attempt, 551 errors were because the model wrote FROM account AS a, while Oracle does not allow the AS keyword before a table alias.
On UniQL's Oracle dialect task, the best published result (single-attempt accuracy) is 49.61%, achieved by Claude Sonnet 4.5; Gemini 2.5 Pro's accuracy is 26.14%.
A developer using the lightweight model Gemini 2.5 Flash together with the schemagate tool raised first-attempt accuracy on the UniQL Oracle benchmark from 35.0% to 64.5%.
According to the original article's estimates, the hidden costs brought by non-SAP endpoints are roughly: about $47,000 per year in custom development for Oracle CDC, about $12,000 for Salesforce, and about $38,000 for Workday.
40 more timeline events
All Facts (20)
Tech giants controlling AI infrastructure include Microsoft, Google, Meta, and NVIDIA.
75%VerifiedIn 2021, the U.S. Supreme Court ruled 6-2 that Google's use of the Java API constituted fair use.
75%UnverifiedMySQL由瑞典公司MySQL AB开发，2008年被Sun收购，后随Sun并入Oracle旗下
95%Unverified2017年Java EE被Oracle移交给Eclipse基金会并更名为Jakarta EE
90%Unverified在SAP、Oracle等传统ERP系统中，采购订单、收货单和发票三者必须在数量和金额上保持一致才能触发付款流程，这被称为"三单匹配"
90%UnverifiedOpenAI在2024年以来开始寻求更大的商业独立性，包括从非营利架构向营利性公司转型、与Oracle等其他云厂商建立合作关系
85%UnverifiedOpenAI已于2024年与Oracle签署了大规模算力采购协议
85%Partially VerifiedIn the Agent context, an oracle refers to the authoritative adjudicator used by the system to determine whether a task is complete, whose key properties include determinism (the same input necessarily yields the same conclusion) and being unmanipulable by the Agent (the judgment does not go through natural language and does not depend on another model's understanding).
65%UnverifiedOracle是OpenAI等AI公司的重要云服务合作伙伴
65%UnverifiedOracle sued Google in 2010 for unauthorized use of 37 Java API packages in the Android operating system.
60%Unverified2009年Oracle以74亿美元收购了Sun Microsystems
60%UnverifiedJava Champion is a community honorary title sponsored by Oracle, awarded to developers with notable contributions and influence in the Java community.
50%UnverifiedOn UniQL's Oracle dialect task, the best published result (single-attempt accuracy) is 49.61%, achieved by Claude Sonnet 4.5; Gemini 2.5 Pro's accuracy is 26.14%.
50%UnverifiedOracle prohibits the AS keyword before table aliases and has strict restrictions on using words such as DATE and NUMBER as column names (double quotes required).
50%UnverifiedThis test targeted only the Oracle dialect, and the two rules were distilled from manual analysis of failure cases; for other dialects such as MySQL and PostgreSQL, whether similar high-frequency error patterns exist requires separate attribution analysis.
50%UnverifiedOf the 694 queries that failed on the first attempt, 551 errors were because the model wrote FROM account AS a, while Oracle does not allow the AS keyword before a table alias.
50%UnverifiedOf the 694 queries that failed on the first attempt, 100 errors were because the model used columns named DATE or NUMBER without quotes, while these two words are reserved words in Oracle.
50%UnverifiedA developer using the lightweight model Gemini 2.5 Flash together with the schemagate tool raised first-attempt accuracy on the UniQL Oracle benchmark from 35.0% to 64.5%.
50%UnverifiedAfter injecting two Oracle-specific rules into the prompt, first-attempt failed queries dropped from 694 to 85.
50%Unverifiedschemagate's solution is: when the target database is Oracle, explicitly tell the model two rules in the prompt (no AS before table aliases, quote reserved words such as DATE/NUMBER when used as column names), while leaving prompts for other databases unchanged.
50%