fnd_user_pkg.CreateUser('SIMON', 'SEED', 'PW$234567' ); --- --Add Resp --select * from fnd_responsibility fr where fr.responsibility_id = --select * from fnd_responsibility_tl frt where upper(frt.responsibility_name) like '%%' --select * from fnd_application fa where fa.application...
ALTER PROCEDURE [dbo].[FND_USER_PKG_GetUserByUserName] @user_name nvarchar(100) AS BEGIN select fnd_user.*,case when password_lifespan_days>0 then password_lifespan_days-datediff(day,isnull(password_date,'1900/1/1'),getdate()) else null end PASSWORD_DAYS_LEFT from fnd_user where get...
用plsql developer连接远程oracle时会出现Could not initalize oci.dll警告,原因分析:安装完后Oracle的 ...
fnd_user_pkg.CreateUser('SIMON', 'SEED', 'PW$234567' ); --- --Add Resp --select * from fnd_responsibility fr where fr.responsibility_id = --select * from fnd_responsibility_tl frt where upper(frt.responsibility_name) like '%%' --select * from fnd_application fa where fa.application...