Along the lines of: select * from blah; If you had both a table and a view named blah, how would Oracle know which one you wanted to select from, especially if the structures were different? -- -- Bill Ferguson -- //www.freelists.org/webpage/oracle-l