column as a query? & order by

[Szhark]

2 quick questions:

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?

Thank You.

[balajiyes]

if u want something like this then it works,

select a.deptno, a.dname, (select avg(b.sal) from emp b where a.deptno = b.deptno) hhh from dept a;

DEPTNO DNAME HHH
---------- -------------- ----------
10 ACCOUNTING 2916.66667
20 RESEARCH 2175
30 SALES 1566.66667
40 OPERATIONS

Cheers!