Answer / abhisekh

we can call a procedure using 2 ways
1.using exec <procedure>
2.using anonymous block< begin <procedure> end;
now coming to ur questions answer. crate a anonymous block and add the statements u wanted to execute first then call the procedure.

Explain what is a database?

0 Answers  

---

what are the authentication modes in sql server? : Sql dba

0 Answers  

---

How to convert ms-excel file to oracle table?

2 Answers  

---

Mention what is the use of function "module procedure" in pl/sql?

0 Answers  

---

Is grant a ddl statement?

0 Answers  

---

---

how to get help information from the server? : Sql dba

0 Answers  

---

Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --

5 Answers  

---

What is spool?

0 Answers  

---

7. Where would you look for errors from the database design?

1 Answers   Fintellix,

---

What is the maximum number of triggers, you can apply on a single table?

0 Answers  

---

what does the t-sql command ident_incr does? : Transact sql

0 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,

---