Which statement produces the following output? - ProProfs Discuss
Advertisement

Which statement produces the following output?

The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4) NOT NULL CUSTOMER_NAME VARCHAR2(100) NOT NULL CUSTOMER_ADDRESS VARCHAR2(150) CUSTOMER_PHONE VARCHAR2(20) You need to produce output that states Dear Customer customer_name. The customer_name data values come from the CUSTOMER_NAME column in the CUSTOMERS table.

This question is part of oracle_test4
Asked by Sudha_test, Last updated: Oct 23, 2020

+ Answer
Request
Question menu
Vote up Vote down

2 Answers

C. Block

C. Block

Find happiness in writing new things.

C. Block
C. Block, English Professor, M.A, Ph.D, Buffalo

Answered Dec 14, 2018

In order to produce an output that states Dear Customer customer_name with the customer_name data values come from the CUSTOMER_NAME column in the CUSTOMERS table, they need to SELECT Dear Customer || customer_name || , FROM customer;. This specifically helps in the case when the customer’s table has the following columns: CUSTOMER_ID NUMBER(4) NOT NULL CUSTOMER_NAME VARCHAR2(100) NOT NULL CUSTOMER_ADDRESS VARCHAR2(150) CUSTOMER_PHONE VARCHAR2(20). This question tests how well you know how to use Oracle and SQL. SQL is a type of coding language that communicates with some type of database.

upvote downvote
Reply 

John Smith

John Smith

John Smith
John Smith

Answered Jan 13, 2017

SELECT Dear Customer || customer_name || , FROM customer;
upvote downvote
Reply 

Advertisement
Advertisement
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader

Email Sent
We have sent an email to your address "" with instructions to reset your password.