User Profile

Collapse

Profile Sidebar

Collapse
antpal
antpal
Last Activity: Sep 13 '07, 12:04 AM
Joined: Aug 18 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • antpal
    replied to constraint error when creating table relationships
    in Oracle
    Nevermind I just figured it out I had a mispelling on references and also a duplicate FOREIGN KEY CONSTRAINT NAME.

    Thanks Anyways
    See more | Go to post

      Leave a comment:

    • antpal
      replied to constraint error when creating table relationships
      in Oracle
      Hi I fixed some code and rearranged my tables to the following:
      --Create All Tables

      CREATE TABLE authors (
      auth_id NUMBER(7) PRIMARY KEY,
      f_name VARCHAR2(30),
      l_name VARCHAR2(50),
      auth_specialty VARCHAR2(30)
      );


      CREATE TABLE books (
      isbn CHAR (10) PRIMARY KEY,
      title VARCHAR2 (50),
      qty_owned NUMBER(3),
      qty_on_hand NUMBER(3),
      cost NUMBER,...
      See more | Go to post

        Leave a comment:

      • antpal
        started a topic constraint error when creating table relationships
        in Oracle

        constraint error when creating table relationships

        I am not sure exactly what i am doing run but when I run this code in sql plus i get constraint error on most of my tables except author and books table. Please help I am new to Programming in PL/SQL.



        --Create All Tables

        CREATE TABLE authors (
        auth_id NUMBER(7),
        f_name VARCHAR2(30),
        l_name VARCHAR2(50),
        auth_specialty VARCHAR2(30),
        CONSTRAINT auth_id_pk PRIMARY KEY(auth_id)...
        See more | Go to post
        No activity results to display
        Show More
        Working...