Re: JDBC

From: wysza <awysza_at_invalid.yahoo.com>
Date: Fri, 09 Mar 2001 01:09:52 GMT
Message-ID: <A3Wp6.976$g17.581507@typhoon2.ba-dsg.net>

I don't think it's a right place to post this question. I don't understand exactly what you want to do (it' propably my English...) but: 1. if you want to obtain info about what columns has a particular table, you would sth like this (in sql):

select table_name,column_name from all_tab_columns where table_name ='HERE_GOES_TABLE_NAME'

2. If you want to have data from this table you do: select * from MY_TABLE

I'm sure you will be able to find sample java code on Deja.com, searching one of those java.database news group.

hth
wysza

"Thomas Durlach" <durlecht_at_msu.edu> wrote in message news:9896ct$2ht9$1_at_msunews.cl.msu.edu...
> i was wondering if anyone has experience writing java code to iteract with
> oracle 8i through jdbc......i am trying to get the meta data from a table
> (column names, etc)...and i am having so success....i dont know if its a
bug
> or what......if someone could supply some sample code that shows how to do
> it.....that would be great.
>
> thanks,
>
> thomas durlach
>
>
Received on Thu Mar 08 2001 - 19:09:52 CST