Home -> Usenet -> comp.databases.oracle -> Creating sequences.

Creating sequences.

From: Lance Carver - Oklahoma City University <carver_at_frodo.okcu.edu>
Date: 1996/02/27
Message-ID: <4gu0fd$hii_at_lec.okcu.edu>#1/1 






Hello,



        I am trying to reinitialize a sequence number, depending on the change
of a date.  The following is the code I am using, however it keeps erroring
out on the select statement.  Can anyone help???



create sequence job_sequence_num


  increment by 1


  maxvalue (select distinct job_num_yy||job_num_mm||job_num_dd

             from job_log_tbl
              order byh job_num_yy||job_num_mm||job_num_dd;)


  minvalue 1


  cycle;



All help will be appreciated!




    
  
  •   ||        |||||     |||  ||    |||||   |||||       =====

  
      
    
    •   ||       |||||||    || | ||   ||       |||         =======

    
        
      
      •   |||||   ||     ||   ||  |||    |||||   |||||       =========

    
      
    
    •   ========   

    
        
      
      •   Lance Carver        |   CARVER_at_frodo.okcu.edu    ======   

    
      

  
    
  
  •   Oklahoma City University  |        405.521.5455        =====

    



Received on Tue Feb 27 1996 - 00:00:00 CET












Original text of this message