Answer Posted / urmi

select index_name from user_indexes u where u.TABLE_NAME=upper('table_name');

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

2033

---

Can group functions be used in the order by clause in oracle?

999

---

How does Oracle guarantee data integrity of data changes?

2393

---

What is the quickest way to export a table to a flat file?

968

---

How to connect to a remote server?

1128

---

How to drop an existing view in oracle?

947

---

What is the purpose of save points in oracle database?

1121

---

What are temporal data types in oracle?

1128

---

How to call a stored function in oracle?

1019

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4368

---

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2188

---

Why do you use stored procedures and state some of its disadvantages?

1028

---

What are the arithmetic operations?

1085

---

How do I uninstall oracle client from windows?

1012

---

What to do if dba lost the system password?

1173

---