Home » SQL & PL/SQL » SQL & PL/SQL » Column names function
Column names function [message #499] Fri, 15 February 2002 14:28 Go to next message
Elliot
Messages: 1
Registered: February 2002
Junior Member
Is there a SQL function that returns a list of column names from a query? Something like QUERYNAME.RECORDSET which, by the way, doesn't work. Neither do the other several dozen shots in the dark I tried.

When you Select * then the query finds all the values; so there must be a list of those values' names somewhere in the system. Can anyone tell me where to find it?

I would much appreciate the help. Thanks.

Report message to a moderator

Re: Column names function [message #503 is a reply to message #499] Sat, 16 February 2002 16:52 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
select column_name from all_tab_columns
where table_name=upper('&tablename')

Report message to a moderator

Previous Topic: names
Next Topic: forms 6 install
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 23:36:57 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.