I have some query regarding Report generation from Oracle
Apps "PO module".
I have to generate a report where table columns are as below:
Vendor_name Invoice No PO Number Item_Quantity Value of
Goods Date of Shipping Name_of_the_transport
Date_of_receipt_issued.
Now my questions is :from which table/column I can get the
information of "Name_of_the_transport" column.
Thanks in advance.
No Answer is Posted For this Question
Be the First to Post Answer
List the various oracle database objects?
Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i had costumer table that has C_Id and SSN Both as PK and another table has C_Id that must refernece C_Id in Customers i done the usual way and got oracle error message about uniqeness any ideas plz
write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.
Whether any commands are used for months calculation? If so, what are they?
what is index?
What is tns entry?
Can we create trigger on view in oracle?
19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
What is Partitions in Table ?
What are ACID properties in databases?
Can you tell me how to add new column in existing views?how?How is possible?