Re: Renaming columns in SQL-queries
Date: 1996/03/05
Message-ID: <4hi2bo$oed_at_news.Belgium.EU.net>#1/1
In article <4hhoet$arm_at_news.rz.uni-passau.de>,
berndl_at_chekov.uni-passau.de says...
!>
!>Please look at the following sql-statement:
!>
!>SELECT t111.col0, t111.col1, t111.col2
!>FROM supplies AS t111(col0, col1, col2)
!>WHERE t111.col1 = 'oceangarden'
!>
!>Because i don't know the column-names of supplies but the number of
columns
!>i want to rename the column-names!
!>I found this code in a paper but ORACLE produces always the following
error:
!>
!>from supplies as t111 (col0, col1, col2)
!> *
!>ERROR at line 2:
!>ORA-00933: SQL command not properly ended
!>
!>It seems this code doesn't comply with the SQL-standart!
!>
!>Have you any answer to me?
!>
!>
!>Many thanks in advance!
!>
!>Ciao,
!> KLaus
I'm afraid that paper doesn't follow Oracle's SQL-syntax.
If you don't know supplies' columns, why not try a
"describe supplies" ?
Received on Tue Mar 05 1996 - 00:00:00 CET