Answer Posted / bas

when ever commit or rollback statement occurred in the end
of trasaction

IS it possible to built the oracle database without setting the kernal parameters?

2268

---

How to change program global area (pga) in oracle?

1031

---

How to define an anonymous procedure without variables?

1019

---

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2257

---

What are a collation and state the different types of collation sensitivity?

1091

---

List out the types of joins.

1079

---

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2066

---

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1692

---

What is the difference between "as" and "is" in an oracle stored procedure?

931

---

What are the various constraints used in oracle?

988

---

What is a dynamic performance view in oracle?

948

---

What is blob datatype?

1051

---

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2198

---

How to loop through data rows in the implicit cursor?

1011

---

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2087

---