Tag Archives: oracle

Oracle Joins Tutorial

A nice tutorial that explains how to use joins in Oracle with both new and old syntax, visual illustrations, and examples. http://www.techonthenet.com/oracle/joins.php There are 4 different types of Oracle joins: Oracle INNER JOIN (or sometimes called simple join) Oracle LEFT OUTER JOIN … Continue reading

Posted in Uncategorized | Tagged , , , , , , , | Leave a comment

How to limit the number of rows with both lower and upper bounds returned by an Oracle query after ordering?

    How to retrieve only the Nth row from a table?     Starting with Oracle 12c there is a syntax available to limit rows or start at offsets. Resource: http://stackoverflow.com/questions/470542/how-do-i-limit-the-number-of-rows-returned-by-an-oracle-query-after-ordering

Posted in Uncategorized | Tagged , , , , , , , | Leave a comment

Referential and Self-Referential Integrity Constraints

Referential Integrity Constraints Different tables in a relational database can be related by common columns, and the rules that govern the relationship of the columns must be maintained. Referential integrity rules guarantee that these relationships are preserved. Table lists terms … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

Data Integrity Rules

Data Integrity Rules: The rules that can be applied to table columns to enforce different types of data integrity. Null rule: A null rule is a rule defined on a single column that allows or disallows inserts or updates of … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

Finding a constraint in Oracle

…where “X” is the constraint name I’m looking for For more detailed explanations http://www.databasejournal.com/features/oracle/article.php/3665591/Finding-Foreign-Key-Constraints-in-Oracle.htm

Posted in Uncategorized | Tagged , , | Leave a comment

Search for column names in an Oracle DB

…where “X” is the column name I’m looking for Source: DZone Snippets http://snippets.dzone.com/posts/show/539#related

Posted in Uncategorized | Tagged , , | Leave a comment