Skip to Main Content

Questions

QuestionUpdatedAsked

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...
30 hours ago4 days 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...
31 hours ago2 days 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--##################################...
37 hours ago3 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...
37 hours ago48 hours 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...
39 hours ago4 days 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...
39 hours ago23.5 years 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...
39 hours ago4 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-------...
39 hours ago12 months 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...
39 hours 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...
2 days ago2 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 ...
4 days ago4 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...
4 days ago18.9 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...
4 days ago8.5 years ago

I would like, if exist documentation for distribution from dev to prod environment ??REgardsEduardo...
4 days ago3 weeks ago

Hi Tom,Suppose I am having following SQL queryUPDATE TB38OSET G000KE =(SELECT TB39G.A6000D FROM TB39G WHERE TB39G.A0020C = TB38O.A020KF AND TB39G.A0090C = TB38O.A090KF AND TB39G.A1010Y = TB38O.B010KF AND TB39G.A6000Y = TB38O.G000KF AND TB39G.A0230Z = TB38O.A23...
5 days ago19 years ago

Hello,I have following task. We have one big partitioned table and need to move some partition to backup database. The idea was to run in backup database<code>insert into table1_BCK select * from table1@dblink partition (abc) </code>And after insert drop sourc...
5 days ago5 weeks ago

Oracle 19 server cloud vm and from my laptop I am able to connect to the same database using sql developer tool . And I have installed oracle 19 client on my laptop and intention is to connect oracle from python script. when I tried to connect database using ...
5 days ago3 weeks ago

Dear all, I would like to download files from file server and view it in oracle apex. Till now I am unable to do so.I have been able to export file, uploaded from a page oracle apex to file server but I would like also to do the other way round i.e. to read fi...
5 days ago3 weeks ago

Hi Team, Hope you are having a great day. I would like to clarify some doubts regarding the oracle certification as well as SQL language. I have decided to take the oracle certification but have a few doubts regarding the exam. Here are the questions. Where sh...
8 days ago3 months ago

Hi Tom1. I have an Update statement which is taking too long It has a co-related subquery. How can I optimize it ?2. This SQL also has a WHERE EXISTS clause, if I remove this will the columns that fail the join be set to null ?thanksVivek ...
8 days ago24.4 years ago