我想使用view命令在一个模式中显示这4列。我试着用前3列创建一个视图，因为它们来自同一个表。加上另一个专栏是我最头疼的。我尝试了alter函数，但是视图模式似乎没有表所具有的编辑权限。我希望这是有道理的。

create table PATIENTINFO (  
    PatientID       number not null,  
    FirstName       varchar2(50) not null,  
    LastName        varchar2(50) not null,  
    Address         varchar2(50),  
    City            varchar2(50),  
    State           varchar2(50),  
    ZipCode         number(5),  
    Phone           number(10) not null ,  
    Email           varchar2(50),  
    MemberID        number not null,  
    constraint  pk_departments primary key (PatientID)  
)

create table LABORDER ( 
    LabOrderNumber  number not null, 
    OrDate          date not null, 
    ReqBloodTest    varchar2(15) not null, 
    Reason          varchar(50), 
    PatientID       number not null, 
    constraint  pk_laborder primary key (LabOrderNumber), 
    constraint  fk_laborder_patientid foreign key (PatientID) 
            references PATIENTINFO (PatientID) 
)

CREATE VIEW PatientBlood AS 
      SELECT FirstName, LastName, PatientID 
      FROM PATIENTINFO