ReliDB

ReliDB

Oracle tips and tricks.

ReliDB RSS Feed
 
 
 
 

Posts tagged generate

Create Oracle Public Synonyms

Oracle uses synonyms to point users to other schema objects when the user does not have direct access to that schema. This is generally accomplished by creating a synonym owned by public to a private schema object. Once the public synonym is created all users have access to the private schema object. [...]

Posted on August 22nd, 2009 under Oracle, Oracle 10g, SQL, oracle 9i. Tags: , , , , , . Comments: None

Recreate Oracle Sequence

Oracle uses Sequences to generate unique numbers to identify specific records. Once a sequence has been defined all a programmer or Oracle developer needs to obtain a unique key value for a record is to call the sequence. This article demonstrates how to generate the DDL for an already defined sequences in an [...]

Posted on August 22nd, 2009 under Oracle, Oracle 10g, oracle 9i. Tags: , , , , , . Comments: None