Home > database >  Oracle create a view
Oracle create a view

Time:09-23

The create view toProcessView as select t.t _id, t.t _desc, t.t _lssuer, t.t _performer, p. time p.r time from task t, process p where t.p rocessId=p.p rocessId; Where is wrong

CodePudding user response:

What is wrong to stick

CodePudding user response:

This how to answer, there is no clear error messages, is authority is not enough, is the wrong field, is the table does not exist,

CodePudding user response:

 select t.t _id, t.t _desc, t.t _lssuer, t.t _performer, p. time p.r time 

- write a comma less
 select t.t _id, t.t _desc, t.t _lssuer, t.t _performer, p. time, p.r time 


  • Related