4:["$","div",null,{"className":"min-h-screen bg-white flex flex-col","children":[["$","div",null,{"className":"px-6 pt-6 pb-4 border-b border-gray-100","children":[["$","div",null,{"className":"flex items-center gap-1.5 text-xs text-gray-400 mb-4","children":[["$","a",null,{"href":"/","className":"hover:text-[#26a69a] transition-colors","children":"Market"}],["$","span",null,{"children":"›"}],["$","span",null,{"className":"text-gray-600","children":"SQL/JRT"}]]}],["$","div",null,{"className":"text-[10px] text-gray-400 uppercase tracking-widest mb-1","children":"Company Profile"}],["$","h1",null,{"className":"text-2xl font-bold text-gray-900","children":"SQL/JRT"}],null]}],["$","div",null,{"className":"flex-1 px-6 py-6","children":[["$","p",null,{"className":"text-sm text-gray-600 leading-relaxed mb-8","children":"SQL/JRT, or SQL Routines and Types for the Java Programming Language, is an extension to the SQL standard first published as ISO/IEC 9075-13:2002. SQL/JRT specifies the ability to invoke static Java methods as routines from within SQL applications, commonly referred to as \"Java stored procedures\". SQL/JRT also calls for the ability to use Java classes as SQL structured user-defined types. The two parts of the extension originate from the earlier ANSI SQLJ part 1 and 2 standards."}],["$","div",null,{"className":"columns-1 md:columns-2 gap-10","children":[["$","div","0",{"className":"mb-8 break-inside-avoid","children":[["$","div",null,{"className":"text-xs font-semibold text-gray-400 uppercase tracking-wide mb-3 border-b border-gray-100 pb-1","children":"Example"}],["$","div",null,{"className":"text-sm text-gray-600 leading-relaxed wiki-content","dangerouslySetInnerHTML":{"__html":"SQL/JRT allows a Java function to be called from SQL code like this: CREATE FUNCTION sinh(v DOUBLE) RETURNS DOUBLE LANGUAGE JAVA DETERMINISTIC NO SQL EXTERNAL NAME 'CLASSPATH:java.lang.Math.sinh' SELECT sinh(doublecolumn) FROM mytable SQL/JRT also allows Java code to dynamically generate tables using a java.sql.ResultSet object. The result sets returned are converted to SQL tables and can be used anywhere a table or view can be used. == Implementations =="}}]]}],["$","div","1",{"className":"mb-8 break-inside-avoid","children":[["$","div",null,{"className":"text-xs font-semibold text-gray-400 uppercase tracking-wide mb-3 border-b border-gray-100 pb-1","children":"Implementations"}],["$","div",null,{"className":"text-sm text-gray-600 leading-relaxed wiki-content","dangerouslySetInnerHTML":{"__html":"SQL/JRT stored procedures are implemented in HSQLDB. Java stored procedures have also been implemented in Oracle's JServer (or Aurora JVM), which was introduced in the Oracle Database version 8i in 1999; it is now called Oracle JVM. IBM DB2 also supported Java stored procedures since about 1998, although using an external JVM (at that time). ==See also=="}}]]}]]}],["$","div",null,{"className":"mt-8 pt-4 border-t border-gray-100","children":["$","a",null,{"href":"https://en.wikipedia.org/wiki/SQL%2FJRT","target":"_blank","rel":"noopener noreferrer","className":"text-xs text-gray-400 hover:text-gray-600 transition-colors","children":"Source: Wikipedia ↗"}]}]]}],["$","div",null,{"className":"px-6 py-4 border-t border-gray-100 flex justify-between items-center","children":[["$","a",null,{"href":"/","className":"text-xs text-gray-300 italic hover:text-gray-500 transition-colors","children":"tickerdossier.com"}],["$","a",null,{"href":"https://tickerdossier.substack.com","target":"_blank","rel":"noopener noreferrer","className":"text-xs text-gray-400 hover:text-gray-600 transition-colors","children":"tickerdossier.substack.com"}]]}]]}]