Plamen Mushkov

Plamen Mushkov

@apexapplab.dev

Creating apps built with ❤️ using Oracle APEX. PL/SQL dev. Keen on new tech. Sports person. Oracle ACE ♠️ Blogging at http://blog.apexapplab.dev

364 followers212 following74 posts

Plamen Mushkov reposted

Oracle ACE Program
@oracleace.bsky.social

🚀 We’re excited to announce a brand-new entry path to the Oracle ACE Program: ACE Apprentice—launching at Oracle AI World! ♠️ The ACE Apprentice level is designed to kickstart your journey as an Oracle advocate and unlock your potential within the global community. 🔒 🔑 💻 👉 ace.oracle.com/apprentice

Plamen Mushkov
@apexapplab.dev

⚠️ Remember to fix your APEX applications Social Sign-in settings! The free APEX evaluation service is now moved to oracleapex.com. Which means that all of your applications, using Social Sign-in with Google, Office365, OKTA, etc. will fail unless you change the redirect URL in your SSO provider.

Plamen Mushkov reposted

Talan - Oracle Technologies
@oracletechtalan.bsky.social

Insum is now officially Talan- Catch up on the latest APEX + Oracle updates, events, tools, and team news in our newest newsletter → www.linkedin.com/pulse/meet-t... #orclapex

linkedin.comMeet Talan – Powered by the Oracle Experts You KnowIn case you missed it, we’ve got some exciting news—Insum is now officially Talan. We’ve taken on the business unit for all things Oracle Technologies within the Talan Group! After three years as…
Plamen Mushkov
@apexapplab.dev

On my way back home from APEX Alpe Adria in Zagreb 🇭🇷 Amazing sessions as you can expect and lots of things that I learned yesterday. But most importantly - great atmosphere, community and fun at the afterparty 🍻 Thanks to the organisers and to everyone who came to my session 👍 A little overview: ⤵️

View full thread
Plamen Mushkov
@apexapplab.dev

We got a great overview of the capabilities of the new SQLcl Project feature. No better person to present it than @apexconsulting.nl - one of the first to use it for his CI/CD pipeline in production! In my opinion - the way APEX (and database) versioning and deployment will be done in the future 💡

Plamen Mushkov
@apexapplab.dev

On my way back home from APEX Alpe Adria in Zagreb 🇭🇷 Amazing sessions as you can expect and lots of things that I learned yesterday. But most importantly - great atmosphere, community and fun at the afterparty 🍻 Thanks to the organisers and to everyone who came to my session 👍 A little overview: ⤵️

Plamen Mushkov
@apexapplab.dev

Great introduction by @msewtz.bsky.social! Focus on AI with lots of features now available in APEX, such as Vector Search, RAG and APEX Assistants. And of course - an introduction to the much needed APEX Lang, that should be available in the next releases 💡 ⤵️

Plamen Mushkov reposted

Kris Rice
@krisrice.io

Here's the video of APEXLang that Mike Hichwa showed in his talk this morning at #APEXWorld2025 The is massive potential here from easier ci/cd to code reviews to AI trained on the language to tooling as we'll publish the grammar behind when it launches

Plamen Mushkov reposted

Chris Saxon
@chrisrsaxon.bsky.social

APEX Lang is a new domain specific language you will be able to use to define Oracle APEX apps This is a human readable language designed to help you build and manage apps faster #apexworld2025 #orclapex

Plamen Mushkov
@apexapplab.dev

The time has come - you can now upgrade your APEX instances in the Oracle Cloud Autonomous Database to 24.2 🎉 Together with the 23ai database release (available already) - a killer combo in the AI era 🤝 🤖 #orclAPEX #ATP #OCI

Plamen Mushkov
@apexapplab.dev

Just had to migrate some of my connections from SQL Developer to VS Code (SQL Developer extension). Very easy and straightforward: 🔸 Right-click the top-level Oracle Connections node in SQL Developer’s Connections panel. 🔸 Select Export Connections and choose the connections to migrate ... ⤵️

