display records from 5 to 9 using rowid or rownum

5 Answers   Agile Software,

---

What are predefined functions in sql?

0 Answers  

---

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

0 Answers   CTS,

---

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

0 Answers  

---

what are different types of keys in sql?

0 Answers  

---

Mention what does the hierarchical profiler does?

0 Answers  

---

How sql query is executed?

0 Answers  

---

what is oracle sql,pl/sql with interfaces

2 Answers   TCS,

---

What are types of joins?

0 Answers  

---

What are sql constraints?

0 Answers  

---

how can we know the count/number of elements of an array? : Sql dba

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  

---