新手问题,oracle中的cross join和别名
King 2002-12-11 10:48:31 环境:oracle 8.17,pl/sql developer
1:使用cross join的时候语法检测通过,但执行的时候返回“命令结束有问题”,出错信息是:"dynamic performance tables not accessible , automatic statistics disabled for this session . You can disable statistics in the preference menu , or obtain select priviliges on the v$session , v$sesstat and v$statname tables";
2:oracle中sql的用法是否和sql server有分别,例如别名功能,在sql server中下面语句是行得通的:"select t.id from table1 t",但在oracle通不过,那里有这方面的详细资料?