Re: SQL Plus

From: Y <yunus000_at_england.com>
Date: Wed, 01 Sep 1999 17:37:30 +0100
Message-ID: <37CD564A.9D537E3D@england.com>

Jill wrote:
>
> Is there anyway to do this globally? We have a table with about 40 or 50
> columns, and I just want to select * from it.
>

You really want blood don't you Jill baby.

You cannot do it globally.

try creating a spoolfile:

select 'col ' || column_name ||' format a25' from all_tab_columns
where table_name = upper('&table_name');

then run your edited spool file in your sql session.

Hope this helps.

--

---

"Don't be suckered in by the comments - debug only the code." To reply by e-mail remove '000' from my address

---

Received on Wed Sep 01 1999 - 11:37:30 CDT