Home » SQL & PL/SQL » SQL & PL/SQL » creating sequences
creating sequences [message #263922] Fri, 31 August 2007 05:11 Go to next message
user82
Messages: 49
Registered: June 2006
Location: Romania
Member
Hi all...
There is a possibility of creating tables using syntax CREATE TABLE mytab AS SELECT ... FROM..
Is there any possibility to create sequences like the above syntax...i mean not to follow all the steps required by the CREATE SEQUENCE clause, just selecting another sequences from another user's schema???
Re: creating sequences [message #263926 is a reply to message #263922] Fri, 31 August 2007 05:21 Go to previous messageGo to next message
vamsi kasina
Messages: 2108
Registered: October 2003
Location: Hyderabad, India
Senior Member
No.

By
Vamsi
Re: creating sequences [message #263928 is a reply to message #263922] Fri, 31 August 2007 05:21 Go to previous message
Littlefoot
Messages: 21123
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
No, it isn't possible (as far as I can tell).

Why? Is it a problem to write (in its simplest way)
CREATE SEQUENCE seq2;
Previous Topic: merge full syntax in oracle 10g
Next Topic: Character to number (merged)
Goto Forum:
  


Current Time: Mon Jun 26 15:59:53 CDT 2017

Total time taken to generate the page: 0.25037 seconds