Home » SQL & PL/SQL » SQL & PL/SQL » Listing tables and their contents (merged)
Listing tables and their contents (merged) [message #216643] Mon, 29 January 2007 16:35 Go to next message
l2k88
Messages: 2
Registered: January 2007
Junior Member
I am using sql plus. I am trying to find the command to list the names of all of the tables that I have created. Also, I need a command that will list the contents of one of these tables? Can anyone help with this?

Thanks

[Updated on: Mon, 29 January 2007 16:50]

Report message to a moderator

Re: question/listing tables [message #216644 is a reply to message #216643] Mon, 29 January 2007 16:38 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
select table_name from user_tables;
question 2 [message #216645 is a reply to message #216643] Mon, 29 January 2007 16:51 Go to previous messageGo to next message
l2k88
Messages: 2
Registered: January 2007
Junior Member
How could I list the contents of one of my tables?
Re: question 2 [message #216646 is a reply to message #216645] Mon, 29 January 2007 16:57 Go to previous message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
It appears that you can't even spell SQL.
SELECT * FROM MY_TABLE;
Previous Topic: syntax loop error
Next Topic: Date Generation
Goto Forum:
  


Current Time: Mon Dec 05 02:49:20 CST 2016

Total time taken to generate the page: 0.07544 seconds