Feature #903
closed
- Assignee set to Rasmiya R S
- Status changed from New to In Progress
- % Done changed from 0 to 10
22-09-2023
1) Familiarisation of database code and function PACKAGE BODY PKG_FIELD_OFFICE_UTILITY AS.
2) compile and run demo SQL code in Oracle.
3) Create a new package. Resolving the error when compiled
- % Done changed from 10 to 60
- % Done changed from 60 to 10
25-09-2023
In DB, Connected to the database EPFO-SQL.
Process exited. But Table is not showing. Resolving the issue.
- % Done changed from 10 to 20
- % Done changed from 20 to 90
26-09-2023
results of the execution of a PL/SQL procedure. The procedure was executed successfully, and the following outcomes were obtained:
- The [SEARCH_BY] procedure was executed with the input parameter [IN_UAN] set to '100025699245.'
- The procedure retrieved data from the UAN_REPOSITORY table based on the provided UAN value.
- The retrieved data includes the UAN, NAME, GENDER, AADHAAR, DOB, and MARITAL_STATUS for the specified UAN.
I have attached the screenshot of results of the execution of a PL/SQL procedure[SEARCH_BY].
- % Done changed from 90 to 100
- Status changed from In Progress to Closed
Also available in: Atom
PDF
