with the screenshots of your results ExerciseUse SQL and run on Oracle:1. Use exists operator and find all clients that have not viewedproperty for rent number 'PA14'.2. Insert these three records into the staff table:('SG15', 'Yusuf', 'Kareem', 'Assistant', 'M', '1970-06-20', 9300, 'B003')('SG16', 'Aishah', 'Ahmad', 'Manager', null, null, null, 'BO03')('SG17', 'Ibrahim', 'Zeki', 'B003') Exercise (cont'd)Use SQL and run on Oracle:3. Increase the rent for all flats in Glasgow by 15%.|4. Tina Murphy had just sold all her properties to Carol Farrel.Update the correct records to reflect the transfer of ownershipfrom Tina to Carol.5. Delete the branch office in '163 Main St' from the Databaserecord.

Answer: Assume client and property table SELECT clients_name FROM client _table WHERE EXISTS…

Ise SQL and run on Oracle: . Use exists operator and find all clients that have not viewed property for rent number 'PA14'. . Insert these three records into the staff table: SG15', 'Yusuf', 'Kareem', 'Assistant', 'M’, '1970-06-20', 9300, 'B0 SG16', 'Aishah', 'Ahmad', 'Manager', null, null, null, 'BO03') "SG17', 'Ibrahim', 'Zeki', 'B003')

Ise SQL and run on Oracle: . Use exists operator and find all clients that have not viewed property for rent number 'PA14'. . Insert these three records into the staff table: SG15', 'Yusuf', 'Kareem', 'Assistant', 'M’, '1970-06-20', 9300, 'B0 SG16', 'Aishah', 'Ahmad', 'Manager', null, null, null, 'BO03') "SG17', 'Ibrahim', 'Zeki', 'B003')

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

In the SQL Oracle Application Write one query to return the employee_id, job_id, hire_date, and department_id of all employees and a second query listing employee_id, job_id, start_date, and department_id from the job_history table and combine the results as one single output. Make sure you suppress duplicates in the output.
This needs to be written in Oracle ( In PL/SQL)
Write the appropriate SQL query for each of the following questions: Display the list of students who are involved in the IT club Display the details of all the activities that have taken place in 'Salalah Hall'
In Oracle database, if we have any field such as Job_Title field in any of our table then we can use DECODE function to sort the result based on our own numerical value. This can be done by including the following in ORDER BY clause: 1: ORDER BY DECODE(job-title,'Manager',3,Assistant',2,'Sales Rep', 1) DESC II: ORDER BY DECODE(job-title,'Manager', 3,'Assistant',2, Sales Rep', 1) ASC III I and II are correct IV I and II are incorrect ||| IV || 1
Write a PL/SQL block that will allow the user to enter FNo and that will display Customer Name from Booking table. Include predefined exception with suitable messages1- SQL returns more than one records2- Records are not available
Use FOR loop for your cursor. Write a PL/SQL block to read and display the department name and number of employees per department. Accept input from the user to get the number of employees he wants to see in the output. Display also the number of records returned by your PL/SQL block.
In Sql These are some database from a set of tables insert into AccountHolder(AccountID, CustomerID, AccountType)values (55003, 115, 'Savings'),(44001, 101, 'Chequing'),(55006, 109, 'Savings'),(44002, 102, 'Chequing'),(44003, 113, 'Chequing'),(55007, 108, 'Savings'),(44004, 103, 'Chequing'),(44005, 110, 'Chequing'),(55005, 112, 'Savings'),(44006, 114, 'Chequing'),(55001, 111, 'Savings'),(44007, 107, 'Chequing'),(44008, 104, 'Chequing'),(55004, 106, 'Savings'),(44009, 105, 'Chequing'),(44010, 113, 'Chequing'),(55002, 107, 'Savings'),(44011, 110, 'Chequing'),(44012, 104, 'Chequing') select * from AccountHolder insert into Branch(LocationID, BranchName, Address, Type, DepositSum, LoanSum)values (1, 'Boulevard Branch', '3268 Wade Boulevard', 'Rural', 171848.88, 37681.72),(2, 'Avenue Branch', '4814 Dare Avenue', 'Rural', 232707.42, 68324.56),(3, 'Street Branch', '208 Ferry Street', 'Commercial', 375010.75, 44665.08),(4, 'Road Branch', '468 Zulauf Road', 'Commercial', 496001.41,…
Instructor(Instructor_Id, Instructor_Name, specialization, Address,#Department_Id)Department(Department_Id, Department_Name)Course(Course_code, Course_Title,Credit_hours,Contact_hours,#Department_Id)Teaching(#Instructor_Id, #Course_code)a) Express in SQL the following queries:i. Change to 6 the number of contact hours of the course which has thecode “ITDR2104”.ii. Add a new column named instructorLoad of type Number(2) to thetable instructor.iii. List the details of all the courses having a code that starts with“ITDR”. The output should be sorted in descending order by credithours.iv. Find the number of courses taught by the instructor whose name is“Ahmed”.v. List the names of all departments along with the number of coursesoffered by each department.vi. Find the titles of courses, which are taught by the instructor who isnamed “Ahmed”.b) Create a view named instructor_of_DBCourse to contain the details(Instructor_Name, specialization, Address, Department_Id) ofinstructors who teach…
In Oracle database, If ORDER_DATE field exist in any of our tables, then we can include the following in our WHERE clause: I: to_char(order_date, 'Mon yyyy')='Feb 2001' to_char(order_date, II: 'mon yyyy')='FEB 2001' I & II: are correct I & II: are not correct 1 I & II: are not correct I & II: are correct Oll
Use FOR loop for your cursor. Write a PL/SQL block to read and display the job_id and number of employees per job_id. Accept input from the user to get the number of employees he wants to see in the output. Display also the number of records returned by your PL/SQL block.
Fill the blanks with the suitable PL/SQL statements that correct each of the errors that appear in the given PL/SQL program. declare vAddress employee.Address%VR0WTYPE; begin select ename , address into vAddress from employee where salary = 1500; DBMS_OUTPUT.PUT_LINE('NOM =' || vEname || 'Adresse=' || vAddress ); exception when MANYROWS then dbms_output.put_line("This query returned many rows"); end;
Views in SQL are kind of virtual tables. A view also has rows and columns as they are in a real table in the database. We can create a view by selecting fields from one or more tables present in the database. A View can either have all the rows of a table or specific rows based on certain conditions. Under what circumstances would you create a View?