Thread: Want to Get Table Names

View Single Post

  #5 (permalink)  
Old 11-12-2008, 07:56 AM
sanereddy sanereddy is offline
Senior Member
  
Join Date: Nov 2004
Posts: 175
sanereddy is an unknown quantity at this point
Quote:
Originally Posted by geetaravula View Post
even i want answer to the same question by using sql or pl/sql please help me out

Oracle : select * from tabs

SQl Server : select name, user_name(uid) from sysobjects where type='U'
sp_tables
Reply With Quote