First, is it possible to create a table that has a column that is a query? I know i can do it in a view. IE: select column1, column2, (select avg(othercolumn) from othertable) as column3. Is it possible to have that in an actual table?
Also, if i'm sorting by varchar2 , it sorts numbers like (1,10,11,2,21,22).. is there anyway to have varchar2 sort numbers normally? or is there some other data type that allows for non-numeric data that will sort normally?