Skip to Main Content
Forums

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!

can we create synonym with some columns of a table ?

955225Oct 25 2013 — edited Oct 25 2013

Hi Guru's,

Can we create synonym with some columns of a table in oracle 11g like below ?

i have table: emp1 with column names empno, ename, job, mgr,hiredate,sal,comm, deptno

i need to create a synonym with this column names empno, ename, sal, deptno. [I know view is the best option for this,but i need to know whether is it possible with synonym or not]

thanks in Advance

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 22 2013
Added on Oct 25 2013
4 comments
2,789 views