Re: Command line queries

In article <2quvt0$9s0_at_acsc.com>, snehal_at_acsc.com (Snehal Patel) writes:
|> Hi!
|>
|> I am not very familiar with Oracle utilities and would appreciate any input as to how to do the
|> following
|>
|> I need to execute an SQL query from the unix prompt ad get the results to stdout and then exit
|>
|> If I use
|>
|> sqlplus user/passwd _at_filename
|>
|> I am getting the output and end up with the SQL> prompt. How do I exit automatically?

In your sql file include the EXIT command.

|> 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
|>
not sure what you are attempting to do ... could you restate the problem?

|> and so on.....
|>
|> Please let me know at your earliest convenience
|> thanks in advance
|>
|> **Snehal Patel**
|> <snehal_at_acsc.com>
|>
Received on Tue May 17 1994 - 14:24:49 CEST