What is a Sequence ?
Answers were Sorted based on User's Feedback
Answer / kumar
Sequence is used for number generation.
We can create a sequence and cannot update a sequence
directly.
After creating a sequence we ca use functions nextval,
currval and setval to operate on the sequence.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / s. senthil kumar
A sequence generates a serial list of unique numbers for
numerical columns of a database's tables.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / guest
Sequence is used to provide unique values to database
object.
| Is This Answer Correct ? | 0 Yes | 1 No |
What is varray?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
Give syntax for SQL and ORACLE joins.
How to view the data files in the current database?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
Can we save images in a database and if yes, how?
What is currency type in database ?
What is meant by redo log buffer ?
Explain the difference between a procedure and a function? What do you understand by those terms?
How to update values in a table in oracle?
which statement is running fastly ie insert or delete?
How to define a data field as not null?