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...
-
What three functions are typically performed by a production control department?
-
Chypre, Inc., produces a cologne mist using a solvent mix (water and pure alcohol) and aromatic compounds (the scent base) that it sells to other companies for bottling and sale to consumers. Chypre...
-
In the template for this exercises, you will find the data for 10 packaged food stocks. Run the template data, and find the portfolio statistics. Notice that while the portfolio R2 is higher than the...
-
A light truck is purchased on January 1 at a cost of $27,000. It is expected to serve for eight years and have a salvage value of $3,000. Calculate the depreciation expense for the first and third...
-
Consider the vector function r(t) = (sin(2t) , t , cos(2t)). Analyze the helix, listing all important properties, then sketch a graph
-
1. Which process should VBB choose to produce?? 2. How much would VBP be willing to pay for the testing that is currently offered, for each batch?? 3. Would we be considered a perfect test, at twice...
-
You are a regional manager at the Walk-In Closet clothing store and you just received the most recent feedback from a mystery shopper's in-store experience report. One thing that caught your eye in...
-
e) Find , if y + siny = cosx f) Find the point of maxima and minima of the function of f(x) = (2x-1)+3. g) Find the slope of the tangent to the curve y=x-x at x=2.
-
You have an apartment for rent. One potential tenant has promised to sign an annual lease for eight years, with each year's rent (paid at the end of the year) of $32,000. Rather than make yearly...
-
Frontline did a great documentary about Walmart, titled, "Is Walmart Good for America?" Please click the link below and view all five short videos....
-
Explain in detail classified balance sheet with current assets, current liabilities, Long term assets, Long term liabilities, Intangible assets and Shareholders equity with specific examples and...
-
If the angle between two lines is and slope of one of the line is 1/2- find the slope of the other line.
-
Suppose a company uses the newsvendor model to manage its inventories and faces normally distributed demand with a coefficient of vaiation = 1.. The company decides to order a quantity that exactly e
-
Banner Company acquires an 80% interest in Roller Company for $640,000 cash on January 1, 2013. The NCI has a fair value of $160,000. Any excess of cost over book value is attributed to goodwill. To...
-
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.
-
From the adjusted trial balance in E 10, prepare the required closing entries for Fish Bowl Cleaning Company, Inc.
-
What should the general manager learn from sensitivity analyses?
-
Which of the quarterly results should the general manager closely monitor?
Study smarter with the SolutionInn App