本文提供了两个具体的SQL查询语句示例，分别用于从APPLSYS.FND_APPL_TOPS表中选择特定字段，以及从fnd_env_context表中根据特定条件获取数据。通过这两个例子，读者可以了解到如何构造SQL查询来获取所需的数据。
Get APPL_TOP
select name,
node_id,
path,
shared,
created_by,
creation_date,
last_updated_by,
last_update_date,
FILE_SYSTEM_GUID,
appl_top_guid
FROM APPLSYS.FND_APPL_TOPS;
Get <PROD>_TOP
select variable_name,
value
from fnd_env_context
where variable_name like '%\_TOP' escape '\'
and concurrent_process_id = (select max(concurrent_process_id) from fnd_env_context)
order by 1;
select name,
node_id,
path,
shared,
created_by,
creation_date,
last_updated_by,
last_update_date,
FILE_SYSTEM_GUID,
appl_top_guid
FROM APPLSYS.FND_APPL_TOPS;
Get <PROD>_TOP
select variable_name,
value
from fnd_env_context
where variable_name like '%\_TOP' escape '\'
and concurrent_process_id = (select max(concurrent_process_id) from fnd_env_context)
order by 1;
扫一扫
276
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
