SQL and database development in general contain many terms and acronyms. It can be difficult to understand different articles, books, and even concepts that are explained to you if you are not sure what these terms and acronyms mean. Check out this SQL glossary to understand them. This SQL glossary contains a comprehensive list of terms, acronyms, and words specific to SQL, relational databases, and data warehouses. You should be able to use this page as a reference for all terms and acronyms related to SQL and database development in general. These terms are relevant and useful for all types of database developers. If you like it or find it useful, share it with your colleagues and people you know! Thank you! CLOB stands for Character Large Object and is a data type in SQL databases. A unique key or constraint is a constraint that ensures that only unique values are entered in the specified column. A Cartesian join or Cartesian product is the result of data from two tables that have not been joined. A pseudo-column that displays the position of the row in a result set.
A database object attached to a table that is called when a row is inserted, updated, or deleted. Triggers contain procedural code and allow you to verify that the changes are correct or to add data that must exist but is not specified by the SQL statement. In most cases, the third normal form is acceptable for transactional databases. Depending on your needs, it may happen to switch to the fourth normal form. EBS stands for Oracle E-Business Suite and is a suite of applications with different modules, such as: This query displays the department_id and number of employees with each value department_id. These data have been aggregated. The SELECT statement in the FROM clause of another SELECT statement. It is treated as a view, but is not stored as a database object. Other clauses may contain GROUP BY, WHERE, HAVING, INSERT, UPDATE, or DELETE. It can store values between -2^31 and 2^31, which is equivalent to values between -2,147,483,648 and 2,147,483,647 (about 2 billion). With a table alias, you give a table in your query a temporary (and often shorter) name. This is often used to speed up the writing of queries, help with autocomplete in IDEs, and is often required in some cases (e.g., Auto-link) Different name for a column in a database.
It stores a specific data item for a record or row in a table. A full list of SQLCODE values is available here. This logic is implemented in several ways in Oracle SQL in various functions, but if you are designing your own conditional logic in SQL, use the CASE statement, a PL/SQL statement used to load data from a cursor. There are many programs you can use to create ERDs, and I`ve listed them here (along with pricing and reviews). A command that rolls back all changes made to table data during the current transaction. The opposite of the COMMIT keyword. UML stands for Unified Modeling Language and is a universal modeling language for visualizing the design of a system. An older Oracle data type used to store binary data such as images or audio. It has been replaced by the BLOB data type. A cursor is a pointer to a result set in procedural languages such as PL/SQL. The keyword is used to make it clear to other developers or readers that you wanted it to be a cross join, rather than omitting it and letting people assume that you made a mistake by not specifying a join type.
A natural key is a primary key that consists of columns that already exist in the table. ADF or Oracle ADF stands for Application Development Framework. It is a web development framework based on JSF (Java Server Faces). The best way to represent it in a database is to create a join or junction table that captures the different combinations of each of these tables. A schema is the set of objects (tables, views, sequences) that belong to a user account. For example, a country can have only one capital, and a capital belongs to only one country. A constraint is a constraint or rule defined on a table or column within a table. DCL stands for Data Control Language and is the category of SQL statements that control access to the database and its data. A set of permissions that can be granted or revoked to users. It contains the protocol, host, port, SID, service name, and database connection type. OBIEE stands for Oracle Business Intelligence Enterprise Edition.
It is a set of business intelligence and analytics platforms that perform business intelligence functions in a data warehouse. It improves security (users don`t know what the underlying logic is), an abstraction layer (modifying tables without impacting end users), and several other benefits. Learn more about synonyms here. For more information about the Boolean value, see the article on the SQL Boolean data type here. It differs from VARCHAR and VARCHAR2 in several ways, as described in this article. The IF part verifies a condition, THEN an operation is performed if the condition is true, and OTHERWISE something else is done if the condition is false. CLI stands for Command Line Interface.