RE: What does it all mean?

Dennis Paulus <[email protected]> Fri, 22 Mar 2013 17:40:44 +0000
Newsgroups gmane.comp.db.oracle.toad.free
Message-ID <F1AF36903B691E4CB52D98FE75A3475811F432F6@ALVMBXW02.prod.quest.corp>
Hi Daniel,
By chance, is 'nbrclsh' a synonym or view?  To verify, when you do a describe on it, the describe window displays, and on the left hand side, it'll show you the name, owner, and type.

Thanks,
Dennis


From: [email protected] [mailto:[email protected]] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 12:56 PM
To: '[email protected]'
Subject: [toad] What does it all mean?


In my "FROM" clause the first table is you might say, "Grayed out", but not in the usual sense of, "You can't do anything with this." It seems to be somewhat the opposite. In particular, when I use the nt alias for the table followed by a period, the query assist comes to my aid. But when I try the same with the nb alias, no such help. I can DESCribe the black table and query from it just fine. What's going on here?

FROM
     ntrpcls nt,
     nbrclsh nb

TGIF!!

Dan
Daniel B Madvig
Campus Technologies

[cid:[email protected]]<http://nwc.edu/>

Northwestern College & Northwestern Media
3003 Snelling Ave.
St. Paul, MN 55113
www.nwc.edu<http://maps.yahoo.com/py/maps.py?Pyt=Tmap&addr=3003+Snelling+Ave.&csz=St.+Paul%2C+MN+55113&country=us>
651.631.5323

If life gives you melons, you may be lysdexic.
image001.jpg (image/jpeg, 2.3 KB) - not displayed