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

How to empty your oracle recycle bin?

0 Answers  

---

Point out the difference between user tables and data dictionary?

0 Answers  

---

Find all employees in Dept “Marketing”.

2 Answers  

---

Can we commit inside a function in oracle?

0 Answers  

---

What is index-organized table in Oracle?

0 Answers   MCN Solutions,

---

after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble

1 Answers  

---

What is difference between Rename and Alias?

1 Answers  

---

How to create tables for odbc connection testing?

0 Answers  

---

What WHERE CURRENT OF clause does in a cursor?

2 Answers  

---

can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?

2 Answers   Allfon,

---

Draw E-R diagram for many to many relationship ?

0 Answers   Keane India Ltd,

---

How do I reset a sequence in oracle?

0 Answers  

---