Plamen Mushkov
@apexapplab.dev

🔸 Protect the export file with a password to encrypt sensitive credentials. Save the file (e.g., SQLDev-connections.json) to a location on your machine. Ensure SQLcl version 23.3 or later is installed. This is bundled with both SQL Developer and the VS Code extension. ⤵️

Plamen Mushkov
@apexapplab.dev

While in VS Code, open a Terminal window and launch SQLcl in nolog mode: ▶️ sql /nolog Then store the export file’s password in SQLcl’s secret manager: ▶️ secret set myExportPass MyExportPassword Import the JSON file: ▶️ connmgr import -key myExportPass /path/to/SQLDev-connections.json 🎉🎉🎉

Plamen Mushkov
@apexapplab.dev

Okay, this is cool: project config -list -verbose Gives you description of all setting, available in the project.config.json file 💡

Dan McGhan@dmcghan.bsky.social

Hi Patrizia, firstly, thanks for reporting the issues you found in the SQLcl Forum. Have you tried running: project config -list -verbose Perhaps there'll be an equivalent in the doc some day, but that command is your best bet for now.

Plamen Mushkov
@apexapplab.dev

Having fun with SQLcl - few observations: 🔸 For some reason I had a package that was exported using .pkb and .pks for the body and spec. After I upgraded to the latest version, I now have the package duplicated in my repository, because both files are exported with .sql extension. ... continues ⤵️

View full thread
Plamen Mushkov
@apexapplab.dev

Well, also remove the Release lines from the /dist/releases/main.changelog.xml file. For example, remove this line for release 1.1.0 ⤵️ <include file="1.1.0/release.changelog.xml" relativeToChangelogFile="true"/>

Plamen Mushkov
@apexapplab.dev

Having fun with SQLcl - few observations: 🔸 For some reason I had a package that was exported using .pkb and .pks for the body and spec. After I upgraded to the latest version, I now have the package duplicated in my repository, because both files are exported with .sql extension. ... continues ⤵️

Plamen Mushkov
@apexapplab.dev

🔸 I need to delete a release that I have just created. There is no command to do that. Only way is to manually delete the release folder and artifact. But it's not all - if you have used the "!git tag" option (ex. !git tag release-1.1.0), SQLcl will still check for existing tags ... ⤵️

Plamen Mushkov
@apexapplab.dev

... and would not allow reusing the 1.1.0 release number. Here are a few tips - use "!git tag" to list all existing tags. If you see the one that you want gone - use "!git tag -d release-1.1.0". Note: use the tag name exactly as listed - "release-1.1.0" in this case. Any comment and suggestion? 💡

Plamen Mushkov
@apexapplab.dev

Yes, updating the SQLcl version on my macbook is THAT simple: 🔸 Download the latest version archive 🔸 Extract to a folder (like sqlcl_new) 🔸 Rename your existing sqlcl folder (like sqlcl_old) 🔸 Rename sqlcl_new folder to sqlcl 🔸 Restart any open Terminal 🔸 plamen$ sql -v 🔸 SQLcl: Release 24.4.1.0 🎉

Plamen Mushkov reposted

SQLDaily
@sqldaily.bsky.social

AI Vector Search in Oracle Database 23ai enables semantic searches using vectors But how do you generate the vectors? Mark Hornick covers bring your own model options ML models made using Python & R Loading ONNX format models LLMs via Select AI

buff.lybuff.ly
Plamen Mushkov
@apexapplab.dev

A must-read about CI/CD in the database and the new Project feature of SQLcl💡 #sqlcl #Project #cicd

Dan McGhan@dmcghan.bsky.social

My first blog post in years: An Overview of the Oracle SQLcl Projects Development Process danmcghan.hashnode.dev/an-overview-... #orclAPEX

danmcghan.hashnode.devAn Overview of the Oracle SQLcl Projects Development ProcessSQLcl Projects is a new feature of SQLcl that aims to standardize and streamline the development lifecycle of Oracle Database applications. This post provides a high level overview of what the develop...