Tablename qualifier in columns of select

From: <ugtech_at_my-deja.com>
Date: Sat, 09 Oct 1999 09:21:56 GMT
Message-ID: <7tn1fg$3bg$1@nnrp1.deja.com>

Hi,

Can anyone please tell me if there is a way to get the tablename associated with the columns selected in a select statement using OCI calls.

e.g If I have a select statement such as select employee.empno, emptab.empno from employee, emptab is there any way by which I can get the tablename qualifier of each column.

Also, if there is no qualifier specified in the select statement, is there a way to get the tablename associated with the column.

OCI_ATTR_NAME doesnt seem to return the tablename qualifier.

Please help.

Regards
Geeta.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Oct 09 1999 - 04:21:56 CDT