Hallo,
I have some trouble to get this pl/sql code right. Anyone whpom could help me with
this. It is important.
Hallo,
I have some trouble with this pl/sql procedure. I would like
that this lvsql to be run only if the field Borttags_flagg = 0 but i get an error in
the if statement, what
Chark"
ld.com.au> cc:
Sent by: Subject: urgent hel
all,
our company just installed the virtual private network equipment
(Enterasyss Network), then suddenly peoplesoft application can not login to
the oracle database any more, came back with ora 12203, then I tries tnsping
nothing works either, however I can do sqlplus user/password@tns and it le
Title: Help Need
Hi DBA Gurus,
I have a table called user..
It has userid, firstname, lastname, city, address, telephone, email
There are some userid which have been reentered .. I would like to insert a column called repeats and take the number of times the userid is repeated
How to I
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
Title: Help Need
Are
all the columns in user repeated? I doubt it because you would just remove
duplicate records. I am assuming userid is key field.
You
could try
CREATE
TABLE usercheck AS SELECT * FROM user;
ALTER
TABLE usercheck ADD(repeated NUMBER);
UPDATE
usercheck a
SET
repeated
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
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 tab
Title: Help need
HI DBA Guru's
I wanted to know all the Index names under respective table spaces
For example
Tablespace is Production
Table name : customer, item, supplier
index Names idx_customer_custid
idx_customer