| RedStack | https://redstack.dev/ |
|
| https://redstack.dev/ |
| Skip to content | https://redstack.dev#content |
| Home | https://redstack.wordpress.com/ |
| About | https://redstack.dev/about/ |
| Old content | https://redstack.dev/old-content/ |
| BPM | https://redstack.dev/bpm/ |
| BPM 10g | https://redstack.dev/bpm/bpm-10g/ |
| BPM 11g | https://redstack.dev/bpm/bpm-11g/ |
| DevOps | https://redstack.dev/continuous-integration/ |
| SOA SDLC | https://redstack.dev/old-content/soa/ |
| Worklist | https://redstack.dev/old-content/worklist/ |
| in .Net | https://redstack.dev/old-content/worklist/in-net/ |
| ← Older posts | https://redstack.dev/page/2/ |
| Using Reflection to Help LLMs Write Better SQL | https://redstack.dev/2025/11/12/using-reflection-to-help-llms-write-better-sql/ |
| November 12, 2025 | https://redstack.dev/2025/11/12/using-reflection-to-help-llms-write-better-sql/ |
| Mark Nelson | https://redstack.dev/author/markxnelson/ |
| Uncategorized | https://redstack.dev/category/uncategorized/ |
| Leave a comment | https://redstack.dev/2025/11/12/using-reflection-to-help-llms-write-better-sql/#respond |
| Using Multiple Datasources with Spring Boot and Spring Data JPA | https://redstack.dev/2025/10/30/using-multiple-datasources-with-spring-boot-and-spring-data-jpa/ |
| October 30, 2025 | https://redstack.dev/2025/10/30/using-multiple-datasources-with-spring-boot-and-spring-data-jpa/ |
| Mark Nelson | https://redstack.dev/author/markxnelson/ |
| https://github.com/markxnelson/spring-multiple-jpa-datasources | https://github.com/markxnelson/spring-multiple-jpa-datasources |
| https://github.com/markxnelson/spring-multiple-jpa-datasources | https://github.com/markxnelson/spring-multiple-jpa-datasources |
| Uncategorized | https://redstack.dev/category/uncategorized/ |
| cloud | https://redstack.dev/tag/cloud/ |
| data-source | https://redstack.dev/tag/data-source/ |
| Java | https://redstack.dev/tag/java/ |
| spring-boot | https://redstack.dev/tag/spring-boot/ |
| technology | https://redstack.dev/tag/technology/ |
| tutorial | https://redstack.dev/tag/tutorial/ |
| UCP | https://redstack.dev/tag/ucp/ |
| Leave a comment | https://redstack.dev/2025/10/30/using-multiple-datasources-with-spring-boot-and-spring-data-jpa/#respond |
| Custom vector distance functions in Oracle (using JavaScript) | https://redstack.dev/2025/10/20/custom-vector-distance-functions-and-hybrid-vector-search-in-oracle-using-javascript/ |
| October 20, 2025 | https://redstack.dev/2025/10/20/custom-vector-distance-functions-and-hybrid-vector-search-in-oracle-using-javascript/ |
| Mark Nelson | https://redstack.dev/author/markxnelson/ |
| Oracle Database 26ai was announced last week at Oracle AI World | https://www.oracle.com/news/announcement/ai-world-database-26ai-powers-the-ai-for-data-revolution-2025-10-14/ |
| this LinkedIn post from Anders Swanson | https://www.linkedin.com/posts/anders-swanson_new-in-oracle-database-238-custom-distance-activity-7331715978537422848-U4ES |
| https://redstack.dev/wp-content/uploads/2025/10/image-5.png |
| https://redstack.dev/wp-content/uploads/2025/10/image-7.png |
| Oracle SQL Developer for VS Code | https://www.oracle.com/database/sqldeveloper/vscode/ |
| Visual Studio Code | https://code.visualstudio.com/ |
| Python | https://marketplace.visualstudio.com/items?itemName=ms-python.python |
| Jupyter | https://marketplace.visualstudio.com/items?itemName=ms-toolsai.jupyter |
| https://redstack.dev/wp-content/uploads/2025/10/image-8.png |
| https://redstack.dev/wp-content/uploads/2025/10/image-9.png |
| Uncategorized | https://redstack.dev/category/uncategorized/ |
| ai | https://redstack.dev/tag/ai/ |
| artificial-intelligence | https://redstack.dev/tag/artificial-intelligence/ |
| jaccard | https://redstack.dev/tag/jaccard/ |
| javascript | https://redstack.dev/tag/javascript/ |
| llm | https://redstack.dev/tag/llm/ |
| mle | https://redstack.dev/tag/mle/ |
| oracle | https://redstack.dev/tag/oracle/ |
| rag | https://redstack.dev/tag/rag/ |
| technology | https://redstack.dev/tag/technology/ |
| vector-search | https://redstack.dev/tag/vector-search/ |
| Leave a comment | https://redstack.dev/2025/10/20/custom-vector-distance-functions-and-hybrid-vector-search-in-oracle-using-javascript/#respond |
| Let’s make a simple MCP tool for Oracle AI Vector Search | https://redstack.dev/2025/10/08/lets-make-a-simple-mcp-tool-for-oracle-ai-vector-search/ |
| October 8, 2025 | https://redstack.dev/2025/10/08/lets-make-a-simple-mcp-tool-for-oracle-ai-vector-search/ |
| Mark Nelson | https://redstack.dev/author/markxnelson/ |
| this earlier post | https://redstack.dev/2025/05/23/basic-retrieval-augmented-generation-with-oracle-vector-store-in-langchain/ |
| here | https://modelcontextprotocol.io/docs/tools/inspector |
| https://redstack.dev/wp-content/uploads/2025/10/image-1.png |
| https://redstack.dev/wp-content/uploads/2025/10/image-2.png |
| https://redstack.dev/wp-content/uploads/2025/10/image-3.png |
| https://redstack.dev/wp-content/uploads/2025/10/image-4.png |
| Uncategorized | https://redstack.dev/category/uncategorized/ |
| ai | https://redstack.dev/tag/ai/ |
| artificial-intelligence | https://redstack.dev/tag/artificial-intelligence/ |
| llm | https://redstack.dev/tag/llm/ |
| mcp | https://redstack.dev/tag/mcp/ |
| rag | https://redstack.dev/tag/rag/ |
| technology | https://redstack.dev/tag/technology/ |
| 1 Comment | https://redstack.dev/2025/10/08/lets-make-a-simple-mcp-tool-for-oracle-ai-vector-search/#comments |
| Exploring securing vector similarity searches with Real Application Security | https://redstack.dev/2025/10/08/exploring-securing-vector-similarity-searches-with-real-application-security/ |
| October 8, 2025 | https://redstack.dev/2025/10/08/exploring-securing-vector-similarity-searches-with-real-application-security/ |
| Mark Nelson | https://redstack.dev/author/markxnelson/ |
| Real Application Security | https://docs.oracle.com/en/database/oracle/oracle-database/23/dbfsg/indroducing-oracle-database-real-application-security.html |
| the last post | https://redstack.dev/2025/05/23/basic-retrieval-augmented-generation-with-oracle-vector-store-in-langchain/ |
| Uncategorized | https://redstack.dev/category/uncategorized/ |
| ai | https://redstack.dev/tag/ai/ |
| artificial-intelligence | https://redstack.dev/tag/artificial-intelligence/ |
| rag | https://redstack.dev/tag/rag/ |
| ras | https://redstack.dev/tag/ras/ |
| security | https://redstack.dev/tag/security/ |
| technology | https://redstack.dev/tag/technology/ |
| Leave a comment | https://redstack.dev/2025/10/08/exploring-securing-vector-similarity-searches-with-real-application-security/#respond |
| Basic Retrieval Augmented Generation with Oracle Vector Store in LangChain | https://redstack.dev/2025/05/23/basic-retrieval-augmented-generation-with-oracle-vector-store-in-langchain/ |
| May 23, 2025 | https://redstack.dev/2025/05/23/basic-retrieval-augmented-generation-with-oracle-vector-store-in-langchain/ |
| Mark Nelson | https://redstack.dev/author/markxnelson/ |
| this earlier post | https://redstack.dev/2025/05/16/getting-started-with-oracle-vector-store-support-in-langchain/ |
| Retrieval-Augmented Generation for Knowledge-Intensive NLP Tasks | https://arxiv.org/abs/2005.11401 |
| https://redstack.dev/wp-content/uploads/2025/05/image-1.png |
| https://redstack.dev/wp-content/uploads/2025/05/image-3.png |
| https://redstack.dev/wp-content/uploads/2025/05/image-2.png |
| the previous post | https://redstack.dev/2025/05/16/getting-started-with-oracle-vector-store-support-in-langchain/ |
| https://www.gutenberg.org/cache/epub/2701/pg2701.txt | https://www.gutenberg.org/cache/epub/2701/pg2701.txt |
| https://www.gutenberg.org/cache/epub/2701/pg2701-images.html | https://www.gutenberg.org/cache/epub/2701/pg2701-images.html |
| LangChain model documentation | https://python.langchain.com/docs/integrations/chat/ |
| the previous post | https://redstack.dev/2025/05/16/getting-started-with-oracle-vector-store-support-in-langchain/ |
| Document Loaders | https://python.langchain.com/docs/integrations/document_loaders/ |
| this page | https://python.langchain.com/docs/how_to/split_html/ |
| https://www.gutenberg.org/cache/epub/2701/pg2701-images.html | https://www.gutenberg.org/cache/epub/2701/pg2701-images.html |
| https://redstack.dev/wp-content/uploads/2025/05/image-4.png |
| https://redstack.dev/wp-content/uploads/2025/05/image-5.png |
| https://redstack.dev/wp-content/uploads/2025/05/image-6.png |
| Uncategorized | https://redstack.dev/category/uncategorized/ |
| ai | https://redstack.dev/tag/ai/ |
| artificial-intelligence | https://redstack.dev/tag/artificial-intelligence/ |
| langchain | https://redstack.dev/tag/langchain/ |
| llm | https://redstack.dev/tag/llm/ |
| python | https://redstack.dev/tag/python/ |
| rag | https://redstack.dev/tag/rag/ |
| technology | https://redstack.dev/tag/technology/ |
| 2 Comments | https://redstack.dev/2025/05/23/basic-retrieval-augmented-generation-with-oracle-vector-store-in-langchain/#comments |
| Getting started with Oracle Vector Store support in LangChain | https://redstack.dev/2025/05/16/getting-started-with-oracle-vector-store-support-in-langchain/ |
| May 16, 2025 | https://redstack.dev/2025/05/16/getting-started-with-oracle-vector-store-support-in-langchain/ |
| Mark Nelson | https://redstack.dev/author/markxnelson/ |
| Visual Studio Code | https://code.visualstudio.com/ |
| Python | https://marketplace.visualstudio.com/items?itemName=ms-python.python |
| Jupyter | https://marketplace.visualstudio.com/items?itemName=ms-toolsai.jupyter |
| https://platform.openai.com/settings/organization/api-keys | https://platform.openai.com/settings/organization/api-keys |
| https://redstack.dev/wp-content/uploads/2025/05/image.png |
| Uncategorized | https://redstack.dev/category/uncategorized/ |
| ai | https://redstack.dev/tag/ai/ |
| artificial-intelligence | https://redstack.dev/tag/artificial-intelligence/ |
| langchain | https://redstack.dev/tag/langchain/ |
| llm | https://redstack.dev/tag/llm/ |
| oracle | https://redstack.dev/tag/oracle/ |
| rag | https://redstack.dev/tag/rag/ |
| semantic-search | https://redstack.dev/tag/semantic-search/ |
| vector-store | https://redstack.dev/tag/vector-store/ |
| 1 Comment | https://redstack.dev/2025/05/16/getting-started-with-oracle-vector-store-support-in-langchain/#comments |
| Running Oracle Autonomous Database in a container | https://redstack.dev/2025/04/25/running-oracle-autonomous-database-in-a-container/ |
| April 25, 2025 | https://redstack.dev/2025/04/25/running-oracle-autonomous-database-in-a-container/ |
| Mark Nelson | https://redstack.dev/author/markxnelson/ |
| this content on YouTube | https://youtu.be/izCPuXTRVwQ |
| https://localhost:8443/ords/apex | https://localhost:8443/ords/apex |
| https://localhost:8443/ords/sql-developer | https://localhost:8443/ords/sql-developer |
| https://redstack.dev/wp-content/uploads/2025/04/image.png |
| https://redstack.dev/wp-content/uploads/2025/04/image-1.png |
| https://redstack.dev/wp-content/uploads/2025/04/image-2.png |
| Oracle SQL Developer | https://www.oracle.com/database/sqldeveloper/ |
| SQLcl | https://www.oracle.com/database/sqldeveloper/technologies/sqlcl/ |
| https://redstack.dev/wp-content/uploads/2025/04/image-3.png |
| Uncategorized | https://redstack.dev/category/uncategorized/ |
| ADB | https://redstack.dev/tag/adb/ |
| autonomous | https://redstack.dev/tag/autonomous/ |
| container | https://redstack.dev/tag/container/ |
| database | https://redstack.dev/tag/database/ |
| oracle | https://redstack.dev/tag/oracle/ |
| oracle-database | https://redstack.dev/tag/oracle-database/ |
| ORDS | https://redstack.dev/tag/ords/ |
| sql | https://redstack.dev/tag/sql/ |
| Leave a comment | https://redstack.dev/2025/04/25/running-oracle-autonomous-database-in-a-container/#respond |
| How to read the content of a JMS message using PL/SQL | https://redstack.dev/2023/05/26/how-to-read-the-content-of-a-jms-message-using-pl-sql/ |
| May 26, 2023 | https://redstack.dev/2023/05/26/how-to-read-the-content-of-a-jms-message-using-pl-sql/ |
| Mark Nelson | https://redstack.dev/author/markxnelson/ |
| this post | http://rwijk.blogspot.com/2009/02/whats-in-my-jms-queue.html |
| Uncategorized | https://redstack.dev/category/uncategorized/ |
| JMS | https://redstack.dev/tag/jms/ |
| oracle | https://redstack.dev/tag/oracle/ |
| springboot | https://redstack.dev/tag/springboot/ |
| TEQ | https://redstack.dev/tag/teq/ |
| txeventq | https://redstack.dev/tag/txeventq/ |
| Leave a comment | https://redstack.dev/2023/05/26/how-to-read-the-content-of-a-jms-message-using-pl-sql/#respond |
| Vote for my session at VMWare Explore (Spring track)! | https://redstack.dev/2023/05/16/vote-for-my-session-at-vmware-explore-spring-track/ |
| May 16, 2023 | https://redstack.dev/2023/05/16/vote-for-my-session-at-vmware-explore-spring-track/ |
| Mark Nelson | https://redstack.dev/author/markxnelson/ |
| #SpringBoot | https://www.linkedin.com/feed/hashtag/?keywords=springboot&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A7064215586200801280 |
| #VMwareExplore | https://www.linkedin.com/feed/hashtag/?keywords=vmwareexplore&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A7064215586200801280 |
| https://lnkd.in/eiRi-YF7 | https://lnkd.in/eiRi-YF7 |
| https://redstack.dev/wp-content/uploads/2023/05/vmware-promo-card-vote-now.png |
| here | https://www.vmware.com/explore/us.html?src=so_f86geqw9zknh7&cid=7012H000000wtgQQAQ |
| here | https://oracle.github.io/microservices-datadriven/spring/ |
| Uncategorized | https://redstack.dev/category/uncategorized/ |
| Spring | https://redstack.dev/tag/spring/ |
| springboot | https://redstack.dev/tag/springboot/ |
| vmwareexplore | https://redstack.dev/tag/vmwareexplore/ |
| Leave a comment | https://redstack.dev/2023/05/16/vote-for-my-session-at-vmware-explore-spring-track/#respond |
| ← Older posts | https://redstack.dev/page/2/ |
| Installing Oracle REST Data Services (standalone) | https://redstack.dev/2022/05/17/installing-oracle-rest-data-services/ |
| Getting started with the new observability exporter for Oracle database | https://redstack.dev/2022/09/27/getting-started-with-the-new-observability-exporter-for-oracle-database/ |
| Development environment setup for Spring Boot with Oracle | https://redstack.dev/2022/12/08/development-environment-setup-for-spring-boot-with-oracle/ |
| Using JMS in .Net Applications | https://redstack.dev/2009/12/22/using-jms-in-net-applications/ |
| Running Oracle Autonomous Database in a container | https://redstack.dev/2025/04/25/running-oracle-autonomous-database-in-a-container/ |
| Installing Oracle XE database on 64-bit Ubuntu | https://redstack.dev/2010/06/09/installing-oracle-xe-database-on-64-bit-ubuntu/ |
| Worklist | https://redstack.dev/old-content/worklist/ |
| Log rotation for WebLogic Server (and friends) | https://redstack.dev/2013/02/27/log-rotation-for-weblogic-server-and-friends/ |
| How to tell if the SOA Platform is running | https://redstack.dev/2014/01/16/how-to-tell-if-the-soa-platform-is-running/ |
| Click here to subscribe using RSS | https://redstack.dev/feed |
| Building a Custom BPM Worklist | https://redstack.files.wordpress.com/2011/08/building-a-custom-worklist.pdf |
| Performance Tuning for Oracle Business Process Management Suite 10g | http://www.oracle.com/technetwork/middleware/bpm/learnmore/bpm10gperformancetuning-476208.pdf |
| Performance Tuning for Oracle Business Process Management Suite 11g | http://www.oracle.com/technetwork/middleware/bpm/learnmore/bpm11gperftuning-1912340.pdf |
| http://www.packtpub.com/oracle-advanced-business-process-management-suite-11g/book |
| Fusion Middleware 12.1.2: Developing Applications with Continuous Integration | http://docs.oracle.com/middleware/1212/core/MAVEN/introduction.htm#MAVEN8755 |
| Fusion Middleware 12.1.3: Developing Applications with Continuous Integration | http://docs.oracle.com/middleware/1213/core/MAVEN/introduction.htm#MAVEN8755 |
| Continuous Delivery | http://goo.gl/q8cwgP |
|
RedStack | https://redstack.dev/ |
| Blog at WordPress.com. | https://wordpress.com/?ref=footer_blog |
|
RedStack | https://redstack.dev/ |
| Blog at WordPress.com. | https://wordpress.com/?ref=footer_blog |
|
Subscribe
| https://redstack.dev |
|
Subscribed
| https://redstack.dev |
|
RedStack | https://redstack.dev |
| Log in now. | https://wordpress.com/log-in?redirect_to=https%3A%2F%2Fr-login.wordpress.com%2Fremote-login.php%3Faction%3Dlink%26back%3Dhttps%253A%252F%252Fredstack.dev%252F2025%252F11%252F12%252Fusing-reflection-to-help-llms-write-better-sql%252F |
|
RedStack | https://redstack.dev |
|
Subscribe
| https://redstack.dev |
|
Subscribed
| https://redstack.dev |
| Sign up | https://wordpress.com/start/ |
| Log in | https://wordpress.com/log-in?redirect_to=https%3A%2F%2Fr-login.wordpress.com%2Fremote-login.php%3Faction%3Dlink%26back%3Dhttps%253A%252F%252Fredstack.dev%252F2025%252F11%252F12%252Fusing-reflection-to-help-llms-write-better-sql%252F |
|
Report this content | https://wordpress.com/abuse/?report_url=https://redstack.dev |
|
View site in Reader | https://wordpress.com/reader/feeds/166712425 |
| Manage subscriptions | https://subscribe.wordpress.com/ |
| Collapse this bar | https://redstack.dev |
|
| https://redstack.dev |
|
| https://redstack.dev |
| logged in | https://redstack.dev |
|
| https://redstack.dev |