Re: ORA-00900: invalid SQL statement when using Perl DBI::Oracle module

From: Panos Kavalagios <P.Kavalagios_at_hydro.ntua.gr>
Date: 2000/06/02
Message-ID: <39376954.C6EC232D@hydro.ntua.gr>#1/1

Pedro Quintero wrote:

> There is a much better way to get the information on the columns of a table:
> use the view DBA_TAB_COLUMNS. (OR DBA_TAB_COLS?).
>
> You can use a cursor to manipulate this info.

Both views dba_tab_columns and all_tab_columns provides exactly the same result. Now, I'm confused! What should I use? Is there any documentation about these tables/views?

Well, about the "describe" it appeared in the major revision of SQL standard in 1992, also known as SQL2. All Oracle applications, support these extensions up to the Entry SQL92 level.

Panos Kavalagios Received on Fri Jun 02 2000 - 00:00:00 CDT