Overview of Microsoft Azure Cloud Services Introduction to Cloud Computing: Briefly discuss cloud computing and how Azure fits into the market of cloud service providers. Core Services of Azure: Cover…
Read MoreNotes: Database oemdb is created via dbca Non-CDB database is created (PDB is also supported for repository database) Redo Log file size should be minimum 300 MB After database is…
Read MoreIntroduction/ Issue: CSV blob file to raw file move from database table blob column to database directory. Why we need to do / Cause of the issue: We can move from blob to raw CSV file from database table blob column to database directory. How do we solve: Step 1: Create one database procedure PROCEDURE P_FILE_TO_DBSER (p_blob IN BLOB, p_dir IN VARCHAR2, p_filename IN VARCHAR2) AS l_file UTL_FILE.FILE_TYPE; l_buffer RAW(32767); l_amount BINARY_INTEGER := 32767; l_pos INTEGER := 1; l_blob_len INTEGER; BEGIN l_blob_len := DBMS_LOB.getlength(p_blob); — Open the destination file. l_file := UTL_FILE.fopen(p_dir, p_filename,’wb’, 32767); — Read chunks of the BLOB and write them to the file until complete. WHILE l_pos <= l_blob_len LOOP DBMS_LOB.read(p_blob, l_amount, l_pos, l_buffer); UTL_FILE.put_raw(l_file, l_buffer, TRUE); l_pos := l_pos + l_amount; END LOOP; — Close the file. UTL_FILE.fclose(l_file); …
Read MoreIntroduction/ Issue: CSV file move from client local machine to database table blob column. Why we need to do / Cause of the issue: We can store the CSV file from client local machine to database table blob column. How do we solve: Step 1: Create new table in database CREATE TABLE TB_FILE_UPLOAD (ID NUMBER, FILE_DATA BLOB); Step 2: Create new sequence in database CREATE SEQUENCE FILE_UPLOAD_SEQ START WITH 1 MAXVALUE 999999999999999999999999999 MINVALUE 1 INCREMENT BY 1 NOCYCLE CACHE 20 NOORDER NOKEEP GLOBAL; Step 3: In oracle form builder create on button and write the below code in WHEN-BUTTON-PRESSED trigger. DECLARE v_seq number; v_file_path varchar2(500) := ‘C:\test_file.csv’; v_bool boolean; BEGIN SELECT FILE_UPLOAD_SEQ .NEXTVAL INTO v_seq FROM DUAL; INSERT INTO TB_FILE_UPLOAD (ID, file_data) VALUES (v_seq, NULL); IF v_file_path IS NOT NULL THEN…
Read MoreNotes: 1.Deployment of agent from within OEM failed with SSH check.2.Manually deploy the agent by downloading the agent image from OMS and then perform a silent installation using a response…
Read MoreIntroduction PostgreSQL, a robust and popular open-source relational database system, employs a sophisticated mechanism called Multi-Version Concurrency Control (MVCC) to ensure data integrity and high concurrency. While MVCC enhances performance,…
Read MoreIntroduction When selecting a managed PostgreSQL database service on AWS, developers face a crucial choice between Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL. Both offerings provide robust solutions for…
Read MoreIntroduction: – This document is about how to hierarchical iframe error message clearance in Oracle APEX. When working with Oracle APEX applications, especially those that incorporate embedded iFrames to load…
Read MoreIntroduction: – This document is about how to customize calendar using APEX API in Oracle APEX. FullCalendar5 is a powerful JavaScript library for displaying and managing event calendars on web…
Read MoreData Recovery Advisor feature helps in diagnosing and repairing data failures. It will automatically diagnose the issue and provides the recommendation for the repair that helps to resolve the data…
Read More