OraFAQ Forum: Open Database Interfaces » show oracle column names

Home » Open Source » Open Database Interfaces » show oracle column names

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

show oracle column names [message #483098]

Thu, 18 November 2010 07:23

dior
Messages: 25
Registered: April 2009

Junior Member

Hi,

if I have a select like:

select val1, val2, val3 from TableXY

I´m be able to show the results in a php file with:

Quote:

echo $row[0];
echo $row[1];
echo $row[2];

.

How can I show the Column Names from the Colums from TableXY to the corresponding row values?

[Updated on: Thu, 18 November 2010 07:26]

Report message to a moderator

Re: show oracle column names [message #483103 is a reply to message #483098]

Thu, 18 November 2010 07:39

Littlefoot
Messages: 16934
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Quote:

How can I show the Column Names from the Colums from TableXY to the corresponding row values?

I can't imagine how should that look like. Could you explain it (possibly with an illustration)?

Report message to a moderator

Re: show oracle column names [message #483104 is a reply to message #483103]

Thu, 18 November 2010 07:45

Barbara Boehmer
Messages: 7667
Registered: November 2002
Location: California, USA

Senior Member

http://forums.oracle.com/forums/thread.jspa?messageID=4412298

Report message to a moderator

Re: show oracle column names [message #483105 is a reply to message #483098]

Thu, 18 November 2010 07:52

Michel Cadot
Messages: 54129
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

How can I show the Column Names from the Colums from TableXY to the corresponding row values?

Depending on what you exactly want you can oci_fetch_assoc or oci_fetch_all instead of oci_fetch_array.
oci_field_name can also did the trick for you but requires 2 calls (one for the fields and one for the result).

Regards
Michel

[Updated on: Thu, 18 November 2010 07:56]

Report message to a moderator

Re: show oracle column names [message #483107 is a reply to message #483105]

Thu, 18 November 2010 08:09

dior
Messages: 25
Registered: April 2009

Junior Member

how it looks like!

table in the db:

value1   value2
  3        a
  2        a
  5        c

and what I need is the "Value1" and "Value2"

what i now get is only this:

  3        a
  2        a
  5        c

Report message to a moderator

Re: show oracle column names [message #483109 is a reply to message #483107]

Thu, 18 November 2010 08:46

Michel Cadot
Messages: 54129
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

And did you try what we pointed you to?
Or do you want we write the code for you? Which by the way is written in Barbara's link and in the links I posted.

Regards
Michel

[Updated on: Thu, 18 November 2010 08:47]

Report message to a moderator