This content has been marked as final. Show 15 replies
I am grateful for your help but, as I answered previously, you didn't provide me
the answer to my problem:
I only want the five tables (EMP, DEPT, BONUS, SALGRADE and DUMMY) which
are "meaningful" to me.
But maybe it is not possible... Maybe it is not possible to make the difference
between those tables and the others...
Thanks and regards,
All right :)
But suppose I don't remember my table names (exactly) (which is
commonplace for me)...
With MySQL, I often do a little "show tables" and then a "select"
query (once I have retrieved the right table name (suppose there
are upper case letters or underscores in the table names)).
Maybe, it's not possible to get I want...
Maybe, a solution is to prefix every table name with a specific prefix
"foo_" and then execute:
where table_name like 'foo_%';
Thanks and all the best,
Thank you for your answer.
Would you mind giving me the exact query?
I am not sure about what you mean about "comparing one DB features to another".
Are you thinking about my writing about MySQL?
If so, I think you are wrong :) : why?
1) because it is normal for someone to try to use one's previous knowledge in the
database field, not doing so would be silly and waste ;
2) and moreover, I DO think it is interesting to compare one DB features to another.
I wish I had found a good comparison between MySQL and Oracle.
It would have helped me a lot.
You know... some kind of tutorial for Oracle beginners who are used to MySQL...
I can admit I didn't compare the right things but I am trying to.
I am not judging Oracle. I don't care about that. I only want to understand as
quickly as I can :).
What I want to do with Oracle, I already know how to do it with MySQL.
So I am trying to do "exactly" the same.
I know Oracle is powerful, I am not questioning that.
I also know some MySQL drawbacks.
I am not the inventor of these RDMS, so I wont defend any of them...
I am sorry if you misunderstood me.
There are several system views that will let you see database objects.
USER/ALL/DBA_TABLES shows you all the tables your schema owns, all the tables your (login) schema can see, and all tables that exist. Usually only users with DBA privileges can see the DBA_TABLES view.
Try running your query from USER_TABLES, something like
If that gives you back too many rows then you'll need a way of restricting the rows returned by a WHERE clause predicate - some criteria that will give you back only the data you want.
select table_name from user_tables