Answer / sudipta santra

ADDING THE CYCLE KEYWORD.

ALTER SEQUENCE SQ1 CYCLE;

What is the difference between column level constraints and table level constraints?

14 Answers   IBM, TCS,

---

What is the purpose of init.ora. ? how many init.ora exist in oracle installation? suppose there are 3 database on one oracle server, how many init.ora do I have? what are various database objects? how will you identify memmory related performace issue in oralce? any idea about basic architure difference of oracle and db2? comment on which is better , with reasons? what is a fuction based index? is it recommended to use the same. ? what is global temporay table? what is teh signification of the parameter session_cached_cursor ?

1 Answers   HDFC,

---

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

0 Answers   iFlex,

---

3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.

0 Answers   Wipro,

---

Can we use bind variables in oracle stored procedure?

0 Answers  

---

Why does oracle 9i treat an empty string as null?

0 Answers  

---

What are steps required to ENTER DATA INTO DWH?

2 Answers  

---

difference between procedures and function?

7 Answers   IBM,

---

What is a Shared SQL pool ?

2 Answers  

---

In Oracle 10g, "g" Stands for what?

5 Answers   Mphasis,

---

What is the difference between pre-select and pre-query?

0 Answers  

---

How to use existing values in update statements using oracle?

0 Answers  

---