HomeForum
Welcome, Guest

Where are my Tables?
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Where are my Tables?

Where are my Tables? 1 year, 9 months ago #938

  • terjo
  • OFFLINE
  • Fresh Boarder
  • Posts: 1
  • Karma: 0
I have no problem connecting to my Oracle Databases and retreiving data, but I can't seem to get any of my tables to appear in the Tables window. Incremental search using known table names doesn't seem to be working.

Re:Where are my Tables? 1 year, 8 months ago #939

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2183
  • Karma: 12
This is the sql we use to get list of oracle tables

select owner||'.'||Decode(INSTRB(table_name,' ', 1, 1),0,table_name,'"'||table_name||'"') from all_tables where owner=user
union all
select owner||'.'||Decode(INSTRB(view_name,' ', 1, 1),0,view_name,'"'||view_name||'"') from all_views where owner=user
order by 1

Perhaps you have not got any tables or enough user rights?

Peter
  • Page:
  • 1
Time to create page: 0.14 seconds

Testimonials

Well this great product and I’ve ever seen …. Yet.

Inexpensive
User friendly
Trusted and Reliable
Best features
Great support
Very fast and best performance
Recommend for all groups (small, medium, large / enterprise)

C Gandhi
Nesa-Canada

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top