Oracle SQL Tutorial 18 - How to Create Foreign Keys

Поделиться
HTML-код
  • Опубликовано: 8 ноя 2024

Комментарии • 26

  • @jegramat
    @jegramat Месяц назад

    This has been super helpful. It allowed me to revisit all that I learned throughout the semester but at a faster pace. The lessons are concise and direct to the point.

  • @texast4076
    @texast4076 2 года назад +1

    Hi! Love your work, keep it up. Learn so much.
    In your video here (Around 5:06ish) you show an issue where the projects table referenced the users table, and the switch is to just switch them around
    Could you help me understand how to recognize the situation there? I'm new and that seems like a valuable piece of wisdom from experience 🙂

  • @Marc_Masters
    @Marc_Masters 4 года назад +1

    Thank You Caleb for these videos!

  • @darlinmanuelcasadoperez1092
    @darlinmanuelcasadoperez1092 3 года назад

    thanks for the vid Caleb, it was very helpful with my school project.

  • @sebon11
    @sebon11 4 года назад

    Ur teaching style is great

  • @michaelb1099
    @michaelb1099 7 лет назад

    This whole series is fantastic and very thoro Caleb I think you have it down so Thank you and i hope you will be making more tutorials
    the best part is you are clear and concise.

  • @techmanbhatinc.1075
    @techmanbhatinc.1075 3 года назад

    thanks Caleb. what will be the query if i want to retrieve all indexed foreign keys in my db. ?

  • @shanebagel
    @shanebagel 4 года назад

    Caleb you are a damn legend mate

  • @vaiebhavpatil2340
    @vaiebhavpatil2340 3 года назад

    nicely explained! thanks for this

  • @gojamoja6719
    @gojamoja6719 4 года назад

    Great work u saved me hours of work

  • @robb3200
    @robb3200 5 лет назад

    Cheers Caleb, you the man.

  • @Randomness960TVX
    @Randomness960TVX 4 года назад

    After i added foreign key in there column i have null values. What can i do?

  • @migueleduardosanmartinsuar5719
    @migueleduardosanmartinsuar5719 7 лет назад

    I still have doubts with the DROP thing... could you reference me to the Oracle SQL Tutorial in which you explain about that? im kinda lost...

  • @daniellaj2906
    @daniellaj2906 8 лет назад +1

    Awesome tutorial.much appreciated

  • @suhail_8692
    @suhail_8692 3 года назад

    Helping a lot
    THANK U :)

  • @minhajali3671
    @minhajali3671 2 года назад

    Many thanks.

  • @truonghieu7329
    @truonghieu7329 6 лет назад +1

    Thk from VietNam
    much help!!!

  • @luccasvergueiro498
    @luccasvergueiro498 2 года назад

    Thanks!

  • @csandreas1
    @csandreas1 5 лет назад

    Make a course on Udemy for Oracle Sql Developer

  • @Karolm-eb9nh
    @Karolm-eb9nh 7 лет назад

    hey how are you? can you help me out?
    im typing down the same code as u are but here its showing up the error 00904 000 - %s: invalid identifier.
    what should it be?

    • @daveiooo
      @daveiooo 7 лет назад

      There must be some slight difference in your code and his. I had the same problem, but then copied his code in the description and everything worked. My problem turned out to be typing:
      CONSTRAINT project_pk PRIMARY KEY(projects_id)
      instead of:
      CONSTRAINT project_pk PRIMARY KEY(project_id)
      Facepalm

  • @dailylifeSmile
    @dailylifeSmile 8 лет назад

    I'want to make Data base of Store.that containing spare parts and tools that is use ,we should add or remove parts.. parts is specify with part no. serial no. and manufacture date and expiry date. will you please help me with some video, i m new learner im watching your videos its nice,thanks for all that videos.Stay Blessed!

  • @maurobertozzi7271
    @maurobertozzi7271 8 лет назад +9

    cancer

  • @syediftekharuddin3769
    @syediftekharuddin3769 7 лет назад

    getting
    Error report -
    SQL Error: ORA-00905: missing keyword
    00905. 00000 - "missing keyword"
    *Cause:
    *Action:
    please heip