DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: how to input a tablename thru script

  1. #1
    Join Date
    Mar 2007
    Posts
    7

    how to input a tablename thru script

    hi,
    I have a script which dispalys the fields which is mentioned there in the table.(ie) its hardcoded.but what i need is the script should be in a generalised format so that when we give any table_name it should populate the values of those table.How can it be done

    it should ask for the input of table name (ie)table name should be inputted manually.
    and then it should populate the corresponding tablename values


    Thanks
    R.Ratheesh

  2. #2
    Join Date
    Apr 2006
    Posts
    377
    Assuming you want to run this query thru SQL*Plus, you can consider Communicating with the User.

  3. #3
    Join Date
    Mar 2007
    Posts
    7
    Quote Originally Posted by ebrian
    Assuming you want to run this query thru SQL*Plus, you can consider Communicating with the User.
    thanks ebrian.
    now what i have to do is i can select like select * from tab;which contains all table name which can be matched with the table name which user is entering.how to get this table name from tab as one by one.what iam trying to do is if the user entering table name and the table name which is there in database matches .then the particular table should display the fields.is this ok or any modifications has to be made

  4. #4
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    For table columns, use all_tab_columns.
    -- Dilip

Posting Permissions

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


Click Here to Expand Forum to Full Width