What is rank function in sql?

0 Answers  

---

How do you use join?

0 Answers  

---

What are types of joins?

0 Answers  

---

How to fetch records from a partitioned table?

2 Answers   HSBC,

---

what is Complex index. how to create it?

2 Answers  

---

What are the advantages of sql?

0 Answers  

---

in a package one procedure is wrong package shows valid or not

4 Answers  

---

how to create object in plsql

2 Answers   TCS,

---

What are different types of functions in sql?

0 Answers  

---

what will be the output: select 1 from emp union all select 2 from emp;

2 Answers   iNautix,

---

Create a procedure to delete certain records from a table and display the total number of records deleted in this process. (Condition for deletion can be of ur choice, for instance delete all records where eid='')

2 Answers  

---

There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the table has already data in the sequence column as 100,101,102... Is it possible to do so ?

4 Answers   IBM,

---