Interested to Buy Any Domain ? << Click Here >> for more details...
how to use sequence and what use of sequence cache
- 1 Answers
- 4540 Views
- I also Faced
- E-Mail Answers
Answer / pravin
sequence is sharable object in database which is use to
generate unique number
use of sequence is like
insert into table(emp_id,name)values
(sequencname.nextvalue,name)
&
cache is the memory use to how manu values preallocates in
memory & keep in memory defined in cache.
by default 20 values can be stored in cache.
| Is This Answer Correct ? | 3 Yes | 0 No |
How to assign values to variables?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?
How many types of cluster table in Oracle?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
what are actual and formal parameters?
i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?
What is trigger associated with the timer ?
what's query optimization and without use of IN AND Exist can we get another way data from query
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
Explain the use of inctype option in exp command.
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
Oracle General 
