[program-l] Re: Oracle sql question
- From: Richard Bartholomew <richard_bartholomew@xxxxxxxxxxxxxxxx>
- To: program-l@xxxxxxxxxxxxx
- Date: Fri, 30 Oct 2009 08:23:55 +0000
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:
