Query the meta data directly in the user_tables & user_tab_columns tables.
Can you just use another type of connection to get the information about it?
(e.g. sqlplus) What problem exactly are you trying to solve?(Your original
post doesn't seem to have anything to do wht this question.
Jim
"SQL Dummy" <hza63_at_hotmail.com> wrote in message
news:fd0a0e63.0107291718.25ddd503_at_posting.google.com...
> Thanks for your response. The problem is: I am using a JDBC Thin
> driver and trying to get the information about some table - I don't
> know the field name and type - just know the name of the table. I
> cannot get MetaData through the connection. Do you know any way to get
> these information?
>
>
> Thanks
>
> Peter
>
>
> "Jim Kennedy" <kennedy-family_at_home.com> wrote in message
news:<mqI87.415239$p33.8425115_at_news1.sttls1.wa.home.com>...
> > If you know what row you want specify it. That is what makes the
particular
> > row that you want unique?
> > You can do select ... from ... where rownum=1 ... to get the first row.
> > To get any particular row what is special about it?
> > Jim
> > "SQL Dummy" <hza63_at_hotmail.com> wrote in message
> > news:fd0a0e63.0107281537.51091196_at_posting.google.com...
> > > I have a question to use SQL select statement:
> > > How can I just get one row from a table? (for example, first row or
> > > any row?)
> > >
> > > Thanks
> > >
> > > SQL Dummy
Received on Sun Jul 29 2001 - 21:59:26 CDT
