List of databases, list of columns

[beatlejus]

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

 

[Marco Kalter]

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

 

[beatlejus]

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?

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?

 

[Marco Kalter]

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

 

[beatlejus]

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.

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!).

 

[Marco Kalter]

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