Re: Command line queries

In article <2quvt0$9s0_at_acsc.com>, <snehal_at_acsc.com> writes:
> sqlplus user/passwd _at_filename
> I am getting the output and end up with the SQL> prompt. How do I exit
automatically?

put EXIT as the last command in the script file "filename.sql"

> Also I am querying only one tuple at a time and I need the results in a non
 tabular form
> for eg:
>
> field1: value 1
> field2: value 2
> field3: value 3

use this combination of commands:
col NL newline
select

	'field1: ' || field1 NL,
	'field2: ' || field2 NL,
	'field3: ' || field3 NL
from
	table

--
dave mausner _at_ braun technology group, chicago