Main Index

§  Unable to sftp “OTN Developer Days” Box - Received...

§  Solution of "ORA-02303: cannot drop or replace a t...

§  Creating Rule Based Apps Easily with Oracle Rules ...

§  Solution of “ORA-38473: cannot drop a type used fo...

§  Developing PL/SQL based Software via Extended Pair...

§  Test Automation of PL/SQL Program Units on Scrum A...

§  Coincidental Cohesion in PL/SQL

§  Minimizing Costs by using Oracle Database Virtuali...

§  Passing Parameters to Scheduler Programs in Chains...

§  Automated Table Data Comparison via DBMS_COMPARISO...

§  PL/SQL API of Wrap Utility - DBMS_DDL package

§  Parallel Processing with Oracle Scheduler Chains

§  ORA-29540: class [class_name] does not exist

§  Accessing XML data from SQL

§  unx:Exception during creation of the process

§  Parallelization of Scheduler Jobs with Advanced Qu...

§  ORA-27300: OS system dependent operation:semget fa...

§  ORA-01078: failure in processing system parameters...

§  libclntsh.so.11.1: cannot restore segment prot aft...

§  " Mastering Oracle Scheduler " Review

§  Cache affect In oracle

§  Using Data Pump Export(expdp) Over Network

§  Workaround for ORA-39014, ORA-12801, ORA-29913

§  Solution of ORA-39002, ORA-39070, ORA-39087

§  An Interesting PL/SQL Bug about References

§  Solution for ORA-01092, ORA-00704, ORA-39700

§  Data Minig :: Classification and Clustering :: Nai...

§  How to change start number of an Oracle Sequence

§  What Is the Benefits of Data Compression In Datawa...

§  A simple demonstration about how to comparing 2 Or...

§  Solution of ORA-02070 "database .... does not supp...

§  Sequence In Oracle RAC System might not generate n...

§  Dictionary Compressing

§  On ORA-01503, ORA-01161, ORA-01565, ORA-27038 and ...

§  Convert UTC Time To Local Time In Oracle

§  Solution Of ORA-29531 : static Keyword Missing

§  How to Export Table Data to Flat File :: Oracle Un...

§  How to Find Java(JVM) Version of Oracle Programati...

§  Some Notes on ORA-04061, ORA-04065 and ORA-06508

§  Running Executables From PL/SQL with DBMS_SCHEDULE...

§  Running Oracle Jobs with DBMS_SCHEDULER

§  Being a Java Developer or Oracle Developer?

§  Where Is Default Values Of Procedure Arguments?

§  Solution of "ORA-00314: log of thread , expected s...

§  Workaround for "ORA-00600: internal error code, ar...

§  ORACLE_SID and TWO_TASK Environment Variables For ...

§  Character Encoding Problem While Executing Web Ser...

§  Shortest Path Algorithm In Oracle

§  Data Minig :: Generating Decision Trees On Oracle

§  Establishing Refential Integrity With Materialized...

§  Workaround for ORA-00283, ORA-01610, ORA-00279, OR...

§  Solution of ORA-06502

§  Transferring(Copy, Clone) Files(Binary, Text etc.)...

§  Oracle Directory Objects and Solution of ORA-29280...

§  Sequence Generator In Oracle Database Management S...

§  Establishing Source Code Security With WRAP In Ora...

§  Copy Table Data Across Databases/Schemas In Oracle...

§  Solution of "ORA-01552: cannot use system rollback...

§  Solution Of "ORA-25153: Temporary Tablespace is Em...

§  Solution Of "ORA-01658: unable to create INITIAL e...

§  Veri Madenciligi(Data Mining) Nedir ve Nerelerde K...

§  Parallel Processing In PL/SQL

§  Query to Get Last Version Of Table Data With Diffe...

§  Solution of ORA-01157 and ORA-01110

§  Business Intelligence With Oracle

§  On Delete, Truncate and High Water Mark In Oracle

§  Test-Driven Development With Oracle's PL/SQL

§  DROP DATABASE Command In Oracle

§  How To Remove an Oracle Database

