« Technical Interview & Viva Questions : KyaPoocha.com home page
« What is CYCLE/NO CYCLE in a Sequence?
What is a database link? »



How to access the current value and next value from a sequence? Is it possible to access the current value in a session before accessing next value?


Sequence name CURRVAL, sequence name NEXTVAL. It is not possible. Only if you access next value in the session, current value can be accessed.



Explore posts in the same categories: Oracle Interview Questions


BOOKMARK THIS : del.icio.us | Digg it | Furl | reddit |

Related Questions :

  • What is Current record attribute property?
    • Specifies the named visual attribute used when an item is part of the current record. Current Record Attribute is frequently used...
  • How do I write code to get the current drive as well as set the current drive?
    • The function getdisk( ) returns the drive number of current drive. The drive number 0 indicates 'A' as the current...
  • What is the difference between sessioncontext and entitycontext?
    • Since EnterpriseBeans live in a managed container,the container is free to call your EJB components methods at its leisure. The container...
  • What is session where it runs & what are different types of session handling?
    • Session is a mean to maintain client identity, many client may request a single page further they may visit several...
  • How to obtain the current drive through C ?
    • We can use the function _getdrive( ) to obtain the current drive. The _getdrive( ) function uses DOS function 0X19...
  • What is session bean
    • An enterprise bean that is created by a client and that usually exists only for the duration of a single...
  • What are the difference between call screen and leave screen?
    • Call Screen: Calling a single screen is a special case of embedding a screen sequence. If you want to prevent...
  • What is the order of method invocation in an Applet ?
    • public void init() : Initialization method called once by browser. public void start() : Method called after init() and contains code...
  • What are the functional modules used in sequence in BDC?
    • These are the 3 functional modules which are used in a sequence to perform a data transfer successfully using BDC...
  • What are the differences between SAP memory and ABAP memory?
    • ABAP Memory is a memory area in the internal session (roll area) of an ABAP program. Data within this area...

    Comments are closed.