FIND THE DATABASE VERSION :
SELECT * FROM V$VERSION ;
---------------------------------------
FIND THE RELEASE_NAME :-
SELECT RELEASE_NAME FROM FND_PRODUCT_GROUPS ;
------------------------------------------
FIND THE SCHEMA NAME AND USER CREATED OBJECT DETAILS :
SELECT * FROM ALL_OBJECTS;
OBJECT_NAME :- OBJECT NAME LIKE TABLE/VIEW/INDEX etc.
OWNER : - SCHEMA NAME.
-----------------------------------
OR
RUN THE ANONYMOUS PL/SQL BLOCK TO RETRIEVE THE CURRENT SCHEMA NAME DETAILS:-
BEGIN
DBMS_OUTPUT.PUT_LINE(ora_login_user||' is the current schema .'); --returns current schema name
END;
-----------------------------------
SET THE ENVIRONMENT for MULTIPLE ORGANIZATION :
FIND THE OPERATING UNITS :-
SELECT * FROM HR_OPERATING_UNITS ;
BEGIN
FND_CLIENT_INFO.SET_ORG_CONTEXT('ORG_ID');
END;
BEGIN
DBMS_APPLICATION_INFO.SET_CLIENT_INFO('ORGANIZATION_ID');
END;
-------------------------------------------------------------------
