What is the command in oracle to display all tables??

Question

In oracle is there such a command that will display all tables, All headings, and entities???...basically the entire database???....is so please help me out...thanks

Answer 1

If you have the ability to create an export, you can export the whole database minus the data:
( full=y rows=n )
and then use import to show the contents of the export file without trying to import it ( show=y log=listing.log )

Answer 2

sq. is in elementary terms a language. in case you prefer to artwork in the worldwide of relational databases, then you definately somewhat ought to prefer to first get a stable understand-how of the relational kind and how it somewhat is used in sq.. those foundations are the comparable for all relational databases (Oracle, sq. Server, MYSQL, Postgres etc). Then there are glaring important variations in the dialects utilized by employing employing each database (particularly at an identical time because it contains stored strategies), and lots greater beneficial important variations of their inner implementations (in certainty in the way the cope with concurrency and consistency, i.e. locking and transaction isolation). as much as now as employment, i ought to declare the two sq. Server and Oracle are primary. the biggest huge distinction is that sq. Server locks you in the Microsoft worldwide (that's incredible if that's what you opt for) at an identical time as you will discover Oracle used in a much bigger sort of platforms (abode domicile windows, Linux, Solaris, HP-UX; AIX, etc). additionally Oracle has a bent for use for greater beneficial effective, project-severe applications, at an identical time as sq. Server has a bent for use greater beneficial for greater beneficial basic departmental applications.

Answer 3

No such thing with one command or statement. It would take many select statements.

Answer 4

SELECT * FROM database-name ???