17. Display the order number and average item cost for each
order.
Answer / yogesh sharma
select order_no,avg(cost) from order group by order_no;
| Is This Answer Correct ? | 4 Yes | 1 No |
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
Explain oracle 12c new features for developers?
What is Read-Only Transaction ?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
How many types of database triggers exist?
I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????
Anybody can tell me, how do we find second largest emp salary from emp table.. Thanks in advance ...
10 Answers Cognizant, ID, NTTF Nettur Technical Training Foundation, Sony, Verizon,
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
i must get table name, constraint type, constrain name with using concads "||" and it must be in string type, then with join processes i need code please help immidiately
Differentiate between TRUNCATE and DELETE?
How to define a data field as not null?
Why should I use oracle database?