Results 1 to 2 of 2

Thread: SQLPLUS Query

  1. #1
    Join Date
    Nov 2005
    Posts
    13

    Talking Unanswered: SQLPLUS Query

    Hey Guys,

    I am making a library system using SQLPLUS in oracle.

    I have to have a SQL query to ensure... members cannot take out more than 6 books at a time from each library.

    Members can register at more than one library at a time. They have a unique ID at each different library.

    I have a Rentals table with:

    rentalNo - primary
    *memberID - foreign
    bookISBN - foregn

    Any help greatly appreciated
    Many Thanks
    BB.

  2. #2
    Join Date
    Nov 2005
    Posts
    13
    forgot to mention I also have a

    ORDERLINE table with
    *rentalNo
    *DVDNo

Posting Permissions

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