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!

How To Add A "Placeholder" column

user12296489Dec 10 2009 — edited Dec 10 2009
Using PLSQL trying to add a new column that is not part of the table I'm pulling most of my using:

SELECT me607.subscriber_id,
second_nbr varchar(15),
me607.mbr_type
from odw.mbr607_member_expanded me607,
odw.mbr00_member_master mbr00


Trying to add the column "second_nbr" as type varchar(15)

The error I get is: FROM KEYWORD NOT FOUND WHERE EXPECTED..

This is the first time I am attempting to add a "place-holder" column, so I figure I've got the syntax wrong somewhere..Thanks for any assistance..
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 7 2010
Added on Dec 10 2009
8 comments
2,316 views