Explanation of Solution
Display letters in uppercase in Oracle, Access, and SQL Server:
Display letters in uppercase using Oracle:
- User can display the letters in uppercase using “UPPER” function.
- Syntax for “UPPER” function:
UPPER(text)
- From the above syntax, “text” specifies any text or any column name from specific table.
Example:
The example for “UPPER” function is given below:
SELECT * FROM STUDENT_ID, UPPER(STUDENT_NAME) FROM STUDENT;
The above query is used to display student ID and student name with uppercase letters from “STUDENT” table.
- Using “UPPER” function, user can change the every student name to uppercase letters.
Display letters in uppercase using Access:
- User can display the letters in uppercase using “UCASE” function.
- Syntax for “UCASE” function:
UCASE(text)
- From the above syntax, “text” specifies any text or any column name from specific table.
Example:
The example for “UCASE” function is given below:
SELECT * FROM STUDENT_ID, UCASE(STUDENT_NAME) FROM STUDENT;
The above query is used to display student ID and student name with uppercase letters from “STUDENT” table.
- Using “UCASE” function, user can change the every student name to uppercase letters.
Display letters in uppercase using SQL Server:
The SQL Server also uses “UPPER” function to display letters in uppercase. For SQL Server, same procedure as Oracle.
Explanation of Solution
Display letters in lowercase using Oracle:
- User can display the letters in lowercase using “LOWER” function.
- Syntax for “LOWER” function:
LOWER(text)
- From the above syntax, “text” specifies any text or any column name from specific table.
Example:
The example for “LOWER” function is given below:
SELECT * FROM STUDENT_ID, LOWER(STUDENT_NAME) FROM STUDENT;
The above query is used to display student ID and student name with uppercase letters from “STUDENT” table.
- Using “LOWER” function, user can change the every student name to lowercase letters.
Display letters in lowercase using Access:
- User can display the letters in uppercase using “LCASE” function.
- Syntax for “LCASE” function:
LCASE(text)
- From the above syntax, “text” specifies any text or any column name from specific table.
Example:
The example for “LCASE” function is given below:
SELECT * FROM STUDENT_ID, LCASE(STUDENT_NAME) FROM STUDENT;
The above query is used to display student ID and student name with lowercase letters from “STUDENT” table.
- Using “LCASE” function, user can change the every student name to uppercase letters.
Display letters in lowercase using SQL Server:
The SQL Server also uses “LOWER” function to display letters in lowercase. For SQL Server, same procedure as Oracle.
Want to see more full solutions like this?
Chapter 8 Solutions
A Guide to SQL
- SQL includes many numerical functions. Two of these functions are FLOOR and CEIL. Use the Internet to research these functions. Are the functions available in Oracle, SQLServer, and Access? Write a paragraph that discusses what the functions do and anydifferences and/or similarities between the functions in Oracle, SQL Server, and Access.Then perform the following tasks: a. Solmaris Condominium Group would like to know the impact of discounting its condofees by 3 percent. Write an SQL statement in Oracle that displays the condo ID, unitnumber, discounted condo fee, discounted condo fee with the CEIL function, anddiscounted condo fee with the FLOOR function. b. Based on your research, will the values in the three columns vary? If so, how? Usethe condo with the ID of 1 to explain your answer. Be sure to cite your references.arrow_forwardI need the answer as soon as possiblearrow_forwardPlease answer as many questions as you can!arrow_forward
- 6. What are different JOINS used in SQL?arrow_forward6. How long was the longest delay before departure? Options: 1355 min 999 min 1099 min 588 min I need to write a code to determine the longest delay before departure? from the above database for sqlarrow_forwardWhat is the difference between SUBSTR and CHARINDEX in the SQL Server?arrow_forward
- Please help with the following: Using oracle sql live or sql developer what sql statements could be use to find the following: A simple database composed of the following tables: PATIENT, DOCTOR, DRUG, and PRESCRIPTION. Please explore the database and then write the appropriate SQL command. List doctor’s details where speciality is either Dermatology or Neurology. (Use INoperator). List the results by the first name in ascending order and the last name indescending order. Find all patients rows whose first names include ‘George’ (Assume case sensitivity). sql doc below Beginfor c in (select table_name from user_tables) loopexecute immediate ('drop table '||c.table_name||' cascade constraints');end loop;End;//* */ ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY';CREATE TABLE DOCTOR (DOC_ID varchar2(5) PRIMARY KEY,DOC_LNAME varchar2(15),DOC_FNAME varchar2(15),DOC_INITIAL varchar2(1),DOC_SPECIALTY varchar2(15));INSERT INTO DOCTOR…arrow_forwardSELECT, FROM, and WHERE statements. What happens if we do not report the attributes exactly as they are in MS SQL Server? How do we resolve the issues?arrow_forwardPlease help with the following: Using oracle sql live or sql developer what sql statements could be use to find the following: A simple database composed of the following tables: PATIENT, DOCTOR, DRUG, and PRESCRIPTION, is now loaded with this assignment and you are ready to start. Please explore the database and then write the appropriate SQL command. List doctor’s details where speciality is either Dermatology or Neurology. (Use INoperator). List the results by the first name in ascending order and the last name indescending order sql doc below Beginfor c in (select table_name from user_tables) loopexecute immediate ('drop table '||c.table_name||' cascade constraints');end loop;End;//* */ ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY';CREATE TABLE DOCTOR (DOC_ID varchar2(5) PRIMARY KEY,DOC_LNAME varchar2(15),DOC_FNAME varchar2(15),DOC_INITIAL varchar2(1),DOC_SPECIALTY varchar2(15));INSERT INTO DOCTOR VALUES('29827','Sanchez','Julio','J','Dermatology');INSERT INTO DOCTOR…arrow_forward
- I need help answering this question for my Database Management class for SQL Developer. Thank you REP (REP_NUM, LAST_NAME, FIRST_NAME, STREET, CITY, STATE, POSTAL_CODE, COMMISSION, RATE) CUSTOMER (CUSTOMER_NUM, CUSTOMER_NAME, STREET, CITY, STATE, POSTAL_CODE, BALANCE, CREDIT_LIMIT, REP_NUM) ORDERS (ORDER_NUM, ORDER_DATE, CUSTOMER_NUM) ORDER_LINE (ORDER_NUM, ITEM_NUM, NUM_ORDERED, QUOTED_PRICE) ITEM (ITEM_NUM, DESCRIPTION, ON_HAND, CATEGORY, STOREHOUSE, PRICE) For each postal code, how many customers are there and its total_balance. Report Postal_Code, Num_of_Customers, T_Balancearrow_forwardI need help with this question for my Database Management class for SQL developer. Thank you REP (REP_NUM, LAST_NAME, FIRST_NAME, STREET, CITY, STATE, POSTAL_CODE, COMISSION, RATE) CUSTOMER (CUSTOMER_NUM, CUSTOMER_NAME, STREET, CITY, STATE, POSTAL_CODE, BALANCE, CREDIT_LIMIT, REP_NUM) ORDERS (ORDER_NUM, ORDER_DATE, CUSTOMER_NUM) ORDER_LINE (ORDER_NUM, ITEM_NUM, NUM_ORDERED, QUOTED_PRICE) ITEM (ITEM_NUM, DESCRIPTION, ON_HAND, CATEGORY, STOREHOUSE, PRICE) Write SQL Queries to: a) Permit joshi to update the ITEM table. b) Increase the Price of Items in ITEM by 10% c) Create an index on balance for the Customer table. d) Add a new order to the database, where Order_Num is 51627 (character type) , Customer_Num is 111 (numeric), and Order_Date is 10/17/2015. e) Add a 5 character column Item_Location to ITEM table.arrow_forwardI need help with this question for my Database Management class for SQL developer. Thank you REP (REP_NUM, LAST_NAME, FIRST_NAME, STREET, CITY, STATE, POSTAL_CODE, COMISSION, RATE) CUSTOMER (CUSTOMER_NUM, CUSTOMER_NAME, STREET, CITY, STATE, POSTAL_CODE, BALANCE, CREDIT_LIMIT, REP_NUM) ORDERS (ORDER_NUM, ORDER_DATE, CUSTOMER_NUM) ORDER_LINE (ORDER_NUM, ITEM_NUM, NUM_ORDERED, QUOTED_PRICE) ITEM (ITEM_NUM, DESCRIPTION, ON_HAND, CATEGORY, STOREHOUSE, PRICE) Question: List TOY category items and orders placed for them. Report: Item_Num, Description, Order_Num, and Order_Datearrow_forward
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology PtrProgramming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage LearningDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning