Xref: alice comp.databases.oracle.misc:35511 Path: alice!news-feed.fnsi.net!netnews.com!newspeer.monmouth.com!dispose.news.demon.net!demon!news.demon.co.uk!demon!imat.demon.co.uk!not-for-mail From: "Matt Randle" Newsgroups: comp.databases.oracle.misc Subject: Referencing columns by their position in a table ?? Date: Wed, 7 Jul 1999 13:12:52 +0100 Message-ID: <931349966.7333.0.nnrp-12.d4e48d0d@news.demon.co.uk> X-Trace: news.demon.co.uk 931349966 nnrp-12:7333 NO-IDENT imat.demon.co.uk:212.228.141.13 X-Complaints-To: abuse@demon.net X-Newsreader: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Lines: 12 Can anyone tell me if there's a way of specifying a column to retrieve as part of a select statement by the position of the column in the table. For example, a have a table where I know I want to retrieve the 2nd column but I do not know what the column is called ?? Thanks, Matt.