muje data insert karne mai YEH problem aa rahi ha
BUTTON K OPER YEH CODING KI HA BUS SIMPLE DATA INSERT KARNA HA TABLE MAI
EGIN
IF :NAME IS NOT NULL THEN
INSERT INTO EXTERNAL (NAME, DESIGNATION, ADDRESS, NTN, MOBILE_NO)
VALUES (:NAME, ESIGNATION, :ADDRESS, :NTN, :MOBILE_NO);
MESSAGE ('1 RECORD WAS INSERTED');
ELSE
MESSAGE ('YOU NEED TO SPECIFY A VALID NAME');
END IF;
EXCEPTION
WHEN DUP_VAL_ON_INDEX THEN
MESSAGE ('A RECORD WITH THIS NAME ALREADY EXISTS');
END;
BEGIN
COMMIT_FORM;
END;
Record ko insert karne k lye ha bhai. agar mai koi ghalti kar raha hu to plz muje samja dain mehbani ho gi aap ki.
SIMPLE METHOD BATA DAIN JAB CURSOR SAVE K BUTTON PAR ENTER PRESS KARAIN TO RECORD SAVE HO JAY.
SHUKRIA.
AAP SE ORACLE SEKHNE MAI INSHALLAH BHT MADAD MILAY GI.
g aisa hi kia aur record save ho gaya ha thanks
aur sath mai yeh b likha ha
commit;
clear_form;
is tarha se form b clear ho gaya HA.
Bookmarks