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

if i am using dml statement in function. then i am writing select statement what was the output

2 Answers   MasterCard,

---

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

0 Answers   ESS,

---

What are the factors causing the reparsing of SQL statements in SGA?

1 Answers  

---

How to create a new tablespace in oracle?

0 Answers  

---

can you explain performance tunning in oracle(sql,PL/SQL)

2 Answers  

---

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

0 Answers  

---

What is meant by redo log buffer ?

2 Answers  

---

How to bring a tablespace online?

0 Answers  

---

How to do a full database export?

0 Answers  

---

1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.

6 Answers  

---

How to count duplicated values in a column in oracle?

0 Answers  

---

Can group functions be mixed with non-group selection fields?

0 Answers  

---