why we go for package? what are the advantages of using instead of seperate procuderes or functions

3 Answers   IBM, TCS,

---

what is the cursor and use of cursor in pl/sql ?

4 Answers  

---

Give the structure of the procedure ?

1 Answers  

---

what is autonomouse transaction?

3 Answers   Oracle,

---

How does join work in sql?

0 Answers  

---

when a procedure /package is getting invalidated?

4 Answers   TCS,

---

need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

2 Answers  

---

Is pl sql a programming language?

0 Answers  

---

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

0 Answers  

---

What is the use of triggers?

0 Answers  

---

write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

2 Answers   iFlex,

---

What is the maximum database size for sql express?

0 Answers  

---