Answer Posted / shailendra chauhan

For the strong ref cursor the returning columns with
datatype and length need to be known at compile time.

For the weak ref cursor the structure does not need to be
known at compile time.

TYPE WEAK_REF_CURSOR IS REF CURSOR;

TYPE STRONG-_ REF_CURSOR IS REF CURSOR RETURN
TABLE_NAME%ROWTYPE;

What is the starting oracle error number? What is meant by forward declaration in functions?

994

---

explain advantages of innodb over myisam. : Sql dba

1130

---

What is the difference between the conventional and direct path loads? : aql loader

1400

---

Why is sql better than hql?

993

---

How do I truncate a sql log file?

1075

---

How do I run a pl sql procedure in sql developer?

970

---

Is left join same as join?

997

---

Explain the order of sql statement execution?

1046

---

Does sql backup shrink transaction log?

980

---

Explain the difference between 'between' & 'and' operators in sql

1002

---

Write a query to find the names of users that begin with "um" in sql?

997

---

How do you write a subquery?

1029

---

What do you mean by dbms? What are its different types?

1018

---

What does pl sql developer do?

932

---

Write a sql query to convert all character to uppercase after hypen.

1439

---