Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JSims281

    REF with user defined types - "datatype specification not allowed"

    EDIT: I want to have the CustID and AccNum as foreign keys in the customeraccount table, which gives me issues as a "column of datatype REF cannot be unique or a primary key". Or I just taking the wrong end of the stick here, then beating myself with it?
  2. JSims281

    REF with user defined types - "datatype specification not allowed"

    I'm new to oracle/sql, and I'm trying to set up a database which has a 'Customer' table, an 'Account' table and a 'CustomerAccount' table (which links the two). I've defined types for the account numbers and customer ID numbers and I'm wondering how to create the customeraccount table. This is...

Part and Inventory Search

Back
Top