What is an Oracle sequence?
Answer / 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 |
16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.
How to turn on or off recycle bin for the session?
Is there any function in oracle similar like group_concat of mysql?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
how to genarate random numbers in oracle for particular row?
What do you know about normalization? Explain in detail?
Explain the difference between replace() and translate() functions in oracle?
What is the oracle implicit cursor?
How to create a temporary table in oracle?
Explain the use of file option in exp command.
What are the data types in oracle?
What are the different types of modules in oracle forms?