Deterministic Functions in Oracle
Deterministic Functions in Oracle Overview A deterministic function in Oracle is a function that always returns the same result for the same input values and has no side effects.…
Read MoreRead permission on secondary replica in always-on AG
How to give read permission on secondary replica in always-on AG Purpose of Log shipping: Always On availability groups feature is a high-availability and disaster-recovery solution that provides an…
Read MorePermission on secondary database in loginshipping
How to give read permission on secondary server in log shipping Purpose of Log shipping: SQL Server Log shipping allows databases to automatically send transaction log backups from a…
Read MoreThe Art of Visual Storytelling in UX Design
The Art of Visual Storytelling in UX Design Introduction Visual storytelling has become essential in UX design in today’s fast-paced digital world. It’s about using design elements to convey a…
Read MoreCreating new VM in azure environment
Creating new VM in azure environment Title/ Description of the Process This process outlines the steps to manually or programmatically create a new Virtual Machine (VM) in Microsoft Azure. It…
Read MoreHow to Create a Fine Poster: A Quick Guide
How to Create a Fine Poster: A Quick Guide Introduction Posters are a powerful way to grab attention and communicate messages quickly. Whether you’re promoting an event, brand, or idea,…
Read MoreOverview of Microsoft Azure Cloud Services
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 MoreCreate the OEM Repository Database
Notes: 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 MoreBlob File Move From DB to Directory
Introduction/ 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 MoreFile Store From Client to DB
Introduction/ 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 More