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 ago | 4 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 ago | 2 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 ago | 3 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 ago | 48 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 ago | 4 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 ago | 23.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 ago | 4 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 ago | 12 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 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... | 2 days ago | 2 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 ago | 4 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 ago | 18.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 ago | 8.5 years ago |
I would like, if exist documentation for distribution from dev to prod environment ??REgardsEduardo... | 4 days ago | 3 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 ago | 19 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 ago | 5 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 ago | 3 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 ago | 3 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 ago | 3 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 ago | 24.4 years ago |