CREATE OR REPLACE VIEW "VW_USERS_FULLUSER" AS
SELECT AU.USERNAME, AU.ISANONYMOUS, AU.USERID, AU.LASTACTIVITYDATE, AM.PASSWORDQUESTION, AM.EMAIL, AM.ISAPPROVED,
AM.CREATEDATE, AM.LASTLOGINDATE, AM.LASTPASSWORDCHANGEDDATE, AM.ISLOCKEDOUT, AM.LASTLOCKOUTDATE, AM.COMMENT,
CU.USERID AS HI_USERID, CU.FORCELOGIN AS HI_FORCELOGIN, CU.USERACCOUNTSTATUS AS HI_USERACCOUNTSTATUS,
CU.APPUSERTOKEN AS HI_APPUSERTOKEN, AM.PASSWORDFORMAT, CU.LASTACTIVITY AS HI_LASTACTIVITY,
CU.LASTACTION AS HI_LASTACTION, FUP.ISIGNORED, FUP.PUBLICTOKEN,
FUP.PROPERTYNAMES AS USERPROPERTYNAMES, FUP.PROPERTYVALUES AS USERPROPERTYVALUES,
FUP.ENABLEDISPLAYINMEMBERLIST, FUP.ENABLEPRIVATEMESSAGES, FUP.ENABLEONLINESTATUS,
FUP.ENABLEEMAIL, FUP.ENABLEHTMLEMAIL, AP.PROPERTYNAMES AS PROFILENAMES, FUP.ADDRESS, FUP.QQ, FUP.MSN, FUP.TELPHONE, FUP.CELLPHONE, AP.PROPERTYVALUESSTRING,
AP.PROPERTYVALUESBINARY, FUP.POINTS AS USERPOINTS, FUP.ORDERNUMBER, FUP.EXPENDITURE,
FUP.ENABLETRADEPASSWORD, FUP.TRADEPASSWORDFORMAT, FUP.REALNAME, FUP.REGIONID, FUP.TRADEPASSWORDSALT,
FUP.USERRANK,FUP.PARENTUSERID,FUP.REFERRALUSERID,FUP.AGENT_EXPIRES,FUP.AGENT_ISURLBINDAPPROVED,FUP.AGENT_ISSHOWTQSERVER, FUP.AGENT_TQSERVICES,
FUP.AGENT_SITEURL,FUP.AGENT_LOGOURL,FUP.AGENT_FOOTER,FUP.AGENT_SITENAME, FUP.AGENT_SITEDESCRIPTION, FUP.AGENT_THEME, FUP.AGENT_ONLINESERVICES,
FUP.BIRTHDATE, FUP.GENDER, FUP.BALANCE, FUP.DEDUCTMONEY,
(SELECT ISAGENTRANK FROM HISHOP_USERRANKS WHERE RANKID = FUP.USERRANK) AS ISAGENTRANK,
(SELECT ISMEMBERCREATED FROM HISHOP_USERRANKS WHERE RANKID = FUP.USERRANK) AS ISMEMBERCREATED
FROM ASPNET_MEMBERSHIP AS AM WITH (NOLOCK) INNER JOIN
ASPNET_USERS AS AU WITH (NOLOCK) ON AM.USERID = AU.USERID INNER JOIN
HISHOP_USERS AS CU WITH (NOLOCK) ON AU.USERID = CU.MEMBERSHIPID INNER JOIN
HISHOP_USERPROFILE AS FUP WITH (NOLOCK) ON CU.USERID = FUP.USERID LEFT OUTER JOIN
ASPNET_PROFILE AS AP WITH (NOLOCK) ON AU.USERID = AP.USERID
WHERE (CU.DELETED = 0);这个语句在sql2005中正常执行
但是在orcal中报这样的错误是不是重命名方法找不到表?错误报告:
SQL 错误: ORA-01747: invalid user.table.column, table.column, or column specification
01747. 00000 - "invalid user.table.column, table.column, or column specification"
*Cause:
*Action:
解决方案 »
- 求oralce问题,出现指定项与恢复目录中的任何归档日志均不匹配
- oracle11 64位 安装成功后无法使用plsql 怎么解决
- oracle 登不上
- DBMS_Alert是否可用于两个Oracle数据库之间的通信
- 都是Oracler惹的祸!!!!
- 请问怎样把insert/delete/update三个触发写成一个触发(合在一起,在线等待)
- 菜鸟请教access数据库导入 oracle数据库问题!!!!!!!!!!!!!
- ★★怎么获得计算机名称或者IP地址★★
- 一个Oracle归档日志问题
- 各位前辈,我想求一个绝对值的写法
- EXECUTE IMMEDIATE 结果返回问题
- oracle存储过程
ORACLE 没有此关键字,也没有必要指定不锁表,
ORACLE 读不阻塞写,写也不阻塞读。
谢谢你,tangren 我从2005移到oracle的快郁闷死了,最终确定还是用powerdesigner速度和准确还是比较快的,表结构已经弄好了,剩下了10个视图还有三个没有搞定我发三个帖子你帮我看看好了和过程有300多个
01747. 00000 - "invalid user.table.column, table.column, or column specification"
*Cause:
*Action:
行 27 列 116 出错
无效的:用户.表.列,或者:表.列,或者:列标识符oracle中,如果是操作当前用户下的表,不需要使用:用户.表,直接 表.列 即可;如果此用户为sysdba的话,那么引用某个用户下的表必须使用:用户.表.列