Oracle DB Security : Execute encrypted SQL Files with a Wrapper around SQLPLUS/SQLcl and combine it with a SQL Firewall. Avoid PL/SQL for business logic! Use SQL, e.g. CTEs and generate your sql statements, check an execute them.
"Problem: I create a table in Oracle DB using Python and it works perfectly . But when I check the same table in SQL*Plus, it says ORA-00942: table or view does not exist "
do you know the solution ?
#OracleDB#Python#SQLPlus#DatabaseProblems
Some time ago, I've created myself a bat script that would run sqlplus and do the seed and publish in my dev.
It was always one or two clicks away.
Someone who is not working with the multilingual apps, doesn't understand this kind of frustration 😅
Just dropped what might be the first ever AI SQL Terminal Editor 🤯
👉 Online terminal experience
👉 No setup, no SQLPlus/MySQL pain
👉 AI-powered query generation
👉 Private PostgreSQL schema per user
Live: sqlplus.vercel.app/
Github: github.com/subhadeeproy3902/…#AI#SQL
I remember some of the Exadata stuff being really helpful early on (and the book doh!) and some performance stuff but one that I remember was the rlwrap stuff for sqlplus.
I think I got it from your blog(?) and then went and set it up everywhere 😂