DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: stored procedure

  1. #1
    Join Date
    May 2001
    Location
    london,england
    Posts
    10

    Unhappy

    hi,
    I need to write stored procedure for some queries,such as "select" and "insert" , I am not very confident with pl/sql at the moment as I have only just started this job. Can anyone help please.

    thanks
    R
    roli

  2. #2
    Join Date
    Jun 2001
    Posts
    3

    check this

    check this may this will help u.


    create or replace procedure a
    as
    date1 date;
    begin
    select sysdate into date1 from dual;
    if (date1= '12-jun-01') then
    insert into table values('s');
    end if;
    end;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width