aspx Tutorial

NET Articles,jQuery demo, asp.net with jQuery, online tutorial,Jquery, SilverLight, Javascript, asp.net,JSON, MVC,.NET Articles,demo, Web Services,
Advertise Here

Toolbar

Get our toolbar!

Advertize



Posted by Aamir Hasan   on Tuesday, July 23, 2013 Total Views:  

Today, I have created a store procedure in Oracle SQL developer. This store procedure will delete employee record from employee table. Let's see

CREATE OR REPLACE PROCEDURE SP_DELETE_EMPLOYEE  

(EMP_ID Number) 
IS 
BEGIN 
  
DELETE FROM EMPLOYEE WHERE EMP_ID = EMP_ID; 
  COMMIT; 
END;

The following script delete a specific record from a employee table by providing  employee id

EXEC SP_DELETE_EMPLOYEE(1);

Tags:
Category:
Protected by Copyscape Online Plagiarism Tool

Comments (2) -

real psychics
real psychics United States
9/10/2015 10:22:29 PM #

Avoid sensation discouraged or a failure if you are nonetheless coping with financial or individual limitations. It's time to stop blaming outdoors energies or circumstances and begin taking duty for your self.

Sky Host
Sky Host Islamic Republic of Pakistan
3/1/2017 5:02:25 AM #

We offer best web hosting in Pakistan. Cheap web hosting companies in Pakistan. Sky Host – leading company provides top 10 web hosting services. Latest unlimited dedicated web hosting server plans at Sky Host.
https://www.skyhost.pk/

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Advertizement 1
Advertizement 2
Advertizement 3
Advertizement 4
Advertizement 5