What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?

1 Answers  

---

What does `(+)` do in a where clause?

1 Answers  

---

How to Select second Maximum salary in a Table ?

13 Answers   Oracle,

---

t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.

2 Answers   MasterCard,

---

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

0 Answers  

---

primary key is foreign key for the same table?

2 Answers   Oracle,

---

How to call a sub procedure?

0 Answers  

---

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

0 Answers   Mastek,

---

How to use "if" statements on multiple conditions?

0 Answers  

---

What is the sql query to concatenate column values from multiple rows in oracle?

0 Answers  

---

I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.

6 Answers  

---

1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.

1 Answers   Wipro,

---