OraFAQ Forum: Precompilers, OCI & OCCI » TABLE NAME / JOIN / ATTR

Home » Developer & Programmer » Precompilers, OCI & OCCI » TABLE NAME / JOIN / ATTR_GET / OCI

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

TABLE NAME / JOIN / ATTR_GET / OCI [message #113076]

Wed, 30 March 2005 18:04

laplante
Messages: 3
Registered: March 2005

Junior Member

When I do a select from two table, can I get the table name
for each column name.

For example:

while (parm_status==OCI_SUCCESS) {
/* Retrieve the column name attribute */
sndb_checkerr(pl, OCIAttrGet((dvoid*) mypard, (ub4)
OCI_DTYPE_PARAM,
(dvoid**) &col_name,(ub4 *
&col_name_len, (ub4) OCI_ATTR_NAME,
(OCIError *) pl -> errhp ));

will retreive the column name but if the 2 tables have the same name, I need to know the name of the table

How do I get the table name for each column if OCI?

Report message to a moderator

Re: TABLE NAME / JOIN / ATTR_GET / OCI [message #113079 is a reply to message #113076]

Wed, 30 March 2005 18:18

Michael Hartley
Messages: 110
Registered: December 2004
Location: West Yorkshire, United Ki...

Senior Member

Hi,

I think you could be approaching this problem from an academic position rather than a practical position.

If I have a query and I wish to list the columns of the query for my report, I would describe the result set.

If 2 or more result set columns have the same name then the query should be modified to include the column alias.

If I really want to know the column names of 2 or more tables then you should be working against the user_tables and user_tab_columns views.

eg.
select * from user_tables;

select * from user_tab_columns where owner = 'OWNER' and table_name = 'TABLE_NAME';

Michael Hartley

Report message to a moderator

Re: TABLE NAME / JOIN / ATTR_GET / OCI [message #113083 is a reply to message #113079]

Wed, 30 March 2005 18:30

laplante
Messages: 3
Registered: March 2005

Junior Member

Interesting point of view. So since Oracle does not return the name of the table user has to adjust and modify his/her SQL request!

This is not a way I like to do my stuff. But its a last solution to my request if I can't find another way.

Thanks.

Report message to a moderator

Re: TABLE NAME / JOIN / ATTR_GET / OCI [message #113087 is a reply to message #113083]

Wed, 30 March 2005 18:40

Michael Hartley
Messages: 110
Registered: December 2004
Location: West Yorkshire, United Ki...

Senior Member

Hi,

if you discover how to dynamically describe a query to include the tablename and column name then post and example. I'd appreciate having a read of your code.

No points for disecting the original sql fragment though, you have to use OCI function calls. Laughing

Michael.

Report message to a moderator

Previous Topic:	How can I convert a char to date?
Next Topic:	OCILobCreateTemporary Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 17 22:51:29 CST 2024