HomeОбразованиеRelated VideosMore From: khaled alkhudari

033-Oracle SQL 12c: 1999 Join syntax part 2

25 ratings | 2129 views
تعلم اوراكل حتى الاحتراف تعلم اوراكل من الصفر
Html code for embedding videos on your blog
Text Comments (13)
Braday Siwar (1 year ago)
ana jarabt asta3mel two columns fil using w chaghala select e.employee_id,e.first_name,department_id, d.department_name from employees e join departments d using(department_id,manager_id) order by e.employee_id;
khaled alkhudari (1 year ago)
very good, u r right
Osama Al-Banna (1 year ago)
Dear Khalid thanks for the tutorial ...kindly do you have the sql script for this tutorial ?
Osama Al-Banna (1 year ago)
Thanks for the positive energy khalid :)
khaled alkhudari (1 year ago)
لا تحط العمر عايق ابدا....انا اغلب الي تعلمته في السنوات القليله السابقه....و عم اتعلم كل يوم اشياء جديده... بالعكس انت عندك حافز اقوى من الصغار
Osama Al-Banna (1 year ago)
Thanks anyways :)...by the way I'm 30 years old ...do you think I'm late to learn oracle and get a job require oracle skills?
khaled alkhudari (1 year ago)
طيب بسيطه انا الكورس اخد معي ٨ شهور ههههههه....اخي انا عندي اسبابي الخاصه لموضوع السكريبت لا احب الإفصاح عنها المهم وفقك الله و كله بتعبه...وراح تعرف قيمه الي انت بتعمله مع اول نجاح في الإمتحان
Osama Al-Banna (1 year ago)
will I'm writing it manually but this 19:29 min tutorial is taking me around 2:30 HR or sometimes 3:00 HR ...it become long because I'm pausing the video and writing it manually =) ...it's fine if you can't give it
Mohamed Saleh (1 year ago)
why in case of new join set prefix of department id departments but in case of old join the prefix of department_id employees ?
khaled alkhudari (1 year ago)
it is ok, it is the same , you can read the shared column form any table
Mohamed Saleh (1 year ago)
in the example of using join : when make ex for 1999 join used department.department_id but when use same ex with old way used employees.department_id what is the cause of this change? when apply this command on sql developer give the same result
khaled alkhudari (1 year ago)
i did not get you, can you tell me in that minute i mention this ???

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.