Browsing category Oracle Database

Solutions 6: Oracle Database Fundamental I


Oracle Database Fundamental I  Practice 6 Solutions                   1.      The HR department needs a query that prompts the user for an employee last name. The query then displays the last name and hire date of any employee in the same department as the employee whose name they supply (excluding that employee). For example, if the

Solutions 2: Oracle Database Fundamental I


Oracle Database Fundamental I  Practice 2 Solutions                   1.      Due to budget issues, the HR department needs a report that displays the last name and salary of employees who earn more than $12,000. Place your SQL statement in a text file named lab_02_01.sql. Run your query. Solution: select last_name, salary from employees where salary >

Solutions 1: Oracle Database Fundamental I


Oracle Database Fundamental I  Practice 1 Solutions           (Questions 1 to 5 just true and false, So try itself)                 6.Your first task is to determine the structure of the DEPARTMENTS table and its contents.             Solutions: Structure- desc departments;      Contents– select * from departments;          7.      You need to determine the structure of

1 4 5 6

Follow Me

Oracle Certification