Oracle Developers

Oracle Developers

Official channel from Oracle Developers. Here we share recorded conference sessions, tutorials, speaker interviews, announcements, and how-to's. Hear the best speakers, get insight into the future of Oracle technologies, and connect with the community. More information at developer.oracle.com


Cost Analysis in Oracle Cloud

Cost Analysis in Oracle Cloud

3 Tips to Help You Write Better SQL

3 Tips to Help You Write Better SQL

Real-time SQL Plan Management

Real-time SQL Plan Management

Пікірлер

  • @hewhointheearthlydomainsee1272
    @hewhointheearthlydomainsee127218 сағат бұрын

    I wish they were more programmable and configurable and modular. Like I wish I could create an AI brain that is tailored to the tasks at hand. Or dynamically so, so that its exactly what is required for the task and could potentially work in teams to complete a project, like maintain the Python base library set or make the libraries more efficient, and prevent dependency hell when developers don't maintain their libraries to keep up with each other.

  • @ptuhari
    @ptuhariКүн бұрын

    Super ! Thanx

  • @abhijitmane9949
    @abhijitmane99494 күн бұрын

    That's cool, Thanks for such wonderful info.

  • @SuryaVenkat-ne6hm
    @SuryaVenkat-ne6hm4 күн бұрын

    Thanks a lot Shay!

  • @Anonymous-or5hq
    @Anonymous-or5hq4 күн бұрын

    👍

  • @byte1964
    @byte19645 күн бұрын

    I was expecting to see a final MERGE statement to collapse the three DMLs into one, but I admit that the syntax of MERGE is a pain to remember, I always need to start from a sample statement because it's really hard to get it to work right away.

  • @TheMagicofSQL
    @TheMagicofSQL4 күн бұрын

    MERGE can only insert/update into one table. You can't use it when writing to different tables as in this example

  • @melikeertunc6093
    @melikeertunc60935 күн бұрын

    hi, Thanks for the video ! After installing Oracle Client, my date format was corrupted. I am getting "not a valid month" error in my SQL query in Excel. How can I change the date format of ocmt?

  • @OracleDOTNET
    @OracleDOTNET4 күн бұрын

    You can change the date format of what the Excel cells to expect to match the Oracle DB date format. You can also change the query executed so that it returns the date in the format Excel cells want, such as select to_date(date_column,'MM/DD/YYYY') from table;

  • @trevoro.9731
    @trevoro.97315 күн бұрын

    #1 Get money, buy Oracle, write better SQL.

  • @TheMagicofSQL
    @TheMagicofSQL4 күн бұрын

    The whole demo was run on Oracle Database Free, a resource-limited, fully featured version you can use for whatever you want for free. The principles apply whatever database you're using, the specifics will vary by platform though (e.g. SQL macros are only in Oracle Database)

  • @agusnurhalim9671
    @agusnurhalim96715 күн бұрын

    Very informative, and great tools. It will help a lot, if you can provide the link to slides used.

  • @Eao07001
    @Eao070015 күн бұрын

    Thanks. I am beginner. I am high motivated to learn more.

  • @AyubKhan-hd7yf
    @AyubKhan-hd7yf5 күн бұрын

    thanks Shay🎉

  • @RiteshKumar-jr8nc
    @RiteshKumar-jr8nc6 күн бұрын

    Is it like we can only use it in the new extension? Can we use the deployed fragment in the new application as well?

  • @oracledevs
    @oracledevs4 күн бұрын

    These are fragments to be used in AppUI extensions only.

  • @OracleCloudHub
    @OracleCloudHub6 күн бұрын

    Hi Harris, it was a very clear explanation, I am close follower of your videos in linkedin as well. Would like to know how I can implement the above logic for SOAP service call by my client who is use custom CRM application. The flow is CRM --> TIBCO -->(Soap Request call to OIC to get the item quantities and update in CRM). Your inputs are highly valueable

  • @oracledevs
    @oracledevs4 күн бұрын

    Hi! I recommend connecting with the speaker Harris Qureshi on LinkedIn on your questions.

  • @huppy1992
    @huppy19926 күн бұрын

    Really nice explanation.

  • @tothandras8160
    @tothandras81606 күн бұрын

    what a great presentation! Thank you! I felt just like back in uni, going to the low level what is behind things...

  • @loiclefevre8016
    @loiclefevre80166 күн бұрын

    Thanks for the kind words! I'm pleased to see it was useful.

  • @ArunkuttiMine
    @ArunkuttiMine7 күн бұрын

    What is the point of hiding all the things and making tutorial.?

  • @SwarnavaG_CODM
    @SwarnavaG_CODM7 күн бұрын

    Very helpful and clear tutorial Joel. Thanks

  • @ItsMrVD
    @ItsMrVD9 күн бұрын

    Why are we complicating simple things(Loop)?

  • @oracledevs
    @oracledevs11 күн бұрын

    Part 2: kzread.info/dash/bejne/m2itkqSzgLLMotY.html&t

  • @halah8348
    @halah834811 күн бұрын

    may i ask how did u migrate forms to oracle apex without the migration feature being there?

  • @simovilmunen7503
    @simovilmunen750312 күн бұрын

    This video was a lifesaver! I couldn't find any detailed info on OAuth and Factory APIs and we were struggling with the right setup, thank you!

  • @FillipePalmeroFritsch
    @FillipePalmeroFritsch12 күн бұрын

    how can i commit changes? didnt find it

  • @edwinyulianto3660
    @edwinyulianto366013 күн бұрын

    This video cannot be added to my playlist

  • @edwinyulianto3660
    @edwinyulianto366012 күн бұрын

    Thanks Oracle team. The "Save" button is available now.

  • @mayurpranav7
    @mayurpranav713 күн бұрын

    I could not understand how to mention the metadata for onnx model deployment. Can you give me an example with the titanic model you used?

  • @oracledevs
    @oracledevs12 күн бұрын

    Hi @mayurpranav7, please take a look at the documentation for Oracle Machine Learning Services on the ONNX model format specifications at docs.oracle.com/en/database/oracle/machine-learning/omlss/omlss/onnx_spec.html

  • @surajpatil9221
    @surajpatil922113 күн бұрын

    Vector Search.. Exciting ❤

  • @Reji012345
    @Reji01234514 күн бұрын

    if any one looking for resources for this video ? . It is available at 46.48 .

  • @abhishekjoseph6953
    @abhishekjoseph695314 күн бұрын

    this is really good !!, when we connect to OPEN AI/COHERE through the profile, is the actual database data shared with OPEN AI/COHERE ?

  • @swethareddy-u8v
    @swethareddy-u8v15 күн бұрын

    how to get update and insert rows count after merge in oracle

  • @TimusPrime
    @TimusPrime16 күн бұрын

    Does this require an additional license on top of Enterprise Edition?

  • @user-go7cd5kj5n
    @user-go7cd5kj5n13 күн бұрын

    According to oracle database feature apex, this feature don't need extra cost. But it is only available in Exadata/ExaCC and EE versions.

  • @mayurmehar9015
    @mayurmehar901517 күн бұрын

    Its good....but can we write a prompt to get our database(table) details, means when I write 'give number of users whose salary is greater than john' from my table, And i will get result accordingly...please Explain

  • @stefan_dobre
    @stefan_dobre12 күн бұрын

    We're currently working to make implementing such use cases easier. Until then, your best bet is to extend your system prompt with the data from your table. You can use substitution strings, a hidden page item, and the apex_data_export package to export your data as JSON or CSV. It's a very custom implementation though and your mileage may vary.

  • @venkatamaneswararaodudala2914
    @venkatamaneswararaodudala291418 күн бұрын

    Hello Sir, Nice session. is this the only way to extend the oracle applications or do we have any other way as well?, kindly confirm. Thank you.

  • @oracledevs
    @oracledevs12 күн бұрын

    For Redwood based modules the only way to modify them is with Visual Builder Studio.

  • @JavedIqbal-gv6zi
    @JavedIqbal-gv6zi18 күн бұрын

    I have installed apex 24.1 and used opena1 as AI provider and followed all the steps , but i get "Error" in respone using AI Assistant. what may be the cause of this problem

  • @stefan_dobre
    @stefan_dobre12 күн бұрын

    Enable debug mode, reproduce, and check the debug logs. You should see a more detailed error there. In most cases, the API key was entered wrong.

  • @dvvnreddy
    @dvvnreddy18 күн бұрын

    this (workspace utilities ->generative AI ) only for cloud version ? i installed latest apex on on-premesis.

  • @stefan_dobre
    @stefan_dobre12 күн бұрын

    Nope. It works on premises as well. Sure you installed version 24.1?

  • @javierAndino-tm7wf
    @javierAndino-tm7wf18 күн бұрын

    Excelente video visto a 1.5X

  • @krakajak67
    @krakajak6718 күн бұрын

    APEX just keeps leaping and bounding into the future. Awesome!

  • @stefan_dobre
    @stefan_dobre12 күн бұрын

    Yuhuu. Great to hear that!

  • @alexquintesderesende2041
    @alexquintesderesende204119 күн бұрын

    Muito bom! Outro nível, obrigado por compartilhar.

  • @ThiagoOliveira-ex3vw
    @ThiagoOliveira-ex3vw19 күн бұрын

    What source is recommended to learning APEX?

  • @akhlaqhossain
    @akhlaqhossain19 күн бұрын

    Is there an option for this AI to analyze the attached image?

  • @stefan_dobre
    @stefan_dobre12 күн бұрын

    As of APEX 24.1, attachments are not supported. Most AI providers and their adapters that do support attachments are still in Beta, e.g the Assistants API from OpenAI. We'll have to wait until these implementations are stable- then they can be further integrated in APEX.

  • @narendrakumar7398
    @narendrakumar739819 күн бұрын

    How to create auth function with multiple parameters.??

  • @karthikk-xw3rd
    @karthikk-xw3rd20 күн бұрын

    Very nice tool and excellent output report. Do we have option to run this script on particular compartment (eg: Prod ) resources alone to check this CIS benchmark.

  • @leonvanbirgelen4514
    @leonvanbirgelen451412 күн бұрын

    The security check is tenancy wide because many checks are not specific to a compartment, but the detailed output can be filtered to a specific compartment.

  • @pradeepraj9180
    @pradeepraj918020 күн бұрын

    Assanasnha jk

  • @vishveshjogalekar5092
    @vishveshjogalekar509220 күн бұрын

    If the keys are rotated OCID still remain the same, but new version is added, will OCI Vault connector pick the latest version ?

  • @ronakshah6336
    @ronakshah633620 күн бұрын

    it would be better to use Microsoft Power BI instead of using Oracle APEX, there are more functionality then ORACLE APEX

  • @nesdi6653
    @nesdi665321 күн бұрын

    data

  • @sudeepbisht6012
    @sudeepbisht601221 күн бұрын

    Will there be a feature of oracle managed oic3 DR just like ATP across regions?

  • @oracledevs
    @oracledevs5 күн бұрын

    Oracle recommends using OCI Full Stack DR. It is currently available for Oracle Integration Gen 2, not yet for Gen3. OCI Full Stack DR gives the customer the ability and flexibility to recover all necessary resources in the correct order, rather than relying on automated DR for individual resources only.

  • @VinhNguyen-eg5yr
    @VinhNguyen-eg5yr21 күн бұрын

    Hello everyone, could someone help me? I have the following issue: I booted the AVDF 20.9 image on my cloud environment: my OpenStack. I created 2 Audit Vault servers to configure HA, but when I created the connection, I discovered that these two servers have the same server certificate. Therefore, I couldn't configure it. I tried creating a new CA file to replace it in the path: /usr/local/dbfw/etc/, but I failed.

  • @VinhNguyen-eg5yr
    @VinhNguyen-eg5yr21 күн бұрын

    Hello everyone, could someone help me? I have the following issue: I booted the AVDF 20.9 image on my cloud environment: my OpenStack. I created 2 Audit Vault servers to configure HA, but when I created the connection, I discovered that these two servers have the same server certificate. Therefore, I couldn't configure it. I tried creating a new CA file to replace it in the path: /usr/local/dbfw/etc/, but I failed.

  • @igorsala
    @igorsala22 күн бұрын

    It was a pleasure to show how Natcorp is changing the game of HR Software using Oracle APEX and AI. Thank you Ashish!

  • @ganianu1819
    @ganianu181924 күн бұрын

    we can't imagin AI & ML existance in reality without Python thank you so much

  • @alevidaboa
    @alevidaboa24 күн бұрын

    Boa tarde, sou deve trabalho com plsql, queria ver se aqui consigo uma ajuda, preciso criar um app que fique esperando o envio de dados , qual material devo estudar para criar. Hoje criamos app em Delphi XE onde fica um executavel aberto e recebendo as requisições, mas queria passar isso pro oracle i possivel, o que estudar!