Show how functions and procedures are called in a pl/sql block.

0 Answers  

---

what is the command line end user interface - mysql? : Sql dba

0 Answers  

---

how can we know the number of days between two given dates using mysql? : Sql dba

0 Answers  

---

how to give permission to users that users can update/insert/delete on a row of table on timeing 10am to 6pm only?

4 Answers   TCS,

---

Is there any problem if we use commit repeatedly after each dml statement in a plsq procedure ? (eg. there are 10 update stmt and using 10 commit stmt after each update stmt)

1 Answers  

---

Is it possible to read/write files to-and-from PL/SQL?

0 Answers  

---

Explain the concept of normalization.

3 Answers  

---

suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dpt table has a field dept id,dept name. Now I want to find out the emplyee list whose sal is between 2000-3000 from dept x.

7 Answers   Geometric Software, IBM,

---

how to return query output in html format? : Sql dba

0 Answers  

---

How can a pl sql block be executed?

0 Answers  

---

How do u count no of rows in a table?

8 Answers   CTS,

---

can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)

5 Answers  

---