Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Query V$* tables via Visual Basic?
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