Answer Posted / bhaskar

Hi,
It is the part of memory used by a singe process or thread.
Each oracle background process have PGA area.and is not
sharable.it get allocated when the process starts and gets
deallocated on completion of the process by oracle server.

It contains short area,session specific information,user
previliges,cursor state etc.It is writable only by the
server process.

Thanks-Bhaskar Gouda

What is a trigger oracle?

565

---

Is oracle a language?

528

---

How can I see all tables in oracle?

547

---

How to execute the package in oracle?

574

---

What is a snapshot in oracle database?

583

---

---

What is the max number of columns in an oracle table?

518

---

Explain what are the type of synonyms?

582

---

> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

1573

---

How to assign data of the deleted row to variables?

583

---

Compare and contrast between sql and sql server and explain its various functions?

540

---

State any two functions of oracle?

638

---

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

1622

---

What is a tns service name?

536

---

What is execute immediate in oracle?

549

---

What do you mean by redo log file mirroring?

561

---