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