SQL Definitions

  • A

    autonomous transaction

    In Oracle's database products, an autonomous transaction is an independent transaction that is initiated by another transaction.

  • C

    CFML (ColdFusion Markup Language)

    CFML (ColdFusion Markup Language) is a Web page markup language that allows a Web site developer to create pages with variable information (text or graphics) that is filled in dynamically (on the fly) in response to variables such as user input.

  • correlated subquery

    A correlated subquery is a SQL query that depends on values executed by the outer query in order to complete.

  • D

    dynamic SQL (Dynamic Structured Query Language)

    Dynamic SQL is an enhanced form of Structured Query Language (SQL) that, unlike standard (or static) SQL, facilitates the automatic generation and execution of program statements.

  • F

    foreign key

    A foreign key is a column or columns of data in one table that connects to the primary key data in the original table.

  • O

    Open Database Connectivity (ODBC)

    Open Database Connectivity (ODBC) is an open standard application programming interface (API) for accessing a database.

  • Q

    Query by Example (QBE)

    Query by Example (QBE) is a method of query creation that allows the user to search for documents based on an example in the form of a selected text string or in the form of a document name or a list of documents.

  • S

    stored procedure

    A stored procedure is a group of statements with a specific name, which are stored inside a database, such as MySQL or Oracle.

  • T

    The Open Group

    The Open Group is a software standards organization that is sponsored by a number of major software vendors.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close