0
Removes collision of primary key values
Faster access by using the cache option
Auto generation of sequence values
Stored as a database object and can be used for repeated access.
Disadvantages
Loss of sequence value (including the cached values) when power failure or system failure occurs.
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
What is the advantage of an oracle?
The advantage of an oracle is its ability to use the centralized management system.
What is a sequence in oracle?
"http://wiki.answers.com/Q/What_is_a_sequence_in_oracle"
What is he advantage of oracle 9i over oracle 8i?
it is having more advantages than 8i
What is the function of the replace parameter in Oracle?
The function of the replace parameter in Oracle is to replace a sequence of characters in a string with other characters, usually in sets of characters.
What is a case statement used for in Oracle?
The Case Statement in Oracle is a command that evaluates a condition (or a sequence of conditions) for one or multiple expressions. According to the value of those expressions a corresponding statement is executed.
What are the advantages of analyzing a fault by sequence network?
little advantage
What is the advantage of knowing a DNA sequence?
Scientists are able to study specific genes.
What are modules of oracle?
Oracle sells many functional modules which use the Oracle RDBMS as a back-end, notably Oracle Financials, Oracle HRMS, Oracle SCM, Oracle Projects, Oracle CRM, Oracle Procurement.
What is the meaning of i in oracle 9i?
The i in Oracle 8i and Oracle 9i stands for INTERNET....The i in Oracle 8i and Oracle 9i stands for INTERNET....The i in Oracle 8i and Oracle 9i stands for INTERNET....The i in Oracle 8i and Oracle 9i stands for INTERNET....
Why are conjectures important in finding unknown terms in a sequence or pattern of numbers?
In order to find the unknown term in a number sequence, you first need to calaculate the advantage of the numbers.
Who is the author of oracle?
Oracle is a product from Oracle corporation. www.oracle.com
What is oracle 12c?
Oracle r12 is Oracle release 12.
