Important definitions and terminologies used in SQL Language
A
- ACID in SQL Language
- ADF in SQL Language
- ADR in SQL Language
- Aggregate functions in SQL Language
- Aggregate query in SQL Language
- Aggregation in SQL Language
- Alias in SQL Language
- Aliasing tables in SQL Language
- ALL Operator in SQL Language
- Ambiguous in SQL Language
- Analytic functions in SQL Language
- Anonymous Block in SQL Language
- ANSI in SQL Language
- ANY Keyword in SQL Language
- ASCII in SQL Language
- ASH in SQL Language
- ASM in SQL Language
- Audit in SQL Language
- Autonomous transaction in SQL Language
B
- B-Tree (or B-Tree Index) in SQL Language
- Backup and recovery in SQL Language
- Backup and restore in SQL Language
- BFILE in SQL Language
- BI in SQL Language
- Binary data in SQL Language
- Binary Integer in SQL Language
- Bind Variable in SQL Language
- Bitmap Index in SQL Language
- BLOB in SQL Language
- Block in SQL Language
- Boolean in SQL Language
- Bounce in SQL Language
C
- Candidate Key in SQL Language
- Cardinality in SQL Language
- Cartesian Join in SQL Language
- Cascade Constraints in SQL Language
- Cascade delete in SQL Language
- CASE in SQL Language
- CBO in SQL Language
- CHAR in SQL Language
- CHECK constraint in SQL Language
- Clause in SQL Language
- CLI in SQL Language
- CLOB in SQL Language
- Cluster in SQL Language
- Clustered index in SQL Language
- COALESCE in SQL Language
- Collation in SQL Language
- Column Alias in SQL Language
- Column in SQL Language
- Column-Level Constraint in SQL Language
- COMMIT in SQL Language
- Common Table Expression (CTE) in SQL Language
- Complex View in SQL Language
- Composite key in SQL Language
- CONCAT in SQL Language
- Concurrency in SQL Language
- Connection String in SQL Language
- Constant in SQL Language
- CONSTRAINT in SQL Language
- Conversion in SQL Language
- CREATE in SQL Language
- Cross Join in SQL Language
- CRUD in SQL Language
- CTAS in SQL Language
- CTE in SQL Language
- CURRVAL in SQL Language
- Cursor in SQL Language
- Cursor variable in SQL Language
D
- Data definition language (DDL) in SQL Language
- Data Dictionary in SQL Language
- Data integrity in SQL Language
- Data manipulation language (DML) in SQL Language
- Data mart in SQL Language
- Data model in SQL Language
- Data type in SQL Language
- Data warehouse in SQL Language
- Database in SQL Language
- Database link in SQL Language
- Database management system (DBMS) in SQL Language
- Database schema in SQL Language
- DBA in SQL Language
- DBMS in SQL Language
- DCL in SQL Language
- DDL in SQL Language
- Deadlock in SQL Language
- DELETE in SQL Language
- DELETE statement in SQL Language
- Deletion anomaly in SQL Language
- Denormalization in SQL Language
- Denormalize in SQL Language
- Dimension Table in SQL Language
- Directory in SQL Language
- Dirty read in SQL Language
- DISTINCT in SQL Language
- DML in SQL Language
- DROP in SQL Language
- Dual in SQL Language
- Dynamic SQL in SQL Language
E
- EBS in SQL Language
- Embedded SQL in SQL Language
- Entity-relationship (ER) diagram in SQL Language
- Equi-join in SQL Language
- ERD in SQL Language
- Escape in SQL Language
- ETL in SQL Language
- EXCEPT in SQL Language
- Exception in SQL Language
- EXISTS in SQL Language
- Explain Plan in SQL Language
- Expression in SQL Language
- Extent in SQL Language
- External Table in SQL Language
F
- Fact Table in SQL Language
- Fetch in SQL Language
- Field in SQL Language
- First Normal Form (1NF) in SQL Language
- Flashback in SQL Language
- Flat file in SQL Language
- FOREIGN KEY in SQL Language
- Fourth Normal Form (4NF) in SQL Language
- FROM Clause in SQL Language
- Full outer join in SQL Language
- Full-text search in SQL Language
- Function in SQL Language
- Functional dependency in SQL Language
G
- GRANT in SQL Language
- GROUP BY clause in SQL Language
- GROUP BY in SQL Language
H
- Hash join in SQL Language
- HAVING Clause in SQL Language
- HAVING in SQL Language
- Heap-organized table in SQL Language
- Hint in SQL Language
- Histogram in SQL Language
I
- IDE in SQL Language
- Identity column in SQL Language
- IF THEN ELSE in SQL Language
- Index in SQL Language
- Index-organized table in SQL Language
- Indexing in SQL Language
- Inheritance in SQL Language
- Inline view in SQL Language
- INNER JOIN in SQL Language
- INSERT in SQL Language
- INSERT statement in SQL Language
- Integrity constraints in SQL Language
- Integrity in SQL Language
- Intersect in SQL Language
- Interval in SQL Language
- IS NULL in SQL Language
- Isolation level in SQL Language
J
- JDBC in SQL Language
- JDK in SQL Language
- JOIN in SQL Language
- Joins in SQL Language
K
- Key in SQL Language
- Keyword in SQL Language
L
- LIKE in SQL Language
- LIKE operator in SQL Language
- Listener in SQL Language
- Literal in SQL Language
- LOB in SQL Language
- Lock escalation in SQL Language
- Lock in SQL Language
- Locking in SQL Language
- Logical operator in SQL Language
M
- Many to Many Relationship in SQL Language
- Materialized View in SQL Language
- MERGE in SQL Language
- Metadata in SQL Language
- MINUS in SQL Language
- Multi-row subquery in SQL Language
- Multi-version concurrency control (MVCC) in SQL Language
- Multivalued attribute in SQL Language
- Mutating Table in SQL Language
N
- Natural Join in SQL Language
- Natural key in SQL Language
- NCHAR in SQL Language
- Nested query in SQL Language
- Nested Table in SQL Language
- NEXTVAL in SQL Language
- NLS in SQL Language
- Non-equi-join in SQL Language
- Normal form in SQL Language
- Normalization in SQL Language
- NOT NULL in SQL Language
- Nullability in SQL Language
- NULLIF in SQL Language
- Number in SQL Language
- NVARCHAR2 in SQL Language
O
- OBIEE in SQL Language
- OCA in SQL Language
- OCM in SQL Language
- OCP in SQL Language
- ODI in SQL Language
- OLAP in SQL Language
- OLTP in SQL Language
- On Delete Cascade in SQL Language
- ON DELETE in SQL Language
- On Delete Set Null in SQL Language
- ON UPDATE in SQL Language
- One to Many Relationship in SQL Language
- One to One Relationship in SQL Language
- Operator in SQL Language
- Oracle Fusion in SQL Language
- ORACLE_HOME in SQL Language
- ORDER BY in SQL Language
- OTN in SQL Language
- OUTER JOIN in SQL Language
- Outer query in SQL Language
- Overlapping ranges in SQL Language
P
- Package in SQL Language
- Partial index in SQL Language
- PGA in SQL Language
- Pivot in SQL Language
- PLS_INTEGER in SQL Language
- Pragma in SQL Language
- Predicate in SQL Language
- Primary key in SQL Language
- Privilege in SQL Language
- Procedure in SQL Language
- Pseudocolumn in SQL Language
Q
- Query in SQL Language
R
- RAC in SQL Language
- RANK in SQL Language
- RAW in SQL Language
- RBO in SQL Language
- RDBMS in SQL Language
- Recursive CTE in SQL Language
- REF CURSOR in SQL Language
- Relation in SQL Language
- Relationship in SQL Language
- Replication in SQL Language
- REVOKE in SQL Language
- RMAN in SQL Language
- Role in SQL Language
- Rollback in SQL Language
- Rollback segment in SQL Language
- Rollup in SQL Language
- ROWID in SQL Language
- ROWNUM in SQL Language
S
- Savepoint in SQL Language
- Scalar function in SQL Language
- Schema in SQL Language
- SCN in SQL Language
- Second Normal Form (2NF) in SQL Language
- Secondary index in SQL Language
- Segment in SQL Language
- SELECT in SQL Language
- Self Join in SQL Language
- Self-join in SQL Language
- Sequence in SQL Language
- Serialization in SQL Language
- Session in SQL Language
- SET statement in SQL Language
- SGA in SQL Language
- SID in SQL Language
- Single-row subquery in SQL Language
- Snapshot isolation in SQL Language
- SQL in SQL Language
- SQLCODE in SQL Language
- Star schema in SQL Language
- Stored procedure in SQL Language
- Subquery in SQL Language
- Substr in SQL Language
- Surrogate key in SQL Language
- Synonym in SQL Language
- SYS in SQL Language
T
- Table in SQL Language
- Table variable in SQL Language
- Table-level constraint in SQL Language
- Tablespace in SQL Language
- Temporal table in SQL Language
- Temporary table in SQL Language
- Third normal form (3NF) in SQL Language
- TIMESTAMP in SQL Language
- TIMESTAMP WITH TIME ZONE in SQL Language
- TKProf in SQL Language
- TNS in SQL Language
- TNSNAMES.ora in SQL Language
- Toad in SQL Language
- TOP in SQL Language
- Transaction in SQL Language
- Transitive closure in SQL Language
- Transitive dependency in SQL Language
- Trigger in SQL Language
- TRUNCATE in SQL Language
- Tuple in SQL Language
U
- UDT in SQL Language
- UID in SQL Language
- UML in SQL Language
- UNION ALL in SQL Language
- UNION in SQL Language
- Unique constraint in SQL Language
- Unique key/Unique constraint in SQL Language
- UPDATE in SQL Language
- User in SQL Language
- User-defined function in SQL Language
- User-defined type in SQL Language
V
- Vacuum in SQL Language
- Values clause in SQL Language
- VARCHAR in SQL Language
- VARCHAR2 in SQL Language
- VARRAY in SQL Language
- View in SQL Language
W
- Wildcard in SQL Language