Re: ISO: sql technique to select information from more than one table
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Tue, 10 Mar 2009 19:20:05 +0100
Message-ID: <49b6af2e$0$182$e4fe514c_at_news.xs4all.nl>
Larry W. Virden schreef:
> On Mar 10, 12:48 pm, "Larry W. Virden" <lvir..._at_gmail.com> wrote:
>
>
>
> 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.
Date: Tue, 10 Mar 2009 19:20:05 +0100
Message-ID: <49b6af2e$0$182$e4fe514c_at_news.xs4all.nl>
Larry W. Virden schreef:
> On Mar 10, 12:48 pm, "Larry W. Virden" <lvir..._at_gmail.com> 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