Member Avatar for Junaid.mcsd

i am a new bee to oracle and database world, i need your help,

as i am a student i learnt some commands in class, how to retrieve the tables and its contents in 10g, my question is that, is there any builtin tables in oracle 11g as well if yes then how i enable and view it,
also let me know how can i install SQLplus for oracle 11g

thanks

  • 2 Contributors
  • 1 Reply
  • 313 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by davidcairns
Member Avatar for davidcairns

The important things for the noob are

ALL_TABLES
ALL_TAB_COLUMNS
ALL_OBJECTS
ALL_VIEWS

note all of these have a version for the user you are logged in as

USER_TABLES
etc.

There are quite a few more (ALL or USER is required), _CONSTRAINTS, _SOURCE, _INDEXES to name a few.

Have a nose around and get to know them, I have never stopped using them in over 20 years

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.