User Profile

Collapse

Profile Sidebar

Collapse
nur08
nur08
Last Activity: Jul 24 '08, 01:18 PM
Joined: Jul 23 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • nur08
    replied to Drop by to ask for help
    in Oracle
    I need to know the step how to used the business rules in this code please help
    I am new to oracle...
    See more | Go to post

      Leave a comment:

    • nur08
      started a topic Drop by to ask for help
      in Oracle

      Drop by to ask for help

      /* Note: default for serveroutput is OFF.
      Therefore no 'Insert attempted' as I did not switch it on by
      set serveroutput on; */

      SQL> CREATE OR REPLACE PROCEDURE add_vacc (pat_id in char, vis_vdate in date, vis_act in number, vac
      _vacc in char)
      2 AS
      3 BEGIN
      4 insert into vaccinations(pi d,vdate,action, vaccinated) values(pat_id,v is_vdate,vis_ac t,vac_vacc)
      ;
      5 DBMS_OUTPUT.PUT _LINE...
      See more | Go to post
      No activity results to display
      Show More
      Working...