Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create Views on table from different owner help pls

610795Dec 1 2008 — edited Dec 3 2008
I 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;
This post has been answered by Frank Kulash on Dec 2 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 31 2008
Added on Dec 1 2008
13 comments
1,547 views