Answer / Ghanistha Kumar Maury

A PL/SQL table is a programmable, temporary in-memory table created by the DECLARE TABLE command. It does not reside on disk and gets destroyed when the program ends. It is used to store and manipulate data during the execution of a PL/SQL block or procedure. Its main advantage is that it allows the creation of complex data structures that can be easily manipulated without requiring DDL commands.

consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ename who having maximum salary in deptno 10 and 20.

24 Answers   Mind Tree,

---

What is varchar example?

1 Answers  

---

Explian rowid, rownum?

1 Answers  

---

what is data integrity? : Sql dba

1 Answers  

---

What are the types of variable use in pl sql?

1 Answers  

---

Can we call procedure in select statement?

1 Answers  

---

What are tables and fields?

1 Answers  

---

how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c

8 Answers   Oracle,

---

Which data type is a composite type?

1 Answers  

---

What is the difference between local and global temporary table?

1 Answers  

---

What do you mean by rowid?

1 Answers  

---

Which data dictionary views have the information on the triggers that are available in the database?

1 Answers  

---