SELECT user_name,
responsibility_name,
user_form_name,
login_name,
TIME,
pid,
terminal_id,
user_id,
resp_appl_id,
responsibility_id,
form_id,
form_appl_id
FROM fnd_signon_audit_view
ORDER BY to_number(substr(TIME, 1, instr(TIME, ':') - 1)) * 60 +
to_number(substr(TIME, instr(TIME, ':') + 1))[@more@]
responsibility_name,
user_form_name,
login_name,
TIME,
pid,
terminal_id,
user_id,
resp_appl_id,
responsibility_id,
form_id,
form_appl_id
FROM fnd_signon_audit_view
ORDER BY to_number(substr(TIME, 1, instr(TIME, ':') - 1)) * 60 +
to_number(substr(TIME, instr(TIME, ':') + 1))[@more@]
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7180624/viewspace-906106/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
将excel数据导入oracle中
下一篇：
不要太着急
请登录后发表评论
登录
全部评论
