Hi, I'm new with SQL and Query Reporter and would like to know, if there's a way to get a list of databases and a list of columns/databases?
Someone able to help?
------------------
--
Rgds,
Norbert
In the Query Reporter's SQL Window you can invoke the Query Builder (toolbar button) to build a query from a list of tables/views, columns and foreign key relations. Is this what you need?
------------------
Marco Kalter
Allround Automations
Hi,
no, it's not really what I'm looking for. I'm more looking for an SQL report with a listing of all databases and a listing with fieldnames/databases. I'm not sure, that this is possible, but maybe.
Additionally, how can I suppress deleted records?
[quote]Originally posted by mkalter:
In the Query Reporter's SQL Window you can invoke the Query Builder (toolbar button) to build a query from a list of tables/views, columns and foreign key relations. Is this what you need?
[/quote]
What exactly do you mean by fieldnames/databases?
What do you mean by deleted records? The Query Reporter never displays deleted records (they're gone!).
------------------
Marco Kalter
Allround Automations
I would like to have a list like:
Header: Database name
Records: Database1 (Customers)
Database2 (Orders) ...
and a second list like:
Header: Fieldname Database
Records: CUSTNO CUSTOMERS
CUSTNO ORDERS
NAME1 CUSTOMERS
NAME1 SUPPLIERS
so that I can see which fields are in which database.
[quote]Originally posted by mkalter:
What exactly do you mean by fieldnames/databases?
What do you mean by deleted records? The Query Reporter never displays deleted records (they're gone!).
[/quote]
You cannot run a report accross multiple databases. In a speficic database you can list all tables and columns though, by querying the all_tables and all_tab_columns views.
------------------
Marco Kalter
Allround Automations