Home » RDBMS Server » Server Administration » what is the diff between -select table_name from all_tables;and select * from tab?
what is the diff between -select table_name from all_tables;and select * from tab? [message #373683] Tue, 01 May 2001 14:50 Go to next message
mano
Messages: 4
Registered: May 2001
Junior Member
what is the diff between select table_name from all_tables; and select * from tab?

Report message to a moderator

Re: what is the diff between -select table_name from all_tables;and select * from tab? [message #373686 is a reply to message #373683] Tue, 01 May 2001 15:25 Go to previous message
sandeep
Messages: 110
Registered: October 2000
Senior Member
tab gives you only user tables.
all_tables gives you all tables including dual.

Report message to a moderator

Previous Topic: Re: Select a.x ,b from (select x) a, b question.
Next Topic: Re: who to search patterns ([0-9] or [a-z]) in sql
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 02 17:46:12 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.