How To Query Views From Sqlplus

بتاريخ: 11 نوفمبر 200817 سنة

[يسار][يسار]In one sql session (From SQLPLUS, SQLDEV ,TOAD ,etc....) do the following:

1- Try to find the organization ID (ORG_ID) which related to data records,
for example : the org_id which I want to see data in is ‘103’.

begin

fnd_client_info.set_org_context(context => '103');

end;
/
---Your view is queried here in the same window(Session)
SELECT xxx
FROM xxx_v
WHERE xx

--- one Benefits of this:Forms blocks sometimes based on Views,so if you need to do more investigation by taking these views to sqlplus ,you will get no data found from the Queried view.
--This method need to be made whenever you change the sql session.
--Be careful, get the correct Org_id related to your data

[/يسار][/يسار]

اقتباس

تقديم بلاغ

تسجيل دخول

How To Query Views From Sqlplus

Featured Replies

انضم إلى المناقشة

برجاء الإنتباه

Account

Navigation

البحث

إعداد إشعارات المتصفح الفورية

Chrome (Android)

Chrome (Desktop)

Safari (iOS 16.4+)

Safari (macOS)

Edge (Android)

Edge (Desktop)

Firefox (Android)

Firefox (Desktop)