New answers tagged

0

I was putting the wrong service name. You can check yours on tnsnames.ora.


0

Please take a look at http://www.orafaq.com/wiki/NESTED_TABLE. When you include the nested table it is like a join, so if you want a single row per customer, you will need to do some sort of unpivot (note that there could be more than two phone numbers in the nested table — Oracle needs to know how many columns to return. This will return all the rows: ...



Top 50 recent answers are included