Before jumping over my next tutorial I'll suggest you all to watch my Foreign key tutorial. It will help you to understand the concepts more clearly.#SQL #SQLDeveloper #OracleDatabase
You are an awesome Teacher! A lot of things that I never understood, it took me only 10 Min. with you and now I have understand everything! Thanks a lot Bro! Do not stop teaching the World how to do this! =) Saludos!
Hi..Iam Gayatri.Just now i have watched ur video on primary key,foreign key.Your explanation is so good.. nice and perfect lecture.I think it will help me alot .Thank u so much...
Gayatri miriyala Thanks, glad you enjoyed my videos. Please like and share the videos on your social networks and help other in learning the concepts oracle database in free.
You got an amazing talent of teaching others , keep on doing this sacred work Dear.... The thing is that I followed your tutorial for installing the oracle 11g complete setup all was well but in the end whenever I login into my Enterprise Manager account it says something like this(INTERNAL ERROR HAS OCCOURED AND DO SOMETHING WITH YOUR LOG FILES)... please tell me I am desperate to see the dashboard of EM opening on my screen.... With Love from PAKISTAN
Hi Manish, your videos r the best,really i feel so comfortable with oracle sql now Can u plz make video on new features of 12c, i have my interviews in coming weeks ,it would be of great hlp .
God I try to make a reference between 2 tables 2 columns for 2 days and I couldn't do it.... I hate your accent but sir.... you are a GREAT TEACHER, thank you in my country they say > Hope you reach 100 y old! or more ... have a great day
Mr Sharma, I like your videos. I'm using ORACLE SQL 11G express and I have one request? would you continue on with your (this) video and make a video with real database tables to show how FOREIGN KEY work with real data??? thank you in advance!
hi sir, your lectures very informative for me meny 2 table create kiye hain or aik new 3rd table create kr k just usme un dono tables ki primary keys as a foreign keys lgani hai kya ap mjhe 3rd tables ka syntax send kr de gy yahan please
I know how to define a foreign key - there's a lot of information about this on the Internet. But I do not quite understand the details of how the foreign key is used. THAT would be a very valuable information in your tutorial
+Anatolii Stepaniuk. Imagine you are an IT guy in a company. IT department has ID 5. This means that in "Employees" table there would be "Anatolii" with department_ID=5. Now I go to the separate "Departments" Table and try to delete the department with ID 5. If there is NO Foreign Key, I will successfully delete the department, and "Anatolii" will end up with NO department assinged. And that's bad :). Hope this helped.
Dear Manish, If I have to create more than one primary key, I have to use composite Primary key. Fine. When I try to keep one of this Primary key to my foreign key error is raised . can you give your reply please
I have a question. What if I have table A, table B and table C. Let's say table C is linked with both table A and B. How would I define foreign keys in table C? Could I add two constrains for each reference? Thanks. :)
Foreign key is a referential integrity constraint which helps in several manners like establishing a relationship (link) between parent and child table which you can then use in several ways for example, Joins is one of them. Uses of FK constraint include: · 1. It forestalls those actions that can lead to destruction of links between various tables. 2. It ensures that the data that is being inserted in the foreign key column is essentially coming from the table it points to. This guarantees the validity of the data. Incidentally Primary key has the job of identifying each row uniquely in a table. You can go through these links for more knowledge on Primary and Foreign key. bit.ly/primary-key bit.ly/foreign-key thanks
In almost all the videos I have used Oracle SQL Developer a free GUI by Oracle Itself. I have done an installation video of the same, here is the link ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-zliF8kXVmeE.html