{"id":141,"date":"2026-03-21T06:55:25","date_gmt":"2026-03-21T06:55:25","guid":{"rendered":"https:\/\/alpeshconnect.in\/blog\/?p=141"},"modified":"2026-03-21T07:01:58","modified_gmt":"2026-03-21T07:01:58","slug":"pl-sql-rdbms-practical-exam","status":"publish","type":"post","link":"https:\/\/alpeshconnect.in\/blog\/2026\/03\/21\/pl-sql-rdbms-practical-exam\/","title":{"rendered":"Distributor – PL\/SQL RDBMS Practical Exam"},"content":{"rendered":"\n

A). Create SQL table with primary key and foreign key with insert 5 records. Distributor : ( Dno,d_name,phno) Item : ( Item_no,Dno,item_name,qty,rate ) <\/p>\n\n\n\n

B). Pl\/sql block that accept distributor no and display its details with item details be distributes.<\/p>\n\n\n\n

<\/p>\n\n\n\n

A) Create tables with PK, FK and insert records<\/strong><\/h1>\n\n\n\n

Create Distributor table<\/strong><\/h3>\n\n\n\n
CREATE TABLE Distributor (
    Dno NUMBER PRIMARY KEY,
    d_name VARCHAR2(50),
    phno VARCHAR2(15)
);<\/pre>\n\n\n\n
Create Item table (with Foreign Key)<\/strong><\/h3>\n\n\n\n
CREATE TABLE Item (
    Item_no NUMBER PRIMARY KEY,
    Dno NUMBER,
    item_name VARCHAR2(50),
    qty NUMBER,
    rate NUMBER,
    CONSTRAINT fk_distributor
    FOREIGN KEY (Dno)
    REFERENCES Distributor(Dno)
);<\/pre>\n\n\n\n
\n\n\n\n
Insert 5 records into Distributor<\/strong><\/h3>\n\n\n\n
INSERT INTO Distributor VALUES (1, 'Raj Traders', '9876543210');
INSERT INTO Distributor VALUES (2, 'Shiv Supplies', '9123456780');
INSERT INTO Distributor VALUES (3, 'Om Distributors', '9988776655');
INSERT INTO Distributor VALUES (4, 'Krishna Agency', '9090909090');
INSERT INTO Distributor VALUES (5, 'Ganesh Traders', '9111222333');<\/pre>\n\n\n\n
\n\n\n\n
Insert 5 records into Item<\/strong><\/h3>\n\n\n\n
INSERT INTO Item VALUES (101, 1, 'Rice', 50, 60);
INSERT INTO Item VALUES (102, 2, 'Wheat', 40, 55);
INSERT INTO Item VALUES (103, 1, 'Sugar', 30, 45);
INSERT INTO Item VALUES (104, 3, 'Oil', 20, 120);
INSERT INTO Item VALUES (105, 4, 'Salt', 25, 20);<\/pre>\n\n\n\n
\n\n\n\n
B) PL\/SQL Block<\/strong><\/h1>\n\n\n\n
Accept distributor number and display distributor and item details<\/strong><\/h3>\n\n\n\n
SET SERVEROUTPUT ON;DECLARE
    v_dno Distributor.Dno%TYPE := &Enter_Distributor_No;
    
    -- Distributor details
    v_name Distributor.d_name%TYPE;
    v_phno Distributor.phno%TYPE;BEGIN
    -- Fetch distributor details
    SELECT d_name, phno
    INTO v_name, v_phno
    FROM Distributor
    WHERE Dno = v_dno;    DBMS_OUTPUT.PUT_LINE('Distributor Details:');
    DBMS_OUTPUT.PUT_LINE('Dno: ' || v_dno);
    DBMS_OUTPUT.PUT_LINE('Name: ' || v_name);
    DBMS_OUTPUT.PUT_LINE('Phone: ' || v_phno);    DBMS_OUTPUT.PUT_LINE(' ');
    DBMS_OUTPUT.PUT_LINE('Items Supplied:');    -- Loop through items
    FOR rec IN (
        SELECT Item_no, item_name, qty, rate
        FROM Item
        WHERE Dno = v_dno
    )
    LOOP
        DBMS_OUTPUT.PUT_LINE(
            'Item No: ' || rec.Item_no ||
            ', Name: ' || rec.item_name ||
            ', Qty: ' || rec.qty ||
            ', Rate: ' || rec.rate
        );
    END LOOP;EXCEPTION
    WHEN NO_DATA_FOUND THEN
        DBMS_OUTPUT.PUT_LINE('No distributor found with given number.');
END;
\/<\/pre>\n","protected":false},"excerpt":{"rendered":"
A). Create SQL table with primary key and foreign key with insert 5 records. Distributor : ( Dno,d_name,phno) Item : ( Item_no,Dno,item_name,qty,rate ) B). Pl\/sql block that accept distributor no and display its details with item details be distributes. A) Create tables with PK, FK and insert records Create Distributor table CREATE TABLE Distributor ( […]<\/p>\n","protected":false},"author":1,"featured_media":101,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,42],"tags":[25,26,43],"class_list":["post-141","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bca","category-concept-of-rdbms","tag-bca","tag-bca-paper-solution","tag-concept-of-rdbms"],"_links":{"self":[{"href":"https:\/\/alpeshconnect.in\/blog\/wp-json\/wp\/v2\/posts\/141","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/alpeshconnect.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/alpeshconnect.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/alpeshconnect.in\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/alpeshconnect.in\/blog\/wp-json\/wp\/v2\/comments?post=141"}],"version-history":[{"count":2,"href":"https:\/\/alpeshconnect.in\/blog\/wp-json\/wp\/v2\/posts\/141\/revisions"}],"predecessor-version":[{"id":144,"href":"https:\/\/alpeshconnect.in\/blog\/wp-json\/wp\/v2\/posts\/141\/revisions\/144"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/alpeshconnect.in\/blog\/wp-json\/wp\/v2\/media\/101"}],"wp:attachment":[{"href":"https:\/\/alpeshconnect.in\/blog\/wp-json\/wp\/v2\/media?parent=141"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/alpeshconnect.in\/blog\/wp-json\/wp\/v2\/categories?post=141"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/alpeshconnect.in\/blog\/wp-json\/wp\/v2\/tags?post=141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}