Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> SQL problem???
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 ofex1.sql faster then ex2.sql? And why?
Thanks,
Jimmy
Received on Tue Aug 18 1998 - 15:03:30 CDT
![]() |
![]() |