What are local and global Indexes and where they are useful.

0 Answers  

---

Can you join a table to itself?

0 Answers  

---

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

1 Answers  

---

What are sql objects?

0 Answers  

---

What is the difference between syntax error and runtime error?

0 Answers  

---

what is a cursor

9 Answers   IBM, TCS, Wipro,

---

1.when will you use week refcursor and when will you use strong ref cursor ? 2.what is the use of sql trace..how do you use it ? 3.can you please send all the sql plus commands...like set line 6000....

1 Answers   Satyam,

---

check whether all the emp numbers are indeed unique.

6 Answers  

---

Delete the emps whose salaries are lowest sals of their own dept.

5 Answers  

---

How can you load multi line records? : aql loader

0 Answers  

---

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  

---

what are sequences

0 Answers  

---