Home » SQL & PL/SQL » SQL & PL/SQL » List of values to detect available tables
List of values to detect available tables [message #660] Tue, 26 February 2002 03:00 Go to next message
Greg Horton
Messages: 37
Registered: February 2002
Member
I would like to add two list items or list of values to my canvas. The first list should dynamically contain a list of the current tables available in the users workspace and the second list should contain a similar list, apart from this time the list should contain the table columns associated with the selected table from the first List Item.
I will then assign these values to variables for use in a select statment.

Has anyone come across this before or can offer any help?

Thanks,

Greg

Report message to a moderator

Re: List of values to detect available tables [message #663 is a reply to message #660] Tue, 26 February 2002 03:40 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
query for 1st one should be

select table_name from user_tables

and for second one

select column_name from user_tab_columns
where table_name=:first_list.selected_value

Report message to a moderator

Previous Topic: Can't use CASE within a cursor in a package??
Next Topic: Stand By Server
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 18:49:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.