---
title: "#sqlcl articles | Hashnode"
description: "Explore 68 articles tagged #sqlcl on Hashnode. Tutorials, guides, and how-tos from the community."
url: "https://hashnode.com/tag/sqlcl"
---

Tag

# #sqlcl

68 posts · 1 followers

[John Scott](https://hashnode.com/@jes-dev) · [5d ago](https://hashnode.com/posts/generate-word-excel-and-powerpoint-from-oracle-sqlcl/6af735705584757c61ffb192)

### [Generate Word, Excel and PowerPoint from Oracle SQLcl](https://jes-dev.hashnode.dev/generate-word-excel-and-powerpoint-from-oracle-sqlcl?utm_source=hashnode&utm_medium=feed)

Integrate ETCH with Oracle SQLcl to generate Word, Excel and PowerPoint documents from your Oracle Database

9 min read · [jes-dev.hashnode.dev](https://jes-dev.hashnode.dev/generate-word-excel-and-powerpoint-from-oracle-sqlcl?utm_source=hashnode&utm_medium=feed)

[Plamen Mushkov](https://hashnode.com/@plamen9) · [Oct 14](https://hashnode.com/posts/oracle-26ai-assertions/6acf37891821fc662ea3d84c)

### [Oracle 26ai Assertions](https://blog.apexapplab.dev/oracle-26ai-assertions?utm_source=hashnode&utm_medium=feed)

A real use case that takes advantage of the DB Assertions feature

6 min read · [blog.apexapplab.dev](https://blog.apexapplab.dev/oracle-26ai-assertions?utm_source=hashnode&utm_medium=feed)

[1](https://hashnode.com/posts/oracle-26ai-assertions/6acf37891821fc662ea3d84c)

[Rafal Grzegorczyk](https://hashnode.com/@rgrzegorczyk) · [Sep 30](https://hashnode.com/posts/give-your-oracle-apex-apps-a-quality-boost-with-sqlcl-codescan/6abce015376209fe9144d4f4)

### [Give Your Oracle APEX Apps a Quality Boost with SQLcl CodeScan](https://rafal.hashnode.dev/give-your-oracle-apex-apps-a-quality-boost-with-sqlcl-codescan?utm_source=hashnode&utm_medium=feed)

If you’re building APEX apps, SQLcl 26.3 just gave you a powerful, built-in security and code quality checker. I’ve already written about using SQLcl CodeScan to analyze PL/SQL code for violations and

11 min read · [rafal.hashnode.dev](https://rafal.hashnode.dev/give-your-oracle-apex-apps-a-quality-boost-with-sqlcl-codescan?utm_source=hashnode&utm_medium=feed)

[Timo Herwix](https://hashnode.com/@timoherwix) · [Sep 4](https://hashnode.com/posts/building-my-oracle-apex-26-1-ai-playground-with-oracle-database-26ai-ords-sqlcl-codex-mcp-and-apexlang/6a9a665d0eadde34fd62898b)

### [Building my Oracle APEX 26.1 AI Playground with Oracle AI Database 26ai, ORDS, SQLcl, Codex, MCP and APEXlang](https://tm-apex.hashnode.dev/building-my-oracle-apex-26-1-ai-playground-with-oracle-database-26ai-ords-sqlcl-codex-mcp-and-apexlang?utm_source=hashnode&utm_medium=feed)

Introduction Over the last few days I wanted to build a personal Oracle APEX playground for experimenting with modern AI-assisted development workflows. My goal was simple: Oracle AI Database 26ai Fr

12 min read · [tm-apex.hashnode.dev](https://tm-apex.hashnode.dev/building-my-oracle-apex-26-1-ai-playground-with-oracle-database-26ai-ords-sqlcl-codex-mcp-and-apexlang?utm_source=hashnode&utm_medium=feed)

[Rafal Grzegorczyk](https://hashnode.com/@rgrzegorczyk) · [Aug 27](https://hashnode.com/posts/sqlcl-has-built-in-code-snippets-alias-command-because-you-can-t-remember-everything-right/6a8fd8833588b77ea61a07f0)

### [SQLcl has built-in code snippets (ALIAS command). Because you can't remember everything, right?](https://rafal.hashnode.dev/sqlcl-has-built-in-code-snippets-alias-command-because-you-can-t-remember-everything-right?utm_source=hashnode&utm_medium=feed)

How many times a day do you re-type the exact same SQL queries? Whether it is checking system time, finding out which employees earn way too much, or running a complex query to check active database s

3 min read · [rafal.hashnode.dev](https://rafal.hashnode.dev/sqlcl-has-built-in-code-snippets-alias-command-because-you-can-t-remember-everything-right?utm_source=hashnode&utm_medium=feed)

[Matt Mulvaney](https://hashnode.com/@lufcmattylad) · [Aug 24](https://hashnode.com/posts/apexlang-windows-add-this-one-git-setting/6a8c3dbdd9c33e404a998ad6)

### [APEXLang + Windows? Add this one Git setting](https://mattmulvaney.hashnode.dev/apexlang-windows-add-this-one-git-setting?utm_source=hashnode&utm_medium=feed)

Excited to play around with APEXLang or SQLcl Project? What are you going to do? Vibe Code some APEXLang Export / Import APEX apps Project Export your schema Sounds fun right? By the experiences

2 min read · [mattmulvaney.hashnode.dev](https://mattmulvaney.hashnode.dev/apexlang-windows-add-this-one-git-setting?utm_source=hashnode&utm_medium=feed)

[Matt Mulvaney](https://hashnode.com/@lufcmattylad) · [Jul 17](https://hashnode.com/posts/enhancing-sqlcl-terminal-in-vscode/6a59e199c0b456f86a0cac6b)

### [Enhancing SQLcl Terminal in VSCode](https://mattmulvaney.hashnode.dev/enhancing-sqlcl-terminal-in-vscode?utm_source=hashnode&utm_medium=feed)

If you use the SQL Developer for VS Code extension, it will install the latest version of SQLcl in VS Code. Sounds great... right!? Actually, no, not great. Why? For three reasons SQLcl starts in

8 min read · [mattmulvaney.hashnode.dev](https://mattmulvaney.hashnode.dev/enhancing-sqlcl-terminal-in-vscode?utm_source=hashnode&utm_medium=feed)

[Adrian Kur](https://hashnode.com/@adriankur) · [Jul 13](https://hashnode.com/posts/one-repo-many-schemas-making-sqlcl-aware-of-where-you-are/6a5527d16a05e63a8166dac8)

### [One Repo, Many Schemas: Making SQLcl Aware of Where You Are](https://milesofcode.hashnode.dev/one-repo-many-schemas-making-sqlcl-aware-of-where-you-are?utm_source=hashnode&utm_medium=feed)

Empowering SQLcl #1

6 min read · [milesofcode.hashnode.dev](https://milesofcode.hashnode.dev/one-repo-many-schemas-making-sqlcl-aware-of-where-you-are?utm_source=hashnode&utm_medium=feed)

[Rafal Grzegorczyk](https://hashnode.com/@rgrzegorczyk) · [Jun 24](https://hashnode.com/posts/how-to-securely-connect-mcp-to-the-database-using-oracle-db-26ai-and-sqlcl/6a3b727dc9fa54c2b5b09525)

### [How to securely connect MCP to the database (using Oracle DB 26AI and SQLcl) ?](https://rafal.hashnode.dev/how-to-securely-connect-mcp-to-the-database-using-oracle-db-26ai-and-sqlcl?utm_source=hashnode&utm_medium=feed)

What should we do to be sure of what AI can do using the SQLcl MCP server and what data is accessible to it? Are there any extra security precautions we could take in case AI go crazy? That's exactly

4 min read · [rafal.hashnode.dev](https://rafal.hashnode.dev/how-to-securely-connect-mcp-to-the-database-using-oracle-db-26ai-and-sqlcl?utm_source=hashnode&utm_medium=feed)

[Rafal Grzegorczyk](https://hashnode.com/@rgrzegorczyk) · [Jun 24](https://hashnode.com/posts/customise-sqlcl-using-an-auto-run-script-on-each-connection-set-it-and-forget-it/6a3b83711fc52884d6a72f98)

### [Customise SQLcl using an auto-run script on each connection. Set it and forget it!](https://rafal.hashnode.dev/customise-sqlcl-using-an-auto-run-script-on-each-connection-set-it-and-forget-it?utm_source=hashnode&utm_medium=feed)

In one of my latest blog posts about customising SQLcl, I promised to show how to set it up once and forever. What can we do instead of typing those commands each time? SQLcl allows you to set a s

4 min read · [rafal.hashnode.dev](https://rafal.hashnode.dev/customise-sqlcl-using-an-auto-run-script-on-each-connection-set-it-and-forget-it?utm_source=hashnode&utm_medium=feed)
