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,
by: Subject: urgent help need please
[EMAIL PROTECTED
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
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
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
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_name
idx_item_itemid
idx_item_name
idx_supplier_itemid
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
