Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Re: extract the Column names of a table

by DBAugie (Beadle)
on Mar 24, 2008 at 11:40 UTC ( #675887=note: print w/ replies, xml ) Need Help??


in reply to extract the Column names of a table

In Oracle, one reveals the column names with

select COLUMN_NAME from ALL_TAB_COLUMNS where TABLE_NAME = 'NAME_OF_TABLE'

TAMTOWTDI, but it seems to me that using SQL for sql-type things and DBI for database connectivity is a more successful strategy.

r,

Augie


Comment on Re: extract the Column names of a table
Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://675887]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (16)
As of 2015-07-06 13:01 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (74 votes), past polls