Professional Web Applications Themes

Getting list of available tables - Oracle Server

Thanks for all input... Complete newbee here. Here is my version: Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production PL/SQL Release 8.1.7.2.0 - Production CORE 8.1.7.0.0 Production TNS for HPUX: Version 8.1.7.2.0 - Production NLSRTL Version 3.4.1.0.0 - Production I access all of my data using VB through a terminal emulator. WRQ's Reflection for Regis Graphics. The data is read off the screen, cleaned up, and then saved as text files. I would really like to access the database directly. I am able to use SQL Plus through the above mentioned terminal emulator. Is there a way to gather a list ...

  1. #1

    Default Getting list of available tables


    Thanks for all input...

    Complete newbee here. Here is my version:

    Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
    PL/SQL Release 8.1.7.2.0 - Production
    CORE 8.1.7.0.0 Production
    TNS for HPUX: Version 8.1.7.2.0 - Production
    NLSRTL Version 3.4.1.0.0 - Production

    I access all of my data using VB through a terminal emulator.
    WRQ's Reflection for Regis Graphics. The data is read off the screen,
    cleaned up, and then saved as text files. I would really like to access
    the database directly. I am able to use SQL Plus through the above
    mentioned terminal emulator. Is there a way to gather a list of
    available tables and stored procedures? Or, would I need foreknowledge
    of the names of each. Also, can you direct me to any sources which
    might give me the information I need to connect to the Oracle database
    directly from Visual Basic. My ultimate goal would be to query the
    database directly using ADO.

    Thank you very much for any help you can offer!

    Tom

    --
    Posted via [url]http://dbforums.com[/url]
    TsTom Guest

  2. #2

    Default Re: Getting list of available tables

    You want to query the system catalogs. For a list of all tables You can see
    it would be
    select table_name from all_tables;
    for a list of all tables you own it would be
    select table_name from user_tables;
    for a list of all tables (assuming you are the dba)
    select table_name from dba_tables;

    Go to otn.oracle.com, sign up for free and you can download software, read
    the on line manuals.
    Jim



    --
    Replace part of the email address: [email]kennedy-down_with_spammersattbi.com[/email]
    with family. Remove the negative part, keep the minus sign. You can figure
    it out.
    "TsTom" <member22491dbforums.com> wrote in message
    news:2384242.1042510128dbforums.com...
    >
    > Thanks for all input...
    >
    > Complete newbee here. Here is my version:
    >
    > Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
    > PL/SQL Release 8.1.7.2.0 - Production
    > CORE 8.1.7.0.0 Production
    > TNS for HPUX: Version 8.1.7.2.0 - Production
    > NLSRTL Version 3.4.1.0.0 - Production
    >
    > I access all of my data using VB through a terminal emulator.
    > WRQ's Reflection for Regis Graphics. The data is read off the screen,
    > cleaned up, and then saved as text files. I would really like to access
    > the database directly. I am able to use SQL Plus through the above
    > mentioned terminal emulator. Is there a way to gather a list of
    > available tables and stored procedures? Or, would I need foreknowledge
    > of the names of each. Also, can you direct me to any sources which
    > might give me the information I need to connect to the Oracle database
    > directly from Visual Basic. My ultimate goal would be to query the
    > database directly using ADO.
    >
    > Thank you very much for any help you can offer!
    >
    > Tom
    >
    > --
    > Posted via [url]http://dbforums.com[/url]

    Jim Kennedy Guest

Similar Threads

  1. mysql dbi list of tables
    By neo ancient in forum PERL Modules
    Replies: 3
    Last Post: October 7th, 03:56 AM
  2. list tables from Access 2000
    By manylists in forum Coldfusion Database Access
    Replies: 1
    Last Post: April 28th, 09:09 PM
  3. List Access database tables
    By Kevin Ingram in forum ASP Database
    Replies: 7
    Last Post: January 9th, 04:09 AM
  4. Replies: 1
    Last Post: October 5th, 06:14 AM
  5. Replies: 5
    Last Post: August 19th, 12:15 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139