Answer Posted / khushin dhulla

yes

How to use regular expression in pattern match conditions in oracle?

980

---

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2514

---

How to drop an existing table in oracle?

1020

---

What is tns service name?

1087

---

How to best split csv strings in oracle 9i?

997

---

What are the differences between char and nchar in oracle?

1029

---

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

1382

---

What is the recommended interval at which to run statspack snapshots, and why?

2877

---

How to use values from other tables in update statements using oracle?

1035

---

Define oracle database

1000

---

How to view all columns in an existing table?

881

---

What is a relational database management system?

1072

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1870

---

Differentiate between function and procedure in oracle.

1026

---

What is the data pump import utility?

982

---