What is a table index in oracle?

0 Answers  

---

We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?

3 Answers  

---

What is tns name?

0 Answers  

---

What is the function of Optimizer ?

1 Answers  

---

how to get the index id?

1 Answers   Cognizant, TCS,

---

Can we write dml statement in function in oracle?

0 Answers  

---

What are nested tables?

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  

---

WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.

3 Answers  

---

consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?

1 Answers  

---

what is view?

7 Answers   Accenture,

---

Can a formula column be obtained through a select statement ?

0 Answers   Oracle,

---