When I make a Oracle trace (alter session set sql_trace=true) the output is
any as:
SELECT CORP,HOUSE,CUST,EQP_TABLE_CODE
FROM CUST_OUTLET
WHERE HOUSE=NVL(:b1,' ')AND CUST=
NVL(:b2,' ')
But, I don't need the b1 and b2 parameters.
I need the contents of b1 and b2.
That is to say, an output like this:
SELECT CORP,HOUSE,CUST,EQP_TABLE_CODE
FROM CUST_OUTLET
WHERE HOUSE=NVL('01010 )AND CUST=
NVL('010').
Can any help me. please??
It's very important for me.
Thank's a lot.
Then, I need the contents of variables.
Received on Sat Nov 14 1998 - 05:46:29 CST
