For creating n level of dynamic navigation we required first data in JSON format.
Code base i will upload here.. including CSS and JS Complete code reference.
Working Code bundle is (Due to Code CSS application design is completed vanished ignore for outer design) Click Here for
Source Code and Preview is availble below
I found very good article here please visit here.
https://stackoverflow.com/questions/16626735/how-to-loop-through-an-array-containing-objects-and-access-their-properties
select round(sum(used.bytes) / 1024 / 1024 / 1024 ) || ' GB' "Database Size"
, round(sum(used.bytes) / 1024 / 1024 / 1024 ) -
round(free.p / 1024 / 1024 / 1024) || ' GB' "Used space"
, round(free.p / 1024 / 1024 / 1024) || ' GB' "Free space"
from (select bytes
from v$datafile
union all
select bytes
from v$tempfile
union all
select bytes
from v$log) used
, (select sum(bytes) as p
from dba_free_space) free
group by free.p;
SELECT version FROM V$INSTANCE; --11.2.0.1.0
SELECT * from PRODUCT_COMPONENT_VERSION; -- Get detailed version
SELECT * from dba_data_files ; --Get Physical file
SELECT * from V$SESSION Where Status='KILLED'; -- Get Oracle connected sessio list
SELECT * from V$SQL ;-- Get All Executed Query details
GRPC service is work when user/developer don't want make customer to ideal when during long data pulling from API/Rest server. on this case ideally on websites we shows a loader or ask for wait to customer. Tippically on webservice/ API/ Rest all client services will not respond untill server side process complete. but on gRPC there is an advantage we can get the data into chunk.
On gRPC when data is iterating on server side still we can get the row by row/ chunk of data recevied from gRPC service and that application can shows on front end.
I learned the same on you tube "https://www.youtube.com/watch?v=CcbwRBT8vnI"
Sample Code i have prepared for my testing purpose and uploaded the same on my drive. Click here to download if readmade code you want.
1. Get Table Size and Rows Details
select * from user_tables where table_name = 'TBL_XXXXXXXX'
2.
using System.Data.OleDb;
protected DataSet ReadExcel()
{
// Create a DataSet which will hold the data extracted from the worksheet.
DataSet ds = new DataSet();
string xls = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\murdhusi\Desktop\Mails\Data_29062022.xlsx;Extended Properties=Excel 8.0";
string xlsx = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\murdhusi\Desktop\Mails\Data_29062022.xlsx;Extended Properties=Excel 12.0";
string connString = xlsx;
// Create the connection object
OleDbConnection oledbConn = new OleDbConnection(connString);
try
{
// Open connection
oledbConn.Open();
// Create OleDbCommand object and select data from worksheet Sheet1
OleDbCommand cmd = new OleDbCommand("SELECT * FROM [Export Worksheet$]", oledbConn);
// Create new OleDbDataAdapter
OleDbDataAdapter oleda = new OleDbDataAdapter();
oleda.SelectCommand = cmd;
// Fill the DataSet from the data extracted from the worksheet.
oleda.Fill(ds, "Employees");
return ds;
}
catch
{
}
finally
{
// Close connection
oledbConn.Close();
}
return ds;
}
While Insert data into another varible some case if datanot available then we get an error on Oracle so take care that case we need to write a query like this.
Sample Procedure
create or replace
PROCEDURE "SPROC_VAULT_TEMP"
(
l_RECORDSET OUT TYPES.cursor_type,
l_ACTION in varchar2 DEFAULT null,
l_Vault_No_New in varchar2 DEFAULT null,
l_Vault_TKN_No in varchar2 DEFAULT null
)
As
l_PanNumber varchar2(100) default '';
l_Vault_No_Old varchar2(100) default '';
Begin
If l_ACTION = 'SelectById' Then
BEGIN
Select pan_number, vault_ref_aadhaar into l_PanNumber, l_Vault_No_Old from tbl_step1
Where vault_ref_aadhaar_old is null And uid_token = l_Vault_TKN_No;
Exception
WHEN TOO_MANY_ROWS then OPEN l_RECORDSET FOR Select 'Too Many Rows in that' from dual;
WHEN NO_DATA_FOUND then OPEN l_RECORDSET FOR Select 'No Data Found' from dual;
WHEN others then OPEN l_RECORDSET FOR Select 'No Other Issue' from dual;
END;
if l_PanNumber IS NOT NULL then
Update tbl_step1 Set vault_ref_aadhaar = l_Vault_No_New, VAULT_REF_AADHAAR_OLD = l_Vault_No_Old
Where uid_token is not null And uid_token = l_Vault_TKN_No;
Update tbl_aadhar Set UID_ID = l_Vault_No_New , UID_ID_OLD = UID_ID
Where pannumber = l_PanNumber;
Commit;
OPEN l_RECORDSET FOR Select 'True' from Dual;
Else
OPEN l_RECORDSET FOR
Select l_Vault_TKN_No ,l_PanNumber from dual;
end if;
end if;
End;
