Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL problem???

SQL problem???

From: Jimmy <96635500G_at_hkpa01.polyu.edu.hk>
Date: Tue, 18 Aug 1998 13:03:30 -0700
Message-ID: <35D9DE12.6D37@hkpa01.polyu.edu.hk>


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 Tue Aug 18 1998 - 15:03:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US