Write a SQL command to perform the following operations by using this schema: BOOKS(BooklD, Book Name, Author, Publisher, ISBN); Use appropriate datatype and size for creating a table “BOOKS" Insert a new row in the BOOKS table with the values ( 101,'PIS’,’ALI’,’XYZ’,’A123’) Change the Author name ="Ali Al Farsi" for the BookID=101.

Write a SQL command to perform the following operations by using this schema: BOOKS(BooklD, Book Name, Author, Publisher, ISBN); Use appropriate datatype and size for creating a table “BOOKS" Insert a new row in the BOOKS table with the values ( 101,'PIS’,’ALI’,’XYZ’,’A123’) Change the Author name ="Ali Al Farsi" for the BookID=101.

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

Create a table in SQL developer and name it as ‘MyCrush’. The table should consists of only three attributes as follows: Crush_ID which will be the primary key with the number length of .Crush_Name with the maximum character length of 30.Crush_Description with the maximum character length of 10.Insert exactly three records with the above given attributes. Crush_ID values should be 1, 2 and 3 for the three records. Crush_Description should be ‘Present’ for record 1, ‘Past’ for record 2 and ‘Childhood’ for record 3. If you don’t have any crush from your childhood to present, you can insert some random names. Hmm.. Seems Interesting!! It’s time to implement your programming skills using PL/SQL stored procedures and functions. Create another table called ‘MyDetails’ and should contain exactly four attributes as below: Student_ID,Student_Name ,Student_Term ,Student_GPA If you are not a Master’s student, let’s assume you are a student pursuing masters and taking four semesters or terms.…
Write a SQL command please Write a query that displays the last name in uppercase letters and the length of the last name for all employees whose last name starts with the letters “J,” “A,” or “M.” Give each column an appropriate label. Sort the results by the employees’ last names.
Write a PL/SQL Programming block to do below actions 2.Before you work on Quesiton 2 , please create a table because you will be inserting numbers in thisMessages tableCREATE TABLE messages( RESULTS NUMBER)Run below query to see if there is any data :SELECT * FROM MESSAGES
1. SQL Exercise a) Write the SQL Command [//WRITE CODE HERE] name, salary, department [//WRITE CODE HERE] employees_table [//WRITE CODE HERE] start_date >= "2019-01-01"; b) The table and following SQL command will result in how many rows? Invoices Invoice_id date amount 001-8 2019-10-02 35000 001-9 2019-10-02 47000 001-10 2019-10-03 23000 001-11 2019-10-04 10000 SQL SELECT * FROM invoices WHERE invoice_id < "001-10"; a. 0 rows b. 1 row C. 2 rows d. 3 rows c) The following table and SQL command will result in how many rows? catalogs item Full_price sale_price Apple 25 NULL Pizza NULL NULL Cake 120 90 Juice 45 45 SQL SELECT * FROM catalogs WHERE sale_price IS NULL; a. 1 row b. 2 rows c. 3 rows d. 4 rows
Assume the following tables: Student (studid, email, name) Club (clubid, telephone, name, #president) MemberOf(#clubid, #studid ) Activities(actid, actdt, place) Organize (#actid , #clubid , fee), Then answer the following questions by using SQL. 1- Create a stored procedure called 'StudentsActivities' to display the list of students and the activities in which they participated. 2- Create a stored Function called 'Checkavailability' to check whether 'Salalah Hall' is busy or not in a given date. 3- Create a stored Procedure called 'CheckavailabilityProc' to call the function 'Checkavailability' and display the appropriate message according to the value returned by the function (If function returns true, the procedure will display 'Salalah Hall is free on date ######' otherwise'Salalah Hall is busy on date ###### ').
Write a PL/SQL using a cursor with Basic loop to update the Price attribute of all flight records inFlight table according to the following conditions: 1- If the FName is Oman Air, change price to 500.2-If the FName is Emirates, change price to 200.3- If the FName is Air India, change price to 250.
Information system course
Database
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
Consider the tables provided below and answer the following SQL questions: Table 1: Service SereicelD SereiceName Accounting. Security Maintenance Table 2: ServiceSetUp SereicelD SetupFee 2 3 4 100 300 350 Recurring 25 50 125 Tax 10% 11 9% Questions: Write insert statements to enter first two records into Table 1 as shown in above figure. Display a list that presents the data contained in Table 1 sorted by column 2 in descending order. Display the name of the service that has setup fee greater than $300. d. Display average of tax rates for all services.
For SQL, Modify the following select statement. Convert the datatypes of all the columns to text. (Actually, sometimes this code will work as it is and the conversion of the datatypes is done automatically for you behind the scenes.)select date_1, date_1, date_1from sec1507_firstunionselect number_2, word_2, date_2from sec1507_second;
Create a Pl SQL package named EMP_PKG which will have the above three functions and procedures as follows: CALC_TAX - private CHECK_FNAME - Public AVG_SAL - Public