Re: ISO: sql technique to select information from more than one table

From: Shakespeare <>
Date: Tue, 10 Mar 2009 19:20:05 +0100
Message-ID: <49b6af2e$0$182$>

Larry W. Virden schreef:
> On Mar 10, 12:48 pm, "Larry W. Virden" <> wrote:
>> Ah - removing the blank line before the ; now actually causes the
>> select to execute. However, what I get is two lines - the first column
>> of the first line says "csi_security" followed by the csi_hr name and
>> then the csi_security name. Then, 1348 lines later, there is a second
>> line which says "csi_telecom" in the first column, followed by the
>> csi_hr name and then the csi_telecom name.

> Let me clarify. I get 1700+ lines output. The first 1349 lines are the
> results relating to csi_security. The last 356 lines are tagged as
> being from the csi_telecom table.

You could take a look at formatting options for SQLPLUS, like set linesize, 'column format' etc.
Each record should be on a new line, but if your columns are too wide, things tend to get unreadable.

Shakespeare Received on Tue Mar 10 2009 - 13:20:05 CDT

Original text of this message