Re: select qry - need an alternate way

Sreelal wrote:
> Thanks.
> My requirement is to select the data from the EMP table itself. But
> through the way i mentioned. Like "select * from _______ where table
> name ='EMP'.

That this discussion is about the EMP table pretty clearly indicates that you are a student or engaged in some form of Oracle education.

Very simply ... you must use the correct syntax to achieve results. What you have written above indicates that you do not understand the point of the WHERE clause. You should have your instructor or mentor explain it to you in detail.

But, in the limited space available here, and ignoring joins, the WHERE clause is NOT where you identify the resource from which you are selecting the record(s) but rather where you filter which records from the source are to be selected. I hope that helps.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)