Question: Which of the following commands creates a new table containing a virtual column? a. CREATE TABLE newtable AS (SELECT order#, title, quantity, retail FROM orders);
Which of the following commands creates a new table containing a virtual column?
a. CREATE TABLE newtable AS (SELECT order#, title, quantity, retail FROM orders);
b. CREATE TABLE newtable (price NUMBER(3), total NUMBER(8,2));
c. CREATE TABLE newtable (calcl NUMBER(4), calc2 NUMBER(4);
d. CREATE TABLE newtable (cola NUMBER(3), colb NUMBER(3), cole AS (cola+colb));
Step by Step Solution
3.34 Rating (160 Votes )
There are 3 Steps involved in it
d CREATE TABL... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (2 attachments)
1803_60b8c121214fb_716030.pdf
180 KBs PDF File
1803_60b8c121214fb_716030.docx
120 KBs Word File
