Видео

call blackboard APIs from apex.... any video to call apis from apex

Sir when i try to save record showing msgora-00001 unique constraint violated in informatica. If i delete primary key all relationship will be fail. Kindly help me

Very helpful😍

Keep inspiring

very hepful video

wow very helpful session sir thanks a million

thank you for your efforts... I saw 2 topics in Oracle Apex forum for how to create and consume API's for master-detail data, is there any possibility we can create and consume API's for a master-detail data? I am struggling for it and not yet found any solution.

pl share the app to see the code, why our code is not working.

good.But please make a vedio on deployment of oracle project on client side with static IP address

Data not display in grid

Great work bro, very descriptive. After creating a region and selecting "STATIC CONTENT" as the type, I noticed that in the "Source" section, I don't have the "HTML Code" option available. In your video, I can see "HTML Code" is shown, but in my case, it only says "Text" with a space below to enter the script. I pasted the script as you demonstrated in the video, but the graph didn't display. I suspect you're using a more advanced version of APEX, which is why you have the "HTML Code" option. I'm currently using version 19 of APEX. Please do let me know what i did wrong. I am very fascinated with the work u did. i also want to copy that.

I have 10 lakh records in excel file what can i do? Possible using collection?

First of all thanks for answer to me. I check your code and it is not worked in my project. I want to share to my code. This code is working when they selected only 1 value from checkbox group. But I want to configure that for multiple checkbox values. I want to explain correctly my issue. More than 1 value can be inserted into the P4_CHEESE, P4_SEBZE, P4_ET, P4_TATLI, P4_MEYVE checkbox group, that is, the MATERIAL column in this code. For example, while there is only kashar insert; Kashar:cream:old data can also be inserted into this column. If a multiple insert comes first, these data must be separated from the : sign and inserted separately with v_price_malzeme, v_malzeme_dv and v_tip variables for each separated material. In other words, I want x material to be inserted into x number of rows, not into a single row. CODE: BEGIN -- Değişkenleri tanımlayın DECLARE v_fiyat_malzeme T_MALZEME.FIYAT_MALZEME%TYPE; v_malzeme_dv T_MALZEME.MALZEME%TYPE; v_tip_malzeme T_MALZEME.TIP_MALZEME%TYPE; BEGIN -- Ekmek için veri seç IF :P4_EKMEK IS NOT NULL THEN SELECT FIYAT_MALZEME, MALZEME, TIP_MALZEME INTO v_fiyat_malzeme, v_malzeme_dv, v_tip_malzeme FROM PBA_SND.T_MALZEME WHERE ID_MALZEME = :P4_EKMEK; INSERT INTO PBA_SND.T_SEPET (TIP_MALZEME, MALZEME, FIYAT_MALZEME, SECIM_MUSTERI, ADET) VALUES(v_tip_malzeme, v_malzeme_dv, v_fiyat_malzeme, 'Kendi Seçimin', :P4_ADET); END IF; -- Peynir için veri seç IF :P4_PEYNIR IS NOT NULL THEN SELECT FIYAT_MALZEME, MALZEME, TIP_MALZEME INTO v_fiyat_malzeme, v_malzeme_dv, v_tip_malzeme FROM PBA_SND.T_MALZEME WHERE ID_MALZEME = :P4_PEYNIR; INSERT INTO PBA_SND.T_SEPET (TIP_MALZEME, MALZEME, FIYAT_MALZEME, SECIM_MUSTERI, ADET) VALUES(v_tip_malzeme, v_malzeme_dv, v_fiyat_malzeme, 'Kendi Seçimin', :P4_ADET); END IF; -- Sebze için veri seç IF :P4_SEBZE IS NOT NULL THEN SELECT FIYAT_MALZEME, MALZEME, TIP_MALZEME INTO v_fiyat_malzeme, v_malzeme_dv, v_tip_malzeme FROM PBA_SND.T_MALZEME WHERE ID_MALZEME = :P4_SEBZE; INSERT INTO PBA_SND.T_SEPET (TIP_MALZEME, MALZEME, FIYAT_MALZEME, SECIM_MUSTERI, ADET) VALUES(v_tip_malzeme, v_malzeme_dv, v_fiyat_malzeme, 'Kendi Seçimin', :P4_ADET); END IF; -- Et için veri seç IF :P4_ET IS NOT NULL THEN SELECT FIYAT_MALZEME, MALZEME, TIP_MALZEME INTO v_fiyat_malzeme, v_malzeme_dv, v_tip_malzeme FROM PBA_SND.T_MALZEME WHERE ID_MALZEME = :P4_ET; INSERT INTO PBA_SND.T_SEPET (TIP_MALZEME, MALZEME, FIYAT_MALZEME, SECIM_MUSTERI, ADET) VALUES(v_tip_malzeme, v_malzeme_dv, v_fiyat_malzeme, 'Kendi Seçimin', :P4_ADET); END IF; -- Tatlı için veri seç IF :P4_TATLI IS NOT NULL THEN SELECT FIYAT_MALZEME, MALZEME, TIP_MALZEME INTO v_fiyat_malzeme, v_malzeme_dv, v_tip_malzeme FROM PBA_SND.T_MALZEME WHERE ID_MALZEME = :P4_TATLI; INSERT INTO PBA_SND.T_SEPET (TIP_MALZEME, MALZEME, FIYAT_MALZEME, SECIM_MUSTERI, ADET) VALUES(v_tip_malzeme, v_malzeme_dv, v_fiyat_malzeme, 'Kendi Seçimin', :P4_ADET); END IF; -- Meyve için veri seç IF :P4_MEYVE IS NOT NULL THEN SELECT FIYAT_MALZEME, MALZEME, TIP_MALZEME INTO v_fiyat_malzeme, v_malzeme_dv, v_tip_malzeme FROM PBA_SND.T_MALZEME WHERE ID_MALZEME = :P4_MEYVE; INSERT INTO PBA_SND.T_SEPET (TIP_MALZEME, MALZEME, FIYAT_MALZEME, SECIM_MUSTERI, ADET) VALUES(v_tip_malzeme, v_malzeme_dv, v_fiyat_malzeme, 'Kendi Seçimin', :P4_ADET); END IF; -- Değişiklikleri onayla COMMIT; EXCEPTION WHEN NO_DATA_FOUND THEN DBMS_OUTPUT.PUT_LINE('Veri bulunamadı.'); WHEN OTHERS THEN DBMS_OUTPUT.PUT_LINE('Bir hata oluştu: ' || SQLERRM); ROLLBACK; -- Hatada değişiklikleri geri al END; END;

I want to ask you something. I am inserting data from multiple values from checkbox group to Table. It is inserting like value1:value2 but I want to insert single row per one value. Like Insert INTO table(column) values(value1); Insert INTO table(column) values(value2); but it would be 5 piece value, it would be 0 piece value so it is need to be dynamic and insert one by one for each value. How can i do that can you help me about it ?

Js code

Sir Postman POS Api hai use Shopify se kaise connect kare

very nice video but u didnot give answer of MEMKUL How to set webcam ip address with APEX

Amazing tutorial, but I've a question about it. It works perfectly when I use a Excel with one worksheet. But when I need to get data from a EXCEL in another worksheet that it is not the first, I add p_xlsx_sheet_name => 'TAB_NAME' in the parameters for apex_data_parser.parse. But then i receive an error "Specified worksheet does not exist in XLSX file". I've check the worksheet name multiples times, tried other documents but can't get it to work with others worksheets outside of the first (by not using p_xlsx_sheet_name). Have you ever tried something like this and had success?

AXA ji

For mr Object type is empty & not taking any values, please guide me

11:52: The method of getting the max ID, or as you said, using a collection, is not the right way. Instead, as you are using a procedure, output the ID using a parameter and utilize it.

thank you bhai , your tutorial was so good

Aji hn😁

Hello! I have problem with .xls files it says "Uploaded file is invalid or has wrong extension". I need to pick both xlsx and xls files.

ORA-01536: space quota exceeded for tablespace 'APEX_BIGFILE_INSTANCE_TBS' getting error while submitting the data

Data is not showing in the Report. How to solve this issue

Can you provide a video of Razor Pay implementation Of QR code -Oracle Apex.

Brother Can you post Razor pay Implementation QR code

Great video very helpful. is there a way to make the pivot collapsible ?

Hello when I upload the excel file and click to populate on the interactive report, it does not show the data on the excel sheet

sir is p mujy tora help chayie please if you have time

give sample.xl data

PLEASE SEND LINK OF USER ROLE VIDEO I CANT FIND IT

file upoad hojata successfully lekin report display ni ho rha same query use krta ho

sir may ne save process follow kia pr report display ni ho rha

sir thank you ap ne mera kaam 0% solve to kr dya he pr ye report wala region may app ne query lekhi he wo app ne proper ni dekhaya

Nice tutorial ,But How load the xl data into table which is having more than 50 columns

I want update multiple rows. Data send as JSON. How can I do this?

Hi Buddy, Can you provide a video on phone pay integration with apex.

Really helpful 🎉

Content ✌

This tutorial will help many who want step by step knowledge 💪

Information 🥳

Sir, i have tried you process, but button is not calling the razorpay window, neither showing any error. Could you help me out.

You will have bigger subscriber if you cover in english

Thanks for the wonderful introduction of Shared Components

Congratulations to you. 🎊 🎉

Really appreciate for this level of content

Very Useful content Ravi Sir ji

Thank you very much for your complete tutorial