Results 1 to 2 of 2

Thread: SQLPLUS Query

  1. #1
    Join Date
    Nov 2005

    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

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

    ORDERLINE table with

Posting Permissions

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