[program-l] Re: Oracle sql question
- From: "Justin Daubenmire" <justind@xxxxxxxxx>
- To: <program-l@xxxxxxxxxxxxx>
- Date: Fri, 30 Oct 2009 07:09:52 -0400
Hi Richard,
Can you please post us the syntax to create a sequence?
Thanks!
/Justin
----- Original Message -----
From: Richard Bartholomew
To: program-l@xxxxxxxxxxxxx
Sent: Friday, October 30, 2009 4:23 AM
Subject: [program-l] Re: Oracle sql question
Hi,
Although there is no field called TEXT in the view, all the relevant
information is there, eg the minimum and maximum values of the sequence,
whether it should cycle when max is reached, the increment amount and the
latest number being used. Therefore, you just need to fit the values into the
CREATE SEQUENCE syntax - I'm sure that's all that TOAD did.
Richard Bartholomew
Senior Technician
ISOS Enterprise Middleware
Standard Life Employee Services Limited
http://www.standardlife.com
Tel: +44 (0)131 245 1667
"Lafond, Eileen" <Eileen.Lafond@xxxxxxxxxxx>
Sent by: program-l-bounce@xxxxxxxxxxxxx
29/10/2009 19:38 Please respond to
program-l@xxxxxxxxxxxxx
To "program-l@xxxxxxxxxxxxx" <program-l@xxxxxxxxxxxxx>
cc
Subject [program-l] Oracle sql question
Hi,
I need to get the code that was used to develop a sequence. The name of the
sequence is budgets_seq.
In the user_sequences table there is no field called text. In the other user
tables I get the code by doing a select of the text field based on the name of
the item.
since there is no text field, can anyone tell me how to get the code for this
particular sequence?
We no longer have Toad so that is not an option.
Thanks for any help,
Eileen La Fond
phone number: (206) 386-0011
email: eileenlafond@xxxxxxxxxxx
This e-mail is confidential and, if you are not the intended recipient,
please return it to us and do not retain or disclose it. We filter and monitor
e-mails in order to protect our system and the integrity, confidentiality and
availability of e-mails. We cannot guarantee that e-mails are risk free and are
not responsible for any related damage or unauthorised alteration of e-mails by
third parties after sending.
For more information on Standard Life group, visit our website
http://www.standardlife.com/
Standard Life plc (SC286832), Standard Life Assurance Limited* (SC286833) and
Standard Life Employee Services Limited (SC271355) are all registered in
Scotland at Standard Life House, 30 Lothian Road, Edinburgh EH1 2DH.
*Authorised and regulated by the Financial Services Authority. 0131 225 2552.
Calls may be recorded/monitored. Standard Life group includes Standard Life plc
and its subsidiaries.
Please consider the environment. Think - before you print.
Other related posts:
