What are nested tables?
No Answer is Posted For this Question
Be the First to Post Answer
What are the uses of Rollback Segment ?
What is the difference between Delete, Truncate and Drop in Oracle?
what is port in oracle? how is it related to database application.
What is the difference between SQL and SQL Server?
What is a sub query? Describe its types?
What is COST-based approach to optimization ?
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.
What is meant by a deadlock situation?
If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X
What is transport network substrate (tns) in oracle?
How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col