For SQL-Freaks: Column-Renaming in Oracle-SQL (version 7)
Date: 1995/11/20
Message-ID: <48q7ae$bqr_at_news.rz.uni-passau.de>#1/1
I have the following SQL-problem:
I only know the tablename and the number of columns of a certain table
(e.g. 'supplies' with col-number = 3 ). I only want to fetch the values of
the columns one and three (its only an example, i need a general solution!) of 'supplies'.
To my knowledge, the following standart-sql-instruction (renaming of columnnames)
is correct:
SELECT R.c0, R.c2
FROM supplies R(c0, c1, c2)
WHERE R.c1 > 12.00;
The problem is now, ORACLE 'SqlPlus' (Version 7) doesn`t agree with me relating to correctness of the statement above!
Many thanks for relevant informations either for correction the statement above or completely different solutions for my problem!
Klaus Berndl Received on Mon Nov 20 1995 - 00:00:00 CET