Skip to Main Content

Questions

QuestionUpdatedAsked

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 ago7.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 ago12 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 ago1.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 ago4.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 ago23.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 ago6.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 ago14.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 ago3.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 ago10 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 ago6 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 ago11 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 ago10 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 ago12 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 ago12 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 ago1 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 ago23.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 ago11 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 ago12 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 ago19 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 ago8.5 years ago