Feature #903
closedModule #882: Hands on & Code Familiarization
Sub module #883: UAN Repository - Record Update
Feature #884: Search UAN repository by UAN
DB logic - procedure/funcrions
100%
Files
Updated by Rasmiya R S almost 3 years ago
- Status changed from New to In Progress
Updated by Rasmiya R S almost 3 years ago
- % 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
Updated by Rasmiya R S almost 3 years ago
25-09-2023
In DB, Connected to the database EPFO-SQL.
Process exited. But Table is not showing. Resolving the issue.
Updated by Rasmiya R S almost 3 years ago
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].
Updated by Rasmiya R S almost 3 years ago
- Status changed from In Progress to Closed