§  ''IN' is not a valid integer value'" Bug In TOAD W...

§  Power Of Object Oriented Mechanism With Object Vie...

§  Solution Of "ORA-12910: cannot specify temporary t...

§  Solution Of "ORA-27140: attach to post/wait facili...

§  On Inserts(Insert All-First) In Oracle

§  External Table Example In Oracle

§  Some Useful Dictionary Views For Database Objects ...

§  On Function Based Indexes In Oracle

§  On Alter Table Statements(Add-Drop-Modify Columns,...

§  On Constraints In Oracle : deferrable Initially de...

§  Creating(NOFORCE, WITH CHECK OPTION parameters) An...

§  On Associative Arrays, Nested Tables and Varrays I...

§  Handling Exceptions With Bulk Operations In Oracle...

§  Record Based Inserts And Updates

§  ANYDATA Type In Oracle

§  HttpUriType In Oracle

§  Authentication Of PL/SQL Programs : AUTHID CURRENT...

§  Date Time Related Data Types And Functions In Orac...

§  Rows To Columns Or Pivot Table with SQL Model Clau...

§  System Triggers In Oracle

§  Handling Deadlocks With SELECT FOR UPDATE SKIP LOC...

§  Large Objects as BLOB, CLOB In Oracle Database

§  ROWNUM and Aggregate Functions

§  Performance Analyze Of Query ReWrite and Pre Aggre...

§  Notes On SQL MODEL Clause In Oracle

§  Usage of OUTER JOIN PARTITION BY In Oracle

§  Online DDL Modifications In Oracle

§  Changing Data Type of Non Empty Column In Oracle

§  Oracle Flashback Table

§  Bulk Processing Performance Analysis On Oracle

§  Paging Techniques In Oracle

§  LEFT OUTER JOIN and NULL Values

§  How To Join Tables In Oracle With LEFT RIGHT OUTER...

§  Using Sequences For Data Integrity

§  Passing Object Parameters To Functions Remotely In...

§  Naming and Coding Standards for Oracle

§  NVL == COALESCE == DECODE

§  Dependent Objects and Object Statuses In Oracle

§  Performance Analyzes Of PIPELINED Functions In Ora...

§  Finding Duplicate Records In Oracle

§  Parsing XML Documents Using XPath In Oracle

§  BULK COLLECT INTO Collection Via SQL Statements In...

§  Performance Tests On Iterating Collections In Orac...

§  Handling Iteration Variable In FORALL Statements

§  Converting Rows To Columns In Oracle

§  Using INTERVAL DAY TO SECOND Data Type In Oracle

§  Dynamically Executing Schema Functions And Procedu...

§  Aggregation Functions and NO_DATA_FOUND Exception ...

§  CHAR and VARCHAR Diffrences In Oracle

§  Storing Collections In Oracle Database

§  Propagation Of Exceptions In PL/SQL

§  SERIALLY_REUSABLE Pragma On Creating Packages In O...

§  Deterministic Functions In Oracle

§  Parameter Types For PL/SQL Program Blocks

§  Asteriks Character On Creating Views In Oracle

§  V$FIXED_VIEW_DEFINITION View

§  Processing XML Data On Oracle Database

§  Oracle Date Formats RR and YY

§  Performance Anlyzes On Different Queries That Retu...

§  Calling External Functions Inside PL/SQL

§  Using DBMS_ERRORLOG Package

§  Text Punctuation Correction Techniques With Oracle...

§  Impilicit Casting On Pirimitive Types In Oracle

§  How To Extract Date Values In Oracle

§  Email Validation On Constraint Level Using Regular...

§  Oracle Set Operators

§  Oracle Single Row Character SQL Functions

§  On NULL Values

§  Gathering Database Metadata On Oracle and Microsof...

§  In One Minute Three Entry On Forums.Oracle.Com

§  Sample Deadlock Scenario On Oracle

§  Oracle Export Import Utilities

§  RMI Call via PL/SQL

§  Copy - Paste an Oracle Database Quickly

§  Column And Variable Scopes In PL/SQL

§  How to make a table readonly In Oracle

§  Oracle Block Buffer Cache