Answer / harikanth

How to select oracle sequence from different schema

ANS:
a. SCHEMANAME.SEQUENCENAME.CURRVAL.
b. SCHEMANAME.SEQUENCENAME.NEXTVAL

How to select oracle sequence from different Databases

ANS:

a. SCHEMANAME.SEQUENCENAME.CURRVAL@DBLINK
b. SCHEMANAME.SEQUENCENAME.NEXTVAL@DBLINIK

Thanks,
Hari

Can we call procedure inside function in oracle?

0 Answers  

---

Explain the use of rows option in imp command.

0 Answers  

---

How to create a server parameter file?

0 Answers  

---

What are ACID properties in databases?

1 Answers  

---

I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?

5 Answers   Zensar,

---

Can we save images in a database and if yes, how?

0 Answers  

---

1) Does oracle have any table which contain all the exceptions and it's code internally?

0 Answers   CTS,

---

What is catalog in Oracle?

0 Answers   MCN Solutions,

---

Explain the types of exception?

0 Answers  

---

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

0 Answers   Oracle,

---

defination of bitmap index

0 Answers   NIIT,

---

What are the different type of Segments ?

2 Answers  

---