ORDER_TOTAL is a column in the orders table with the data type and size as number(8, 2) Examine the following code:
Which statement is correct about the above code?
A.
It gives an error in line 3
B.
It gives an error in line 4
C.
It gives an error in line 6
D.
It executes successfully and displays the output.
B is right answer. Because default value will be not inherit in line 4.
is B the right answer?I think it should execute successfully
Yes, B is the right answer.
B is correct because a variable defined as CONSTANT cannot be referenced for %TYPE.
Thanks, you are absolutely rigth in answer and explanation. I have checked.
B
B. v_order_total is not a TYPE
B
B
B is the right answer.. it gives error at line 4
if you delete “CONSTANT” from the code it runs successfully.
so variable defined as CONSTANT cannot be referenced by %TYPE.
Below you will locate the link to some sites that we feel it is best to visit.
The time to study or go to the subject material or web sites we have linked to beneath.
Sites of interest we have a link to.
we came across a cool web page that you just could take pleasure in. Take a look when you want
always a big fan of linking to bloggers that I appreciate but do not get lots of link love from
please take a look at the sites we follow, such as this a single, as it represents our picks from the web
usually posts some very fascinating stuff like this. If you are new to this site
Here is a good Blog You may Find Fascinating that we Encourage You
please take a look at the web sites we adhere to, such as this 1, because it represents our picks in the web
usually posts some quite interesting stuff like this. If youre new to this site
always a major fan of linking to bloggers that I appreciate but really don’t get a great deal of link appreciate from
we like to honor several other net web pages on the net, even when they arent linked to us, by linking to them. Beneath are some webpages really worth checking out
Here are several of the web sites we recommend for our visitors
B