Interested to Buy Any Domain ? << Click Here >> for more details...
17. Display the order number and average item cost for each
order.
- 1 Answers
- 3855 Views
- Wipro, I also Faced
- E-Mail Answers
Answer / yogesh sharma
select order_no,avg(cost) from order group by order_no;
| Is This Answer Correct ? | 4 Yes | 1 No |
How to export data to a csv file?
How to execute the package in oracle?
WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.
Whether Oracle satisfy more codd rules or db2 satisfy more codd rules? How meny of each can satisfy ? Please answer me. Advance thanks
what are actual and formal parameters?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
What are the uses of a database trigger?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
How to add a new column to an existing table in oracle?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
How would you change old and new values in an insert, delete and update triggers?
How can windows applications connect to oracle servers?
Oracle General 
