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: 21148
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: How to use switch case to run either of two select statements?
Next Topic: Button Problem PL/SQL
Goto Forum:
  


Current Time: Sun Aug 20 10:41:34 CDT 2017

Total time taken to generate the page: 0.06237 seconds