Answer Posted / nishi
A sequence is an object in Oracle that is used to generate a number sequence. This can be useful when you need to create a unique number to act as a primary key.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a dead lock in oracle?
What are ddl statements in oracle?
Difference between open_form and call_form in oracle.
How to count duplicated values in a column in oracle?
what is difference between sql plus and sql*plus? (not sql and sql plus).
what are archived logs?
How to create a new user account in oracle?
How to assign query results to variables?
Explain the use of record length option in exp command.
What is a trace file and how is it created in oracle?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What is tns entry?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
Explain an index?
What are joins, explain all types of joins?