Oracle Master Glossary Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Contents for this book
Contents



Go to previous file in sequence Go to next file in sequence

J


join A query that retrieves data from multiple database tables, specifying how rows are to be related using a join condition. Occasionally one table is joined to itself. See also self-join.

join column A column used to join one table to another in a join query. One or more join conditions are used in a WHERE clause to specify the relationship(s) between the join columns in the two tables.

join condition One or more conditions specified in the SQL query to determine which rows in the tables will be retrieved. The most common join condition is equality (called an equi-join), as in WHERE EMP.EMPNO = PROJ.EMPNO, but other conditions are valid. See also non-equi-join, and self-join.

Julian date An algorithm for expressing a date in integer form, using the SQL function JDATE. Julian dates allow additional arithmetic functions to be performed on dates.

justification See alignment.




Go to previous file in sequence Go to next file in sequence
Prev Next
Oracle
Copyright © 1996 Oracle Corporation.
All Rights Reserved.
Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Contents for this book
Contents