Comments by samulcristina

samulcristina 4-Mar-14 2:03am View

thanks Andy,i understood the solution and have to put intermediate commits while calling objects to free the memory.as per me i need to use OCICacheFree() function to release memory after complete the session.
could you please give me an example how to use the above function in the package.

thanks in advance!!!!

samulcristina 6-Mar-13 3:46am View

Deleted

SELECT B.BANK_NAME,BL.LOC_CITY FROM BANKNAME B
INNER JOIN LOCA_BANK L ON L.BANK_ID=B.BANK_ID
INNER JOIN BANK_LOCATION BL ON BL.LOC_ID=L.LOCATION_ID

this query giving output all bank names with all branches.
but i need to fetch which bank having all locations.

samulcristina 6-Mar-13 0:39am View

i have tried all questions above mentioned but 5th question i written like

SELECT a.bank_name, b.location_city
FROM bank a,
location b,
(SELECT *
FROM ( SELECT bank_id, COUNT (location_id) location_count
FROM bank_location
GROUP BY bank_id
ORDER BY location_count DESC)
WHERE ROWNUM <=1) c
WHERE a.bank_id = c.bank_id;

--but my sir saying output is correct but query is wrong .
plese help to complete this.

Comments by samulcristina (Top 3 by date)