library management system using pl sql
#1

hello sir,
my name is sachin. i'm new in pl sql and i have no idea how to make projects in it.
can you give me this project so i can understand how to make project.
Reply
#2
library management system using pl sql

declare



bknam char(15);

auth char(15);

tot number(5);

id number(5);

no number(5);

i number(3);



begin



bknam:='&bknam';

auth:='&auth';

tot:=&tot;



insert into book_rec values(bknam,auth,tot,tot);





for i in 1..tot

loop

select MAX(book_id) into no from book_details;



if no is not null then

id:=no+1;

else

id:=1;

end if;



insert into book_details values(id,bknam,null);



end loop;



end;

/





Enter value for bknam: DCD

old 9: bknam:='&bknam';

new 9: bknam:='DCD';

Enter value for auth: Mano

old 10: auth:='&auth';

new 10: auth:='Mano';

Enter value for tot: 3

old 11: tot:=&tot;

new 11: tot:=3;



PL/SQL procedure successfully completed.



SQL> /

Enter value for bknam: OS

old 9: bknam:='&bknam';

new 9: bknam:='OS';

Enter value for auth: Silber

old 10: auth:='&auth';

new 10: auth:='Silber';

Enter value for tot: 2

old 11: tot:=&tot;

new 11: tot:=2;



PL/SQL procedure successfully completed.
Reply

Important Note..!

If you are not satisfied with above reply ,..Please

ASK HERE

So that we will collect data for you and will made reply to the request....OR try below "QUICK REPLY" box to add a reply to this page
Popular Searches: book bank management system using vb with sql source code, transport management system in vb sql, html sql library management system, hospital management system sql code, bank management system project in sql, project report on marraige hall management system using sql vb, student management system project pl sql,

[-]
Quick Reply
Message
Type your reply to this message here.

Image Verification
Please enter the text contained within the image into the text box below it. This process is used to prevent automated spam bots.
Image Verification
(case insensitive)

Possibly Related Threads...
Thread Author Replies Views Last Post
  srs on textile management system 2 2,416 25-12-2018, 08:03 PM
Last Post: Selva lakshmi
  dfd for alumni management system 1 2,814 23-09-2018, 12:00 PM
Last Post: Guest
  program code of solar tracking system using 8051 microcontroller 6 23,198 03-05-2018, 09:30 PM
Last Post: Guest
  ice cream parlour management system in vb source code 4 5,272 04-04-2018, 11:58 PM
Last Post: vprk77
  online shopping management system project pdf 1 3,841 14-02-2018, 02:55 PM
Last Post: jai kumar maurya
  source code for hospital management system in jsp 4 1,945 13-01-2018, 10:51 AM
Last Post: dhanabhagya
  synopsis of project gas agency management system 5 3,267 08-01-2018, 06:15 AM
Last Post: Guest
Thumbs Up online hospital management system in jsp servlet free download 2 5,289 07-01-2018, 09:32 AM
Last Post: RaymondGom
  synopsis for jewellery shop management system 3 11,341 07-01-2018, 08:07 AM
Last Post: RaymondGom
Wink temple management system soure code 3 1,494 16-11-2017, 09:26 AM
Last Post: jaseela123d

Forum Jump: