Home Code Snippets Oracle Reference Oracle Functions Oracle Error Codes Forum Oracle Jobs Oracle Blogs

Author Archives: admin

Writing SQL queries

Writing SQL queries Also see How to debug PL/SQL code Transform a subquery involving the IN clause to a Join? Original Statement: SELECT e.empno, e.ename FROM emp e WHERE e.deptno IN ( SELECT d.deptno FROM dept d WHERE d.loc = ‘CHICAGO’ ); New Statement: SELECT e.empno, e.ename FROM emp e, dept d WHERE d.loc = […]

Posted in Uncategorized | 1 Comment

How to handle data in BULK

How to handle data in BULK using BULK collection and BULK DML, using global temporary tables and PL/SQL indexed tables etc

Posted in Uncategorized | 1 Comment

Dealing with Constraints

Dealing with Constraints Introduction Three type of constraints are discussed here. ie Primary key, Unique and Referential A Foreign key constraint has to refer to a Primary key constraint of another table The constraint_type in user_constraints table has value P for Primary key, U for Unique and R for Referential The following code works for […]

Posted in Uncategorized | Leave a comment

Source code for Oracle SYS Views

Oracle System Views Source code for Oracle SYS Views

Posted in Uncategorized | Leave a comment

Hierarchial Queries

Hierarchial Queries The queries shown below demonstrates how to query an hierarchial database. The queries works on employees tables. The script for creating the table and inserting data is available here…

Posted in Uncategorized | Leave a comment

More about Oracle Indexes

Choosing indexes, how to select indexing columns, whether to compress index or not, rebuilding indexes etc is discussed.

Posted in Uncategorized | Leave a comment

Oracle System Views

Oracle System Views Also see How to debug PL/SQL code

Posted in Uncategorized | Comments Off

Oracle Installation Links

Oracle Installation Links for Windows, Unix, Linux and Solaris platforms

Posted in Uncategorized | Leave a comment

Designing Indexes – Concepts

About the pros and cons of indexes and explains about how indexing strategies for tables huge amount of data.

Posted in Uncategorized | 1 Comment