Hello Reshak, Thanks for your valuable feedback.It will boost us to do new things. Please subscribe to get updates about new videos. You can view all other Oracle Videos in the following link: Oracle11g by Dinesh goo.gl/bJDrzd Oracle 11g by Srikanth goo.gl/vezMqz Oracle 11g by Siva goo.gl/jpSqMr Oracle 11g/12c By Expert Faculty ru-vid.com_all_playlists?sq=oracle Oracle 12c by Basha goo.gl/F26d6R
sir how would we know that a particular column is pkey or fkey before apply equi join we have to know which column is pkey or fkey by using user_contraints??
join works not only with primary key and foreign key , any two columns that has same data type can be joined even if they have different names but only under ON , USING has to be same name , and natural join too.