From: mcstockX@Xenquery   
      
   your question is not clear, but it looks like you need to do research on   
   expressions -- take some time reading the Oracle SQL Reference manual, and   
   running some tests   
      
   you will find that oracle does not support derived columns in table   
   definitions, but it does in views   
      
   -{ mcs   
      
   "x"  wrote in message news:c11pqa$u56$1@ls219.htnet.hr...   
   | IF you had a tale with columns   
   |   
   | a number   
   | b number   
   | a-b number   
   |   
   | what would return   
   |   
   | select a-b from x   
   |   
   | ?   
   |   
   |   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)