Results for “stored-function”

11 skills

mariadb-corporation

mariadb-create-function

Explains MariaDB's three CREATE FUNCTION forms — stored functions, stored aggregate functions, and loadable UDFs — covering syntax, privileges, and behavior differences for writing or reviewing MariaDB SQL.

More results

claude-dev-suite

Oracle PL/SQL procedural language. Covers stored procedures, functions, packages, triggers, cursors, collections, and exception handling. Use for Oracle database server-side programming. USE WHEN: user mentions "plsql", "Oracle procedures", "Oracle packages", "Oracle triggers", "BULK COLLECT", "FORALL", "DBMS_OUTPUT", "Oracle functions" DO NOT USE FOR: basic Oracle SQL - use `oracle` instead, PostgreSQL - use `plpgsql` instead, T-SQL - use `tsql` instead

209-sql-23f1987a

Provides SQL window function examples for ranking, aggregation, lag/lead, value extraction, frame specifications, and advanced analytics.

Execute Stored Procedures on a Fabric Warehouse

162-use-e70e84f3

Provides guidance on using Apache Spark RDDs, including creation, transformations, actions, and performance considerations.

mariadb-corporation

mariadb-vector-functions

Reference for MariaDB's vector functions and VECTOR data type, covering VEC_Distance, VEC_Distance_Euclidean, VEC_Distance_Cosine, VEC_FromText, VEC_ToText, and MHNSW vector index usage for SQL queries over embeddings.

migrating-oracle-to-postgres-stored-procedures

Translates Oracle PL/SQL stored procedures to PostgreSQL PL/pgSQL, preserving method signatures and type-anchored parameters while applying Oracle-compatible sorting and leveraging orafce.

performing-second-order-sql-injection

Detect and exploit second-order SQL injection vulnerabilities where malicious input is stored in a database and later executed in an unsafe SQL query during a different application operation.

24.6k · bundle

Provides persistent, self-hosted semantic memory for AI agents via MCP, storing worklogs, decisions, and notes in PostgreSQL with pgvector for meaning-based retrieval across sessions.

claude-dev-suite

Microsoft SQL Server T-SQL procedural language. Covers stored procedures, functions, triggers, error handling, and SQL Server-specific features. Use for SQL Server database server-side programming. USE WHEN: user mentions "tsql", "T-SQL", "SQL Server procedures", "SQL Server functions", "TRY...CATCH", "THROW", "sp_executesql", "SSMS" DO NOT USE FOR: basic SQL Server SQL - use `sqlserver` instead, PostgreSQL - use `plpgsql` instead, Oracle - use `plsql` instead

mariadb-corporation

mariadb-encryption-functions

Reference for MariaDB's built-in encryption, hashing, and compression functions, covering AES_ENCRYPT/DECRYPT, SHA2, KDF, COMPRESS, and related functions, with guidance on correct usage and common pitfalls.