Hi,
This statement will get you the userid and the number of times it is
duplicated. Then it's just a case of inserting the value at the desired
location. Although this does mean that you are either going to have a column
with lots of null values or lots of repeated values...Doesn't really make
Deewaker,
information you find with this select-stmt, perhaps you need to format the
output.
Depending on what you're looking for you should select either from the view:
user_indexes
all_indexes
dba_indexes
select
table_name,
index_name,
tablespace_name
from user_indexes
group by
Title: Help need
Hi deewakar,
hope this will help..
SELECT
TABLESPACE_NAME,TABLE_NAME,INDEX_NAME FROM DBA_INDEXESORDER BY 1,2,3/
Saurabh Sharma
Oracle DBA
[EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html
- Original Message -
From:
Deewaker
G.V.
To: