لدي اساله لأوراكل هلا ساعدتمووووووني على حلها واكون شاكر لكم جزيل الشكر ..
1- Write a query to display the name,department number,and department names for all employees .
2-Create a unique listing of all jobs that are in department 30.Include the location of department 30 in the output .
3- write a query to display the employee name,department name ,and location of all employees who earn a commission.
4- Display the employee name and department name for all employees who have an A in their name.
5- Write a query to display the name,job,department number,and department name for all employees who work in DALLAS.
6- Show the structure of the SALGRADE table,Create a query that will display the name,job,department name,salary,and grade for all employees.
تم التعديل بواسطة ad-20-ad, 28 November 2007 - 05:07 PM.