ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Databases  >>  Oracle  >>  Oracle AllOther
 
 


 

 
 Oracle General interview questions  Oracle General Interview Questions
 OCI interview questions  OCI Interview Questions
 Architecture interview questions  Architecture Interview Questions
 Oracle Security interview questions  Oracle Security Interview Questions
 Database Management interview questions  Database Management Interview Questions
 Forms Reports interview questions  Forms Reports Interview Questions
 Oracle AllOther interview questions  Oracle AllOther Interview Questions
Question
Whats the purpose of using Nextval while creating the 
sequence.
 Question Submitted By :: Ram
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Whats the purpose of using Nextval while creating the sequence.
Answer
# 1
To get the next value of a sequence, we use nextval.


 NextVal is pseudo column, which gives you the AVAILABLE 
number in the sequence.
 Remember the nextval value also depends on the cache you 
have given, while creating the sequence.
 If you want current value of a sequence you can use CurVal.
 In a session you cannot use current value without getting 
next value.
 In 11g the you can use the nextval without using the query.
ie 
   select seq_name.nextval into ln_seqnextval from dual;
           can be replaced by 
    ln_seqnextval := seq_name.nextval;
 
Is This Answer Correct ?    1 Yes 0 No
Sreekanth
 
  Re: Whats the purpose of using Nextval while creating the sequence.
Answer
# 2
NextVal is pseudo column, which gives you the unique number 
in the sequence.
nextval increment the sequence and return new value.
currval can only be accessed in given session after at least
 one nextval has been issued.
 
Is This Answer Correct ?    1 Yes 1 No
Tharanath.n
 
 
 

 
 
 
Other Oracle AllOther Interview Questions
 
  Question Asked @ Answers
 
What is index? How many types of indexes?  1
What is difference b/w Credit memo and Adjustment in AR. Oracle1
Whats the purpose of using Nextval while creating the sequence. HCL2
i am having comm in emp table and i want to display 0 when comm =null and -10 if comm= value IBM4
Name a tablespace automatically created when you create a database.  1
What is database schema?  2
Can We Restore a Table that accidantly dropped. TCS2
A Table has 10,000 records,How can i get latest 10 dates from the table.so that i can only store those 10 records in to my Resultset Object,to reduce load on my app? TCS4
Explain an ORA-01555  1
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.  1
Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?  2
Compare and contrast TRUNCATE and DELETE for a table.  3
How do you resize a data file?  1
why r u using etl tool.  2
what is the difference between TRUNCATE and DELETE command in SQL TCS12
WHAT IS CARDINALITY?  1
What are the main diff. between oracle 7.3 and oracle 8i?  1
How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun  1
pl help me, i want oracle HRMS training institute address,in chennai  1
How do you use trigger to create mutating state of table TCS2
 
For more Oracle AllOther Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com