Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Query V$* tables via Visual Basic?

Re: Query V$* tables via Visual Basic?

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 1997/07/31
Message-ID: <5rp9tj$jb3$2@news02.btx.dtag.de>#1/1

Mike Hackett wrote:
>
> Do you have the DBA role? I think that may be necessary to see these views.
> Also make sure the views and appropriate synonyms have been created with the
> installed scripts.
>
> Eddy Setiawan wrote:
>
> >Hi,
> >
> >Is it possible to query the V$* tables using Visual Basic (ODBC)? Because
> >I remembered once I tried but can't see the tables.
> >
> >I wanted to write a front-end program that will chart the performance
> >statistics in the V$* tables in graphical format. Any hint will be
> >greatly appreciated.
> >
> >Regards,
> >--
> >Eddy Setiawan <setiawan_at_singnet.com.sg>
> >http://www.singnet.com.sg/~setiawan

Hi,

Don't forget to set view-names in capital letters in your SQL-string!

-- 
M.Gresz    :-)
Received on Thu Jul 31 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US