When I query oracle11G view_lis_req_patientinfo inside this view:
The select FSQDH as ID,
FSQDH as order_id,
F_ItemCode as HSITEM_ID,
F_ItemName as ITEM_NAME,
1 the as NUM,
"' as the unit,
FDJ as RETAIL_PRICE,
FDJ as fzje
- f_sendtime as FChargeTime
The from view_lis_req_patientinfo
The statement did not find any data,
Select * from view_lis_req_patientinfo can normal detected data,
Great god answers, genuflect is begged, online, etc

CodePudding user response:

Through what to check?

CodePudding user response:

If you have the foreground string concatenation to comment went to look at

CodePudding user response:

Through PLSQL tools also could not query result set, can only be written to a temporary table do transit inside,

CodePudding user response:

Don't know whether to upgrade the database problems, before was a oracle10G is normal, I yesterday after upgrading to oracle11G appear this problem

CodePudding user response:

Remove the as you try again, seem to remember the as in column, oracle is not support the use of the as prefix oriented as an alias

CodePudding user response:

Remove the AS tried, and can't

CodePudding user response:

12311111111111

CodePudding user response:

 select FSQDH 
The from view_lis_req_patientinfo 

This can query the things?
If you can, add a field, each screening (select * can retrieve the data, according to the field output there is no reason to query does not come out)

CodePudding user response:

Two statements is performed under the same user, if not may be of the same name two tables, it is also possible that synonyms, see below

CodePudding user response:

1, is under the same user executing
2 and make sure the object is effective
3, the select * from view_lis_req_patientinfo data, the statement directly to modify for the select FSQDH from view_lis_req_patientinfo see whether there is data