Answer Posted / 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 |
Post New Answer View All Answers
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
How to find out what oracle odbc drivers are installed?
What is archive log in Oracle?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Difference between oracle's plus (+) notation and ansi join notation?
What is a table index?
How can I see all tables in oracle?
What is a relational database management system?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
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'));
How to define an explicit cursor in oracle?
How to use regular expression in pattern match conditions in oracle?
How many memory layers are in the oracle shared pool?
What to do if the binary spfile is wrong for the default instance?
Explain the difference between a procedure and a function?
