Select all table names from Oracle DB [duplicate]

Question

I write a program which scans all tablenames of a database and displays all

My Db has the Tables : User, Order,History

It should look like this:" Existing Tables: User Order History"

how should the command look like?

string SqlOrder="Select ??? from TestDB"

You need to fire the statement, get the results then format these in c# — CloudyMarble
– CloudyMarble, Commented Mar 6, 2013 at 9:28

peterm · Accepted Answer · 2013-03-06 10:03:29Z

3

Try this

SELECT 'Existing Tables: ' || wm_concat(table_name) tablenames 
  FROM user_tables;

For the sample Oracle HR database it returns

TABLENAMES
------------------------------------------------------------------------------------
Existing Tables: REGIONS,LOCATIONS,DEPARTMENTS,JOBS,EMPLOYEES,JOB_HISTORY,COUNTRIES

UPDATE: Example with LISTAGG()

SELECT 'Existing Tables: ' || LISTAGG(table_name, ',') 
        WITHIN GROUP (ORDER BY table_name) tablenames 
  FROM user_tables;

edited Mar 6, 2013 at 10:03

user330315

answered Mar 6, 2013 at 9:36

peterm

93k16 gold badges157 silver badges162 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

CloudyMarble Over a year ago

LISTAGG() could be relevant too : oracle-base.com/articles/misc/…

peterm Over a year ago

Agree. Added to the answer.

Sam Over a year ago

This answere do exactly what i want to do thx !

user330315 · Accepted Answer · 2013-03-06 09:28:45Z

1

select table_name
from all_tables

More details in the manual: http://docs.oracle.com/cd/E11882_01/server.112/e25513/statviews_2117.htm#i1592091

answered Mar 6, 2013 at 9:28

user330315

4 Comments

CloudyMarble Over a year ago

manual link is missing, besides i guess the OP didnt mean this

CloudyMarble Over a year ago

I understood it like he would like to have the string before the tablenames and the tablenames as coma separated which would explain tagging the question with the C# tag.

user330315 Over a year ago

@TwoMore: but he still neeeds to select all table names somehow.

CloudyMarble Over a year ago

absolutly right, i have no problem with your answer but wonders if it answers the question, guess we will have to wait for the OP

Collectives™ on Stack Overflow

Select all table names from Oracle DB [duplicate]

2 Answers 2

3 Comments

4 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

4 Comments

Linked

Related