Exforsys

Online Training

Sequence Query

This is a discussion on Sequence Query within the Oracle Database forums, part of the Database category; I want to know what happens when a user tries to execute a create sequence statement for an existing sequence. ...


Go Back   Exforsys > Database > Oracle Database

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 07-10-2007, 05:01 AM
Senior Member
 
Join Date: Apr 2006
Posts: 122
rachelle is on a distinguished road
Sequence Query

I want to know what happens when a user tries to execute a create sequence statement for an existing sequence. What would be the next value of sequence after the above statement gets executed? Someone kindly provide a brief idea on this.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 08-24-2007, 07:42 AM
Junior Member
 
Join Date: Aug 2007
Posts: 2
sujan kumar is on a distinguished road
When you create a sequence,do you refer to any other object?No. you create a sequence by specifying the sequence paramaters,but not based on another sequence.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads

Thread Thread Starter Forum Replies Last Post
How to find second max sal of employee with the co chandraismoon Oracle Tutorials 7 05-16-2008 04:08 AM
Query with Querying Database rachelle MySQL 1 05-11-2007 04:41 PM
Performance of Query Ralph MySQL 2 05-08-2007 05:44 PM
SQL QUERY IN REPORTS 6i:Pls help nitinkoshymech Oracle Database 1 11-27-2006 10:34 AM
how to use the same form for query mode and input mode bhaskara avunoori Oracle Apps 1 06-23-2006 07:07 AM


All times are GMT -4. The time now is 10:17 AM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0
Copyright 2004 - 2007 Exforsys Inc. All rights reserved.