Question 2 [10 points] Evaluate the result of the following queries: 1. SELECT INITCAP('SQL Course') FROM...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Question 2 [10 points] Evaluate the result of the following queries: 1. SELECT INITCAP('SQL Course') FROM DUAL 2. SELECT RPAD('SQL' || LPAD(123456, 10, '$'), 15, '#') FROM DUAL 3. SELECT TO_CHAR(sysdate, 'DD Month YYYY HH:MM:SS AM') FROM DUAL Note: sysdate return the server's current date/time. 4. SELECT NULLIF(LENGTH('Java'), LENGTH('Oracle')) result FROM DUAL 5. SELECT UPPER(CONCAT(SUBSTR ('Oracle Database', 1, 7), 'LAB')) FROM DUAL EMPLOYEES EMPLOYEEID FNAME LNAME JOB ID HIRE DATE SALARY MANAGER ID DEPT ID DEPARTMENTS DEPARTMENTID DEPARTMENT NAME MANAGER ID LOCATION ID JOBS JOBID JOB TITLE MIN SAL MAX SAL LOCATIONS LOCATIONID POSTAL CODE CITY COUNTRY ID COUNTRIES COUNTRYID COUNTRY_NAME Question 2 [10 points] Evaluate the result of the following queries: 1. SELECT INITCAP('SQL Course') FROM DUAL 2. SELECT RPAD('SQL' || LPAD(123456, 10, '$'), 15, '#') FROM DUAL 3. SELECT TO_CHAR(sysdate, 'DD Month YYYY HH:MM:SS AM') FROM DUAL Note: sysdate return the server's current date/time. 4. SELECT NULLIF(LENGTH('Java'), LENGTH('Oracle')) result FROM DUAL 5. SELECT UPPER(CONCAT(SUBSTR ('Oracle Database', 1, 7), 'LAB')) FROM DUAL EMPLOYEES EMPLOYEEID FNAME LNAME JOB ID HIRE DATE SALARY MANAGER ID DEPT ID DEPARTMENTS DEPARTMENTID DEPARTMENT NAME MANAGER ID LOCATION ID JOBS JOBID JOB TITLE MIN SAL MAX SAL LOCATIONS LOCATIONID POSTAL CODE CITY COUNTRY ID COUNTRIES COUNTRYID COUNTRY_NAME
Expert Answer:
Answer rating: 100% (QA)
Q2 Below are the answers for all the parts 1 SELECT INITCAPSQ... View the full answer
Related Book For
College Algebra Graphs and Models
ISBN: 978-0321845405
5th edition
Authors: Marvin L. Bittinger, Judith A. Beecher, David J. Ellenbogen, Judith A. Penna
Posted Date:
Students also viewed these finance questions
-
What is the result of the following expression: 96 \ 30? a. 3 b. 3.2 c. 6 d. None of the above.
-
What is the result of the following expression: 96 Mod 30? a. 3 b. 3.2 c. 6 d. None of the above.
-
What is the result of the following expression? 5 > 4? document.write("green"): document.write("blue"); Name the operators, and explain the steps you took to arrive at your answer.
-
A vessel is in the form of an inverted cone. Its height is 8 cm and the radius of its top, which is open, is 5 cm. It is filled with water up to the brim. When lead shots, each of which is a sphere...
-
Manufacturing Incorporated purchased a machine on 1 January 20X2 for $ 500,000. The estimated physical life of the machine is 15 years, but the estimated useful life to Hawkrigg is 10 years. he...
-
A relationship between bond lengths and single bond covalent radii of atoms. Use this relationship together with appropriate data from Table 10.2 to estimate these single-bond lengths. (a) ICl; (b)...
-
With reference to Exercise 11.16, fit a straight line to the data by the method of least squares, using \(M_{\text {ext }}\) as the independent variable, and draw its graph on the diagram obtained in...
-
After plotting demand for four periods, an emergency room manager has concluded that a trend-adjusted exponential smoothing model is appropriate to predict future demand. The initial estimate of...
-
Describe the historical influences that shaped the field of psychology as discussed in the lesson notes. Identify and discuss the contributions of at least two of psychology's forefathers as...
-
A. Richard McCarthy (born 2/14/64; Social Security number 100-10-9090) and Christine McCarthy (born 6/1/1966; Social security number 101-21-3434) have a 19-year-old son (born 10/2/99 Social Security...
-
Quotations for the M&B Corporation are listed as follows: .............................................CALL.............PUT Closing.....Strike....EXP...Premium.....Premium 50.5 ............ 52.0...
-
A $35^{\circ} \mathrm{API}$ oil at $50^{\circ} \mathrm{F}$ is transported in a $2 \mathrm{in}$. sch 40 pipeline. The oil flow rate is measured by an orifice meter that is $1.5 \mathrm{in}$. in...
-
An SRV must be sized to relieve hot water from a water heater at a rate of $20 \mathrm{lb}_{\mathrm{m}} / \mathrm{s}$. If the water is at $220^{\circ} \mathrm{F}$ and $45 \mathrm{psia}$, what nozzle...
-
You have been asked by your boss to select a flow meter to measure the flow rate of gasoline $(\mathrm{SG}=0.85)$ at $70^{\circ} \mathrm{F}$ in a 3 in. sch 40 pipeline. The maximum expected flow rate...
-
Air at $100 \mathrm{psia}$ and $60^{\circ} \mathrm{F}$ is being controlled through a venturi control valve. The backpressure at the valve discharge is $P_{2}=30 \mathrm{psia}$. The flow rate through...
-
A solid particle with a diameter of $5 \mathrm{~mm}$ and an $\mathrm{SG}$ of 1.5 is immersed in a liquid with a viscosity of $10 \mathrm{P}$ and an SG of 1 . How long will it take for the particle to...
-
What purpose do the following types of financial records serve: Bank deposits Bank statements Banking summaries Business activity statements Cheque books Credit card transaction statements Invoices...
-
You are maintaining a subsidiary ledger account for Police-Training Expenditures for 2013. The following columns are used: Inventory purchases are initially recorded as expenditures. Record the...
-
The number of TV channels that the average U.S. home receives has been soaring in recent years. The function t(x) = 0.16x2 + 0.46x + 21.36 can be used to estimate this number, where x is the number...
-
Suppose that a card is drawn from a well-shuffled deck of 52 cards. What is the probability of drawing each of the following? a) A queen b) An ace or a 10 c) A heart d) A black 6
-
The population of St. Louis, Missouri, decreased from 348,194 in 2000 to 319,294 in 2010. Find the average rate of change in the population of St. Louis, Missouri, over the 10-year period.
-
The chief goal of the private sector is effciency.Why? The primary focus of the public sector is equity. Why? It is quite possible to be highly effcient yet ineffective. It is also possible to be...
-
Why is healthcare reform such a contentious issue in the United States? Why have public and private efforts been unsuccessful in fully addressing the challenge of affordable health care? What role(s)...
-
Drawing on economic theory, what kinds of market failure underlie the worlds most pressing problems? Examine three examples: hunger, groundwater contamination, and literacy.
Study smarter with the SolutionInn App