RE:Buffer use under Oracle

From: <M.K.Jha_at_ponl.com>
Date: Wed, 12 May 2004 13:28:00 +0100
Message-ID: <NXc0e434-35835d32@eur.ponl.com>

Hi,
can u send the output of following query... after that tryt to explain ... your Q?

select rpad(a.index_name,30),rpad(a.column_name,30), b.NULLABLE , rpad(a.column_position,5)
from all_ind_columns a, all_tab_columns b where a.table_name like upper('&tab') and a.table_name=b.table_name and
a.column_name=b.column_name
order by 1,4;

Cheers,
Manoj Kumar Jha

---

The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete the e-mail and other copies of it from your computer system. Thank you.

We believe this email to be virus free but do not warrant that this is the case and we will not accept liability for any losses arising from any virus being transmitted unintentionally by us.

We reserve the right to monitor all E-mail communications through our network

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Wed May 12 2004 - 07:26:38 CDT