From ddlutils-user-return-815-apmail-db-ddlutils-user-archive=db.apache.org@db.apache.org Mon Mar 17 14:09:44 2008 Return-Path: Delivered-To: apmail-db-ddlutils-user-archive@www.apache.org Received: (qmail 54570 invoked from network); 17 Mar 2008 14:09:44 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 17 Mar 2008 14:09:44 -0000 Received: (qmail 37764 invoked by uid 500); 17 Mar 2008 14:09:41 -0000 Delivered-To: apmail-db-ddlutils-user-archive@db.apache.org Received: (qmail 37751 invoked by uid 500); 17 Mar 2008 14:09:41 -0000 Mailing-List: contact ddlutils-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ddlutils-user@db.apache.org Delivered-To: mailing list ddlutils-user@db.apache.org Received: (qmail 37740 invoked by uid 99); 17 Mar 2008 14:09:41 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 17 Mar 2008 07:09:41 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [206.190.38.181] (HELO web51402.mail.re2.yahoo.com) (206.190.38.181) by apache.org (qpsmtpd/0.29) with SMTP; Mon, 17 Mar 2008 14:08:49 +0000 Received: (qmail 63290 invoked by uid 60001); 17 Mar 2008 14:09:09 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID; b=V2a/OPOuKybK/el+/6FzSSiAZyZ6Q1hc8OGye2zYfqPgXsSWVVsiq3OhkkexfJ+kaKKi2RihCgmy8uAAVQThD0ZQSx3u6ROAwnLVmY3tu8krzSCzp/pto0RspWheWvFg612cZMiVikV/DW20XylvlLxFJ/tPXZNU0DbYPVb1fes=; X-YMail-OSG: AeRYx9kVM1nrcpyjKaTI_zlOcotR1BdIK9c9XyJttO3tbEuAQfE5Fokp0LuIUeFCcwCE1V3LJbTk7G7Ire.mjymhvmCep9.vo4drCq_F.o33_jAO7JBWgVg_ZNPMgg-- Received: from [160.33.98.118] by web51402.mail.re2.yahoo.com via HTTP; Mon, 17 Mar 2008 07:09:08 PDT X-Mailer: YahooMailRC/902.38 YahooMailWebService/0.7.162 Date: Mon, 17 Mar 2008 07:09:08 -0700 (PDT) From: tyju tiui Subject: Re: AW: ddlutils access to sequence names To: ddlutils-user@db.apache.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1033293306-1205762948=:62752" Message-ID: <138860.62752.qm@web51402.mail.re2.yahoo.com> X-Virus-Checked: Checked by ClamAV on apache.org --0-1033293306-1205762948=:62752 Content-Type: text/plain; charset=us-ascii Ahh, Thank you Stefan. That helps. ----- Original Message ---- From: Stefan Huber To: ddlutils-user@db.apache.org Sent: Monday, March 17, 2008 3:42:07 AM Subject: AW: ddlutils access to sequence names Hi, There is a system view named 'user_sequences' in the oracle database. It gives you a list of all sequences owned by the current user. See http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_4435.htm#i1635275 for detalis. Stefan # Hi, # # I'm using an Oracle backend which uses sequences for auto increment. # Is there any way I can find the names of my sequences from the db model? # # Thanks, # # Ty ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ --0-1033293306-1205762948=:62752--