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
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 sort the query output in oracle?
What is the difference between $oracle_base and $oracle_home?
What are the differences between char and varchar2 in oracle?
What is define in oracle?
What is user managed backup in Oracle?
when do u go for hash partitioning?
Why do you create or replace procedures rather that drop and recreate.
Does facebook use oracle?
when a grant option is encountered for a table EMP to a peer sitting beside you who has already having the table of that name (EMP), then what is the result?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
structural difference between bitmap and btree index ?
what is pragma?