Hi!I have two Users on a same Oracle Instance, APP and TRDP. The user APP is a third-party user and the TRDP is one of my own. So the APP user have a package (API) which receives three parameters and updates an internal table. During the processing of this pac... | 2 days ago | 7.8 years ago |
How do i create pluggable database in oracle linux <code>Enter user-name: sys as sysdbaEnter password: Connected to:Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for FreeVersion 23.5.0.24.07SQL> alter session set container=cdb$root;Ses... | 2 days ago | 12 days ago |
Dear Sirs,I'm using database version 19c and trying to set a filter on schema level before inserting into UNIFIED_AUDIT_TRAIL view.I tried these example policies but without success:<code>CREATE AUDIT POLICY test1 ACTIONS UPDATE ON <schemaname>.*WHEN 'INSTR(U... | 2 days ago | 1.7 years ago |
Before understand question mind I have one table with 3 columns one is id second is description and third is sql query, i created one Apex page with two region one is static region and one is Interactive Report Region. In Static region i have one select list ... | 3 days ago | 4.5 years ago |
Hello Tom,I have gone through with Oracle documentation and some of your article and question/Answer about High Water Mark. I am kind of confuced with HWM. According to my knowledge, "all Oracle segments have an upper boundary containing the data within the se... | 4 days ago | 23.5 years ago |
Hi Tom,I have been using your script as listed below to get the list of the file names in a directory and insert them into a global temporary table. Everything was working fine until last week I have upgraded my database to 12.2 and the script is no longer wo... | 4 days ago | 6.8 years ago |
In sqlplus called from Unix shell scripts, I'm trapping SQL errors via 'whenever sqlerror exit N' and OS errors via 'whenever oserror exit N'. However sqlplus errors (SP2 errors) are not trapped by either of these mechanisms, for example:<code>SQL> whenever sq... | 4 days ago | 14.6 years ago |
We have several existing Oracle Directories set up to allow reading CSV files that work fine, and a couple of them work OK to Write new files. I have been trying to add a new Directory definition pointing to a different path and cannot get it to work. I am i... | 6 days ago | 3.8 years ago |
Greetings,Mongo JSON/BSON provides what seem like two cool improvements:1.) Denormalization through embedding documents: https://www.mongodb.com/docs/manual/tutorial/model-embedded-one-to-many-relationships-between-documents/2.) Design patterns to optimize ac... | 6 days ago | 10 days ago |
I understand how to use the online pragma before the invocation of a subprogram that should be inline, but based on the Oracle documentation (https://docs.oracle.com/en/database/oracle/oracle-database/19/lnpls/plsql-optimization-and-tuning.html#GUID-2E78813E-C... | 6 days ago | 6 months ago |
I need to pass an array into parameter in a store procedure like this<code>--##############################################################################################-- P A C K A G E S P E C--##################################... | 9 days ago | 11 days ago |
I have consistent storage snapshot for oracle database. I want to restore the snapshot to a mount host and roll the archivelogs to a specific point-in-time or SCN. I always got error when trying to open the database on mount host. SQL> alter database open res... | 9 days ago | 10 days ago |
As a database developer, I try to ensure column names in tables are not named something like "TYPE", or "OWNER", or "PRIMARY". It seems redundant to a Java developer to add a column to a table that indicates the OWNER of a PRODUCT to a column named PRODUCT_OWN... | 10 days ago | 12 days ago |
Greetings,I recently heard that Oracle 23 will support JSON! I am excited about this since I have been taken away from supporting Oracle for the past three years to work on Mongo. As I have been working with Mongo, I’ve realized a few big weaknesses over... | 10 days ago | 12 days ago |
Hi TOM, We are planning on upgrading from Apex 22.1 to Apex 23.1. We are currently on Oracle 19c using Apex 22.2:SQL> <code>SELECT * FROM v$version;</code>BANNER--------------------------------------------------------------------------------BANNER_FULL-------... | 10 days ago | 1 years ago |
Dear Tom,Hi !Thanks for the previous answers.They were as perfect as always.Qust I have got around 50 .csv files (Excel files) containingsome data which needs to be imported into the related tablesin the database.I have a script which I am running from the com... | 10 days ago | 23.9 years ago |
Greetings,Has there been any performance comparison between Oracle 23 and Mongo 7 on saving and accessing JSON data? If yes, do you have a link to that test? Thanks,John... | 10 days ago | 11 days ago |
hi,i have a question regarding external table and macro'swe have an external table and and there are a couple of complex sql functions case, regexp, subst.. that i would 'hide' in a view, so we can reuse those expression in PLSQL.With a view a cannot pass the ... | 12 days ago | 12 days ago |
Hi Tom,We have a query which has to get a set of rows over the db link which has a CONTAINS predicate on a column of CLOB.E.g.There is a DB A and DB B with table T1( c1 varchar2(10),c2 clob) .I want to run a query from DB A using dblink on DB B to query T1 whi... | 12 days ago | 19 years ago |
Hi I am new to Oracle Advanced queues. I was trying to queue a message and dequeue it automatically using a stored proc. I am able to dequeue my messages by manually running my stored proc but even though this stored proc is added as subscriber, I was of the v... | 13 days ago | 8.5 years ago |