4. Display the order number and client number from the ORDER
table. Output the result in the format. Client
ordered
Answer
Is This Answer Correct ? | 1 Yes | 1 No |
5. Display full details from the ORDER_LINE table where the
item number is (first condition) between 1 and 200 (no > or
< operators) OR the item number is greater than 1000 AND
(second condition) the item cost is not in the list 1000,
2000, 3000 OR the order number is not equal to 1000.
Answer
Is This Answer Correct ? | 3 Yes | 1 No |
Question { 74132 }
SELECT ROUND(TRUNC(MOD(1600,10),-1),2)
FROM dual;
Answer
Is This Answer Correct ? | 116 Yes | 5 No |
Q1.all the depts which has more then 10 empls?
Q2.all the dept which does not have any emply?
Q3 all the emp which does not have any dept?
Q4 get all the emply detais with the dept details it dept is
exit otherwise any emp details?
Q5 how to debugg the dynamic sql and packages?
Answer
Is This Answer Correct ? | 3 Yes | 2 No |
Q1.all the depts which has more then 10 empls?
Q2.all the dept which does not have any emply?
Q3 all the emp which does not have any dept?
Q4 get all the emply detais with the dept details it dept is
exit otherwise any emp details?
Q5 how to debugg the dynamic sql and packages?
Answer
Is This Answer Correct ? | 2 Yes | 1 No |