Basic Script to Find the Details of version installed in your machine and how to set the environment for multiple organization

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;

-------------------------------------------------------------------

FACTORIAL PROGRAM

FIND THE FACTORIAL OF ANY NUMBER USING FUNCTION:

CREATE OR REPLACE FUNCTION FACTORIAL (NUM POSITIVE)
RETURN INTEGER IS
BEGIN
IF NUM = 1 THEN -- Terminating condition
RETURN 1;
ELSE
RETURN NUM * FACTORIAL(NUM - 1) ; -- Recursive call
END IF;
END FACTORIAL;

OUTPUT: Fuction created.

Call the function "FACTORIAL" in Sql Statement

SELECT FACTORIAL(1), FACTORIAL(2), FACTORIAL(3), FACTORIAL(4), FACTORIAL(5),FACTORIAL(6),FACTORIAL(7),
FACTORIAL(8),FACTORIAL(9),FACTORIAL(10) FROM dual;