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: bank management system project in sql, attendance management system format using sql, attendance management system sql, pl sql project on student management, macauthevent en0 auth, medical management porject using vb and sql, hospital management system sql code,

[-]
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,450 25-12-2018, 08:03 PM
Last Post: Selva lakshmi
  dfd for alumni management system 1 2,830 23-09-2018, 12:00 PM
Last Post: Guest
  program code of solar tracking system using 8051 microcontroller 6 23,343 03-05-2018, 09:30 PM
Last Post: Guest
  ice cream parlour management system in vb source code 4 5,290 04-04-2018, 11:58 PM
Last Post: vprk77
  online shopping management system project pdf 1 3,874 14-02-2018, 02:55 PM
Last Post: jai kumar maurya
  source code for hospital management system in jsp 4 1,951 13-01-2018, 10:51 AM
Last Post: dhanabhagya
  synopsis of project gas agency management system 5 3,291 08-01-2018, 06:15 AM
Last Post: Guest
Thumbs Up online hospital management system in jsp servlet free download 2 5,301 07-01-2018, 09:32 AM
Last Post: RaymondGom
  synopsis for jewellery shop management system 3 11,349 07-01-2018, 08:07 AM
Last Post: RaymondGom
Wink temple management system soure code 3 1,506 16-11-2017, 09:26 AM
Last Post: jaseela123d

Forum Jump: