Thursday, April 7, 2011

How to execute a Stored Procedure?

From the SQL prompt.

echo EXECUTE [or EXEC] procedure_name;

eq execute c:\toppaidemp.sql
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Lecture PPTs of MIS , Module 4 to Module 6

 Module 4 Social Computing (SC): Web 3.0 , SC in business-shopping, Marketing, Operational and Analytic CRM, E-business and E-commerce B2B B...

  • PRACTICAL EXAM QUESTIONS
    Practical exam Q No. 1 Q-1> Write a query in sql to create a table employee and department. Employee(empno,ename,deptno,job,hiredate...
  • (no title)
    Answers Experiment No. 1 1. SQL> create table deptit(deptno number(2) primary key,dname varchar(14) not null,loc varchar(13) not null); T...
  • HPC Chapter No 4 Principles of Parallel Algorithm Design
    4.2 Decomposition Techniques As mentioned earlier, one of the fundamental steps that we need to undertake to solve a problem in parallel...