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

#11

Larry W. Virden schreef:

Quote:

On Mar 10, 12:48 pm, "Larry W. Virden" <lvir... (AT) gmail (DOT) 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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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

comp.databases.oracle.misc comp.databases.oracle.misc

Re: ISO: sql technique to select information from more than one table - 03-10-2009 , 12:20 PM