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

Category Archives: Uncategorized

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 = […]

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

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 […]

Leave a comment

Source code for Oracle SYS Views

Oracle System Views Source code for Oracle SYS Views

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…

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.

Leave a comment

Oracle System Views

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

Comments Off

Oracle Installation Links

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

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.

1 Comment