mCommits

-- fetch is used in explicit cursor to fetch data from table

CREATE TABLE EMP (
    ID NUMBER,
    NAME VARCHAR2(50)
);

INSERT INTO EMP (ID, NAME) VALUES (1, 'Alice');
INSERT INTO EMP (ID, NAME) VALUES (2, 'Bob');
INSERT INTO EMP (ID, NAME) VALUES (3, 'Charlie');

mCommits

`winget` is the Windows Package Manager, a command-line tool to manage software installations on Windows. It allows users 
to search, install, update, and uninstall applications from a central repository, similar to package managers on other 
operating systems like `apt` on Debian-based systems or `brew` on macOS.

How to Use `winget`

1. Install `winget`: `winget` comes pre-installed with Windows 10 (version 1809 and later) and Windows 11. If you don't have it, 
you can install it from the Microsoft Store by searching for "App Installer."

2. Search for Applications:

mCommits

CREATE TABLE EMPLOYEE (
    ID INT,
    F_NAME VARCHAR(50),
    L_NAME VARCHAR(50),
    DEPT VARCHAR(50),
    SALARY NUMBER(5),
    DOJ DATE,
    ADDRESS VARCHAR(100),
    Married CHAR(1)
);

mCommits

CREATE TABLE CLIENTS (
    CLIENTNO VARCHAR2(10),
    NAME VARCHAR2(50),
    CITY VARCHAR2(50),
    PINCODE VARCHAR2(10),
    STATE VARCHAR2(30),
    BALDUE NUMBER
);

INSERT INTO CLIENTS (CLIENTNO, NAME, CITY, PINCODE, STATE, BALDUE) VALUES ('C00001', 'Ivan Bayross', 'Mumbai', '400054', 'Maharashtra', 15000);

mCommits

CREATE TABLE Client_Master (  
    Client_No VARCHAR2(6),  
    Name VARCHAR2(20),  
    Address1 VARCHAR2(30),  
    Address2 VARCHAR2(30),  
    City VARCHAR2(15),  
    State VARCHAR2(15),  
    Pincode NUMBER(6),  
    Bal_Due NUMBER(10,2)  
);