Answer Posted / hai

select * from table_name where rownum<2;

What is function and procedure?

569

---

Which is faster union or join?

495

---

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

486

---

1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

1917

---

Explain the structure of pl/sql in brief.

623

---

---

Is sql similar to python?

538

---

Is left join same as inner join?

542

---

What is pl/sql table? Why is it used?

562

---

Is a view faster than a stored procedure?

549

---

How do I truncate a word?

529

---

What is embedded sql in db2?

507

---

What is the usage of distinct keyword?

634

---

What does the base_object_type column shows in the user.triggers data dictionary view?

576

---

What does cursor do in sql?

520

---

How to avoid using cursors?

599

---