-
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
-
Assuming you want to run this query thru SQL*Plus, you can consider Communicating with the User.
-
Originally Posted by ebrian
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|