Hello weili, Suppose If i want select all from select many item option then what I have to change in query ?
@Haalfl6 күн бұрын
Thank you for your work Please, Thank you for your work Please, How to integrate technoriver smartcode with Oracle Apex?
@skamransajjad79 күн бұрын
Beautiful work.....
@weililiu21197 күн бұрын
Thanks a lot 😊
@wendyliu522118 күн бұрын
I have never seen this topic covered anywhere else. Thanks for sharing this. It's really helpful.
@weililiu211918 күн бұрын
Glad it was helpful!
@Najeeb_khan19 күн бұрын
Good effort keep it up
@weililiu211919 күн бұрын
Thank you
@yakaka119 күн бұрын
i have subscribed as well.
@yakaka119 күн бұрын
I havent seen such development like this. Great.
@weililiu211919 күн бұрын
Thank you
@yakaka120 күн бұрын
Good work.
@weililiu211919 күн бұрын
Thank you! Cheers!
@Equality447721 күн бұрын
@weili liu ....I had one requirement....can you help me ? I need to accept only CSV-UTF 8 file format only . How can I give that validation in Oracle Apex while uploading the file. I mean only CSV-UTF 8 format files need to be accepted not any other file formats(including CSV)
@weililiu211920 күн бұрын
I will consider it if I am available. Thank you for your interest.
@Equality447720 күн бұрын
@@weililiu2119 Thank you for responding. ❤️
@weililiu21197 күн бұрын
@@Equality4477 Sorry to respond you late. My recommended way is you can prompt user to specify the charset set when you upload the file on the page. Oracle APEX or PL/SQL can't get the charset of uploaded file because the file type is blob so far.
@Equality44777 күн бұрын
@@weililiu2119 thank you so much for taking time to work this issue. Thank you so much for remembering and texting back. As far as now , I am using this method(message for users). Thanks alot once again.👍🏻
@aliallamy-yh5igАй бұрын
You solve this issue better than ChatGPT
@weililiu2119Ай бұрын
Thanks for your compliment and interest.😊
@mirzasanowerhosen123Ай бұрын
Your tutorial is so nice. I need a solution can you help me? During creating a customer invoice, I want to set some default invoice items for apex collections. These items will differ customer to customer. I want to set this items in the customer table so that when I select old cutomer, invoice items will insert in the invoice items list. How can i do this ?
@weililiu2119Ай бұрын
There are a couple of ways to solve it. I believe there is customer_id connecting the 2 tables 'customer_invoice' and 'customer'. When you select customer, you should pass the parameter customer_id to pxx_customer_id (pxx is page number) in the invoice page. Assume in your invoice page there are some items from the customer table such as customer_name, customer_email, customer_location etc. First, you should have the page item pxx_customer_id, pxx_customer_name, pxx_customer_email, pxx_customer_location etc. Then go to the page item property pane, 'Default', 'Type' :SQL Query(return single value) , write SQL statement: 'select customer_name from customer where customer_id=:pxx_customer_id'. Similarly, this way is also appliable for other items like customer_email, customer_location etc. This is one way, hope it can help you. Thank you for you interested my channel.
@brunopascoalbpАй бұрын
Thanks for sharing!
@weililiu2119Ай бұрын
Thanks for watching!
@appmake9791Ай бұрын
Thank you, your contents are great and helpful. I suggest you improve the sound quality, more people will find these tutorials very useful. Sound improvement will be great for this channel. I am already subscribed to this channel. Thank you.
@weililiu2119Ай бұрын
Thank you for your advice, I hope you will see a brand-new me in my next video😊
@jeanchristianahikpa5561Ай бұрын
Thanks for sharing, we also need the integration of AI vision, document understanding in APEX please .
@weililiu2119Ай бұрын
Thank you for you advice, I will do that if I am available😊, I appreciate you like my video and topic.
@jeanchristianahikpa5561Ай бұрын
@@weililiu2119 great!
@ahmedashraf3199Ай бұрын
can you make a vedio how can i edit a card or delete it from a card region or classic report with template cards?
@weililiu2119Ай бұрын
Card or class report region is different from the template component type about the checkbox selection. I will do that in my future video. Thank you😊
@ThiagoPeresQueirozАй бұрын
wow, great explain for this subject
@ahmedashraf3199Ай бұрын
after i reset from the gmail the login page open> after i sign in again > it crashes the error i have provided in the prev comment please help me
@weililiu2119Ай бұрын
Can you send me a screenshot to my email [email protected]? Thank you
@ahmedashraf3199Ай бұрын
is this vedio need any service need money ?
@weililiu2119Ай бұрын
It’s free
@kookin247Ай бұрын
You are awesome. thanks
@aqibahmed7118Ай бұрын
Getting error ora-01722 invalid line number while uploading csv file. Please help
@weililiu2119Ай бұрын
I will check it
@weililiu21197 күн бұрын
I guess that your source file format cause this error.
@edwinyulianto3660Ай бұрын
Thanksss
@weililiu2119Ай бұрын
If you'd like to get the code , you can go to the GitHub and get source github.com/Cherryweili/Oracle-APEX-Custom-Authentication.git Thanks🙂
@fouad_alshamyАй бұрын
Thank you Lady
@ferrinsonfranco72142 ай бұрын
Hello Weili, thank you very much for your teachings. I did not understand why the values sent in the parameters of the "Set Items" section using the Button option: "Redirect to Page in this Application" are not the same values existing in the session state, and what makes it necessary to use one of the other 2 alternatives that you explain. Thank you so much !!!
@weililiu21192 ай бұрын
Because 'Redirect to Page in this Application' doesn't request and pass the parameter to the server, and in page 12, I used dynamic action to get the value of original salary, current salary which are in the client side, not in server. Session is only stored in the server side, so we should submit the page to get the new session value. Hope it is helpful for your future developing. Thank you for asking.
@ferrinsonfranco72142 ай бұрын
@@weililiu2119 Thank you Weili
@gokulb80292 ай бұрын
In the login screen I'm getting an error says : ORA-06550 line 4, wrong number or types of arguments in call to 'DUP2_VALIDATE_USER_PASSWORD' My function is : create or replace FUNCTION dup2_validate_user_password ( P9999_USERNAME IN VARCHAR2, P9999_PASSWORD IN VARCHAR2) RETURN BOOLEAN IS l_password VARCHAR2(1000); l_stored_password VARCHAR2(1000); l_count NUMBER; BEGIN -- Check if the username and password match a record in your database table SELECT COUNT(*) INTO l_count FROM APX_EMPL_DTL WHERE UPPER(USERNAME) = UPPER(P9999_USERNAME); --AND HASHED_PASSWORD = NRM_ENCRYPT( P9999_PASSWORD ); -- If a record is found, return TRUE; otherwise, return FALSE IF l_count > 0 THEN SELECT HASHED_PASSWORD into l_stored_password FROM APX_EMPL_DTL WHERE UPPER(USERNAME) = UPPER(P9999_USERNAME); l_password := NRM_ENCRYPT( P9999_PASSWORD ); IF l_password = l_stored_password THEN RETURN TRUE; ELSE RETURN FALSE; END IF; END IF; END ; Can you please guide me , how to solve the error in my case!😢
@weililiu21192 ай бұрын
1). You can use V_USERNAME, V_PASSWORD as arguments instead of P9999_USERNAME, P9999_PASSWORD in the function DUP2_VALIDATE_USER_PASSWORD like below: create or replace FUNCTION dup2_validate_user_password ( V_USERNAME IN VARCHAR2, V_PASSWORD IN VARCHAR2) RETURN BOOLEAN IS l_password VARCHAR2(1000):=' '; l_stored_password VARCHAR2(1000):=' '; l_count NUMBER:=0; ... END; Then you can call the function DUP2_VALIDATE_USER_PASSWORD( :P9999_USERNAME, :P9999_PASSWORD) in your application. 2) In the function , declare variable, I add default value because you used sql like 'select ... into ...' Hope it can help you. Thank you for asking.
@ilyesbenmalti94022 ай бұрын
I have a problem where a button with behavior set to redirect to a page in this app doesn't redirect me to a page, can you tell me how to fix this isssue please
@weililiu21192 ай бұрын
You can go to the button Behavior setting: Behavior: Action: Redirect to URL Target: apex.oracle.com/pls/apex/f?p=132071 (This is the app which you want to redirect) Hope it can help you.
@aryanchoudhary16552 ай бұрын
Mail check your mail ASAP
@aryanchoudhary16552 ай бұрын
Please check your email mam
@weililiu21192 ай бұрын
Please check your email
@PMNDEV2 ай бұрын
When i am entering first row value as 4.00 and second row value as 1,25,000.00 it's showing wrong value instead of 1,25,004.00
@weililiu21192 ай бұрын
I think the code should modify a little. It should use ‘parseFloat’ to ensure the number has 2 decimals. Thank for your question.
@PMNDEV2 ай бұрын
Thank you for your reply
@PMNDEV2 ай бұрын
Can we validate row level entry in IG and restrict the add row process
Thankyou for this but I want control on add row or validation on add row...means new add will not perform if previous row's column is empty ....like that check the validation on click add row button @@weililiu2119
@HamdyFleafel2 ай бұрын
Thank you Weili Liu!!! Can you help me I want to know how to integrate oracle apex with technoriverstudio?
@weililiu21192 ай бұрын
I will see and try. Thanks
@danilocacoango11122 ай бұрын
THANKS
@SuryaLakshmanan-t7d3 ай бұрын
Thank You Please u can explain about all the new features kindly
@weililiu21192 ай бұрын
I’ll prepare for it
@Mafatlaal3 ай бұрын
Thank you so much!! You saved my day!!!!! Most sincerely appreciate you creating this great tutorial! Please continue the good work.
@weililiu21193 ай бұрын
Glad it helped!
@BinuKP-m3q3 ай бұрын
Is it possible to take sum of 2 columns from 2 different region?
@weililiu21193 ай бұрын
Yes. I will post a new video about this. I'd like to know if you have business requirement about this? Usually we sum columns in one report. Thank you for your question
@BinuKP-m3q3 ай бұрын
@@weililiu2119 Thank you for replying , i will explain .For eg: i have 2 Interactive grid A and B .Interactive grid A have “salary” column and interactive grid B have “increment column” ,i need to take the sum of these 2 columns and show in interactive grid B as "total" column. how can i achieve this ?
@weililiu21193 ай бұрын
@@BinuKP-m3q Thank you for your explanation. I'd like to know you just sum the 2 columns without modifying(just reading) rather than sum the 2 columns when the 2 columns change? Usually what we do, get the salary cell value when IG row is selected to the page item and put the page item as hidden, then when I select one row in the report B, sum the page item and 'increment column' value to the column 'Total'.
@julioprous49163 ай бұрын
Thank you Weili Liu!!! You've helped me a lot!!!
@sjn38883 ай бұрын
Hi, good video and knowledge. here I have one question. in mail ur sending url to change password is same for all. if any one can get that url can change and hack the application. So what's the security.
@weililiu21193 ай бұрын
I modified the function request_rest_password in package MTL_AUTH_PKG, APEX_UTIL.PREPARE_URL ( p_url IN VARCHAR2, p_url_charset IN VARCHAR2 default null, p_checksum_type IN VARCHAR2 default null, p_triggering_element IN VARCHAR2 default 'this') RETURN VARCHAR2; P_checksum_type: Null or any of the following six values, SESSION or 3, PRIVATE_BOOKMARK or 2, or PUBLIC_BOOKMARK or 1. I added the session in URL and changed p_checksum_type from 1 to 2 If p_checksum_type=2, then we can use this value when you want to generate a private link that will only be available to you. It’s associated with the currently authenticated user. /****************** before zero session for pubilc user *****************/ l_url := apex_util.prepare_url(p_url => c_hostname||'f?p='||v('APP_ID')||':31:0::::P31_USER_ID,P31_VC:' || l_id || ',' || l_verification_code, p_checksum_type => 1); /*****************modify: session for the authenticated user ***********/ l_url := apex_util.prepare_url(p_url => c_hostname||'f?p='||v('APP_ID')||':31:'||v('APP_SESSION')||'::::P31_USER_ID,P31_VC:' || l_id || ',' || l_verification_code, p_checksum_type => 2);
@84msamy3 ай бұрын
How to Automatically decrement from a predefined number when you click the Add Row button in the interactive grid in Oracle APEX... ex, specifying a specific number in a cell, then when adding a new row, it gives us a warning that it is not possible to put a number higher than the specified “fixed” number... Or show the remaining number from the process of subtracting the previously fixed number from the rows entered later, until a new entry is not accepted if the value of zero is reached from the fixed number. thank you
@weililiu21193 ай бұрын
I will try it. Thank for asking
@84msamy3 ай бұрын
How to Automatically decrement from a predefined number when you click the Add Row button in the interactive grid in Oracle APEX... ex, specifying a specific number in a cell, then when adding a new row, it gives us a warning that it is not possible to put a number higher than the specified “fixed” number... Or show the remaining number from the process of subtracting the previously fixed number from the rows entered later, until a new entry is not accepted if the value of zero is reached from the fixed number. thank you
@weililiu21192 ай бұрын
Please take a look: kzbin.info/www/bejne/mqu8aZyCmsmgkLc
@84msamy3 ай бұрын
How to Automatically decrement from a predefined number when you click the Add Row button in the interactive grid in Oracle APEX... thank you
@weililiu21193 ай бұрын
I will consider and do it. Thanks for your question.
@nicknack57433 ай бұрын
My you prepare a video showing dynamic storing and reading of images from the file system rather storing in database and the reading
@weililiu21193 ай бұрын
I will consider it. Thanks for your question.
@62224533 ай бұрын
国人apex 教程。 👍 可不可以出个怎么用js 添加css
@weililiu21193 ай бұрын
好的,我会考虑,谢谢
@bhavinadhvaryu85494 ай бұрын
Really nice blog...thank you for sharing
@weililiu21194 ай бұрын
Thank you🙂
@MuhammadHaseeb-t8r4 ай бұрын
Please check your email
@weililiu21194 ай бұрын
Have sent it. Please check your email. Thank you for your interest
@oussamalagnadi12842 ай бұрын
@@weililiu2119 Please check your email
@leandrogueths73914 ай бұрын
hello @weililiu211, I send a question for your email.
@weililiu21194 ай бұрын
It seemed that I didn’t receive your email. My email:[email protected]
@weililiu21194 ай бұрын
Respond via email. Please your email. Thank you for interest.
@hamzamansuri79134 ай бұрын
Thank you for this video! The step-by-step guidance and clear explanations were very helpful.
@19_Wish4 ай бұрын
I love your videos.
@JoachimForster-jy3gp4 ай бұрын
tank you for the video !, can you please share the code ? package ? 🙏
@@weililiu2119 I sent a email for you to ask about your video badge list.
@eleyaskhandakar3 ай бұрын
@@weililiu2119 Please add it in description or in comment section.
@mohamedlaminebenchikh50094 ай бұрын
Thank you for sharing.
@ashivagireesh27284 ай бұрын
Thanks for the session ,It really helped a lot
@ahmedharoon27404 ай бұрын
very nice for beginners like me... what about if i have all item's static id and use specific style(s) for specific item, how i can refer them in inline CSS ? thanks.