Answer Posted / david

select substr(filename,1,6),data from table1;



tjis is ur solution ..if any confusion regards this question
plz post there...


thanks
gunjan david

What is the data pump export utility?

1134

---

How index is implemented in oracle database?

1048

---

What are the ways tablespaces can be managed and how do they differ?

2450

---

Can we use bind variables in oracle stored procedure?

987

---

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

1047

---

What is a table index in oracle?

1187

---

How can we delete duplicate rows in a table?

1039

---

What is using clause and give example?

1109

---

What is a lookup table in oracle?

1026

---

Can we connect to ORACLE db using Windows Authentication?

1308

---

can u plz provide me oca sql dumps please i need them

1999

---

Explain the use of file option in exp command.

1177

---

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

3022

---

What is a synonym? What are its various types?

1174

---

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2271

---