Re: SQL problem???

Hi Jimmy
If you experience a delay in variant 2 this simply has to do with parsing. All SQL statements are being parsed backwards, from the end to the beginning. However, two things to note:
- Sql*plus is a special tool because it is an interpreter and so parses ALWAYS - the second variant is the preferred way of writing sql statements in order to keep them readable

Hth
Sybrand Bakker

Jimmy wrote:

> Hello all,
> I have two SQL files. The content of these two files is the same and as
> follow:
>
> EX1.SQL:
> select A1,A2,A3,A4,A5,A6,A7,A8,A9,A10 from A;
>
> EX2.SQL:
> select A1,
> A2,
> A3,
> A4,
> A5,
> A6,
> A7,
> A8,
> A9,
> A10 from A;
>
> EX2.SQL split the SQL statement in different lines.
> If both SQL files are executed in SQL*Plus, is the execution time of
> ex1.sql faster then ex2.sql? And why?
>
> Thanks,
> Jimmy
Received on Wed Aug 19 1998 - 11:41:30 CDT