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: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
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: 20892
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 Dec 05 03:05:51 CST 2016

Total time taken to generate the page: 0.06483 seconds