Bartleby Sitemap - Textbook Solutions
All Textbook Solutions for Oracle 12c: SQL
10MC11MC12MC13MC14MC15MC16MC17MC18MC19MC20MC1HOA2HOA3HOA4HOA5HOA6HOA7HOADisplay the book title and category for all books in the Children and Cooking categories. Create three different queries to accomplish this task: a) a search pattern operation, b) a logical operator, and c) another operator not used in a or b.9HOA10HOA1RQ2RQ3RQ4RQ5RQ6RQ7RQ8RQ9RQ10RQ1MC2MC3MC4MC5MC6MC7MC8MC9MC10MC11MC12MC13MC14MC15MC16MC17MC18MC19MC20MC1HOA2HOA3HOA4HOA5HOA6HOA7HOA8HOA9HOAAn EMPLOYEES table was added to the JustLee Books database to track employee information. Display a list of each employee’s name, job title, and manager’s name. Use column aliases to clearly identify employee and manager name values. Include all employees in the list and sort by manager name.
1RQ2RQ3RQ4RQ5RQ6RQ7RQ8RQ9RQ10RQ1MC2MC3MC4MC5MC6MC7MC8MC9MC10MC11MC12MC13MC14MC15MC16MC17MC18MC19MC20MC1HOACreate a list of all customer numbers along with text indicating whether the customer has been referred by another customer. Display the text “NOT REFERRED” if the customer wasn’t referred to JustLee Books by another customer or “REFERRED” if the customer was referred.
3HOA4HOA5HOA6HOA7HOA8HOA9HOAProduce a list of each customer number and the third and fourth digits of his or her zip code. The query should also display the position of the first occurrence of a 3 in the customer number, if it exists.
1RQ2RQ3RQ4RQ5RQ6RQ7RQ8RQ9RQ10RQ1MC2MC3MC4MC5MC6MC7MC8MC9MC10MC11MC12MC13MC14MC15MC16MC17MC18MC19MC20MC1HOA2HOA3HOA4HOA5HOA6HOA7HOA8HOA9HOA10HOA1RQ2RQ3RQ4RQ5RQ6RQ7RQ8RQ9RQ10RQ1MC2MC3MC4MC5MC6MC7MC8MC9MC10MC11MC12MC13MC14MC15MC16MC17MC18MC19MC20MC1HOA2HOA3HOA4HOA5HOA6HOA7HOA8HOA9HOA10HOA1RQ2RQ3RQ4RQ5RQ6RQ7RQ8RQ9RQ10RQ1MC2MC3MC4MC5MC6MC7MC8MC9MC10MC11MC12MC13MC14MC15MC16MC17MC18MC19MC20MC1HOAChange the CONTACT view so that no users can accidentally perform DML operations on the view.
Create a view called HOMEWORK13 that includes the columns named Col1 and Col2 from the FIRSTATTEMPT table. Make sure the view is created even if the FIRSTATTEMPT table doesn’t exist.
Attempt to view the structure of the HOMEWORK13 view.
Create a view that lists the ISBN and title for each book in inventory along with the name and phone number of the person to contact if the book needs to be reordered. Name the view REORDERINFO.
6HOA7HOA8HOA9HOA10HOA