home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 1,123 of 2,288   
   .com to Niy   
   Re: column name can't include character    
   20 Feb 04 06:20:43   
   
   From: mcstockX@Xenquery   
      
   "Niy"  wrote in message   
   news:55dd405a.0402191936.584f4b8e@posting.google.com...   
   | Thanks for the reply.   
   |   
   | In v$transaction, you can see   
   | DSCN-B, DSCN-W columns, how   
   | to select them?   
      
      
   very observant -- you have to (always) use double-quotes to select these   
   columns, and type them in upper case, because oracle (why, oh, why?) used   
   non-conforming column names here   
      
   the only exception to 'always' is when you do a SELECT *   
      
   select addr, "DSCN-B", "DSCN-W"   
   from v$transaction   
      
   -{ mcs   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca