Create Views on table from different owner help pls
610795Dec 1 2008 — edited Dec 3 2008I am stuck with a problem kindly help me out i want to create a view by selecting certain columns from a table of different owner.I have the privileges but i am unable to get it right.
select table_name from all_tables where owner='COMQDHB';
gets me
TABLE_NAME
----------
GRADE
STUDENT
TEACHER
i want to create a view with only grade and student
iam able create the view of the entire table
create view v1 as select table_name from all_tables where owner='COMQDHB';
but when i try to create the view with selected colums
create view v1 as select table_name(grade,student) from all_tables where owner='COMQDHB'
also i tried to create the view of entire table and then deleting the teacher column but i dont know the proper syntax.
modify view view_name delete column teacher;