What does “select count(*) from tab” result?

15 Answers   IBM, Student, Wipro,

---

Mention what is the function that is used to transfer a pl/sql table log to a database table?

0 Answers  

---

hello..... i am an comp science engineering graduate planning to do ORACLE certification in PLSQL 9i. just wanted to know whats the possibility getting job is their openings???? is it worth doin that course n certification

1 Answers  

---

What are reports usually used for?

0 Answers  

---

Is primary key a clustered index?

0 Answers  

---

---

I Have A Table Like This. Cityno Cityname Mails 1 Bangalore 8km 2 Hsr Layout 20km 3 Mejistic 30km 4 Jayadeva 55km 5 Itpl 80km 6 Hebbal 115km I Have Data Like This I Want O/p Like This Distance No.ofcity 0-50km 3 51-100km 2 101-150km 4 And So On

6 Answers   DELL, HCL, Oracle,

---

How to pronounce postgresql?

0 Answers  

---

What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?

1 Answers  

---

Can you have multiple SPs with the same name on a database?

2 Answers   CGI, Quest,

---

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  

---

Explain the working of primary key?

0 Answers  

---

how to create a database in oracle?

3 Answers  

---