View the Exhibit and examine the structure of the EMPLOYEES table.
Examine the data in the ENAME and HIREDATE columns of the EMPLOYEES table:
ENAME HIREDATE
SMITH 17-DEC-80
ALLEN 20-FEB-81
WARD 22-FEB-81
You want to generate a list of user IDs as follows:
USERID
Smi17DEC80
All20FEB81
War22FEB81
You issue the following query:
SQL>SELECT CONCAT(SUBSTR(INITCAP(ename),1,3), REPLACE(hiredate,’-‘)) “USERID”
FROM employees;
What is the outcome?
A.
It executes successfully and gives the correct output.
B.
It executes successfully but does not give the correct output.
C.
It generates an error because the REPLACE function is not valid.
D.
It generates an error because the SUBSTR function cannot be nested in the CONCAT function.
A is correct
true
Usually posts some very interesting stuff like this. If you are new to this site.
Here are a few of the web pages we recommend for our visitors
we came across a cool web site that you might appreciate. Take a appear for those who want
that could be the end of this write-up. Right here youll come across some sites that we assume you will enjoy, just click the hyperlinks over
usually posts some incredibly interesting stuff like this. If you are new to this site
that would be the end of this report. Here you will come across some internet sites that we consider youll appreciate, just click the hyperlinks over
we came across a cool web-site that you simply might delight in. Take a search in case you want
although websites we backlink to beneath are considerably not associated to ours, we really feel they may be really worth a go as a result of, so have a look
Wonderful story, reckoned we could combine a couple of unrelated information, nevertheless genuinely really worth taking a search, whoa did one particular master about Mid East has got additional problerms also
Here are several of the internet sites we recommend for our visitors
one of our guests a short while ago encouraged the following website
here are some hyperlinks to web-sites that we link to mainly because we feel they may be really worth visiting
The info mentioned in the post are a number of the most beneficial available
just beneath, are numerous totally not associated sites to ours, even so, they may be surely worth going over
Sites of interest we’ve a link to
please stop by the sites we comply with, such as this 1, as it represents our picks from the web
one of our visitors not too long ago advised the following website
below you will come across the link to some web pages that we think you must visit
check below, are some entirely unrelated sites to ours, having said that, they may be most trustworthy sources that we use
please take a look at the web sites we follow, which includes this 1, as it represents our picks through the web
please visit the web sites we follow, such as this 1, as it represents our picks through the web