Skip to Main Content

Questions

QuestionUpdatedAsked

Let's say we have a table of documents with key of doc_id. This table contains millions of documents(rows). There is also a table that assigns one or more industry codes to each doc:create table doc_ind( doc_id integer, ind_code varchar2(10))This ta...
6 hours ago20 years ago

Hi Tom,On page 130-131 of your book, "expert one-on-one Oracle," you gave an example of two sessions querying and inserting into tables a and b. The result is that both tables contain a row with the value zero in them. My question is that wouldn't the result ...
6 hours ago19.5 years ago

Hi Tom,We are getting Intermittent Ora-06502: PL/SQL: numeric or value error - For Update Skip locked. This error occurs only when application (.Net) calls this SP and it occurs at last pending row from table. But we are able to execute same SP from TOAD succe...
9 hours ago5.1 years ago

Hi Ask Tom team,Do you have any information that CloneDB is not working anymore in 18c or 19c.I already have MOS-SR (SR 3-25408180791) open since march this year. First without any additional answers they told me that this is a bug (BUG 32087287 - ORA-17515...
9 hours ago2 months ago

hi tomcan u explain me in detail about "start with connect by" sql statement (tree structure).i know there is documentatin but it is very confusing. ...
9 hours ago20.5 years ago

Hello, I created a Flashback Data Archive and gave it a retention of one year. Now I have enabled flashback archive for a test table. My problem is that minvalue does not work as I expected. My expectation is that the specified query will return ALL values tha...
9 hours ago7 days ago

Hi TomFeels good to post a question after quite some time.Look at the following :SQL> desc dual Name Null? Type ----------------------------------------- -------- ---------------------------- DUMMY ...
13 hours ago20 years ago

I would need to replace the chr(10) or chr(13) from the string. However i would need to exclude those chr(10) or chr(13) in middle of the string.eg:(2S,4R)-1-{1-[(2-acetamido-2-deoxy-ß-D-[(3-{5-[(2-acetamido-2-deoxy-ß-Dgalactopyranosyl)oxy]pentanamido}5,11,1...
3 days ago6 days ago

I have a xml of size 52kb and need to remove namespaces from xml,below is the code im using which is working fine when xml was of 3-4 kb but when size increasedbelow is the error thrown is :is 19011. 00000 - "Character string buffer too small" *Cause: The ...
3 days ago2 years ago

Hi.We use to prepare extract file from oracle using extract script. There are few tables whose name gets change every month.Need to handle these table names dynamically.<code>SELECT TICKET_ID ,SOURCE_ID ,SERV_ID ,to_char(COLLECTED_DATE,'YY...
3 days ago4.1 years ago

Hi, Tom1.I always use dbms_utility.analyze_statistic('USER','COMPUTE') to create statistics for users schema. Is it creates statistics only for tables or for tables and indexes?Should I use ...(user,'COMPUTE','for all indexes') to compute statistics for indexe...
3 days ago20 years ago

Hi :)!I have a database @dblink and I need to copy files with BLOB from @dblink to my staging database.What can I do?I can't CREATE tables because of restrictions, so we only should use TRUNCATE, UPDATE and INSERT.Thank you so much in advance!...
4 days ago7 days ago

Is there a way to create a pdf in memory and save it in a blob?We don’t want to create a database directory and create the actual pdf on the server. So, I am looking for a way to create it in memory and insert it into a blob field using pl/sql or a database p...
4 days ago7 days ago

Fix TextRemove any demonstration and sample databases, database applications, objects, and files from the DBMS.To remove an account and all objects owned by that account (using BI as an example):DROP USER BI CASCADE;To remove objects without removing their own...
4 days ago7 days ago

Hi,I'm trying to consume Oracle fusion rest web service's in PLSQL using apex_web_service. I'm getting the below error. could you please guide me on this.also Pls suggest how to enable the basic authentication in web service like how to set the basic auth.ORA-...
4 days ago2 weeks ago

Hi guys,I have a little question on how does B2B data sharing work ?Say I am the department of home affairs and I want to share the data I hold (data that lives into an Oracle db) to others departments of the country.Especially the data about HR.So how to do w...
5 days ago7 days ago

Hi Tom, Some questions about the SQL tuning. 1) I found that when using "IN" in the where clause , INLIST ITERATOR is shown on the explain plan in a cost-based database (and using the index correctly, the response is fast). However, no such INLIST ITERATOR ...
5 days ago18.5 years ago

how to download a free oracle magazine in pdf about getting latest oracle database and it's technology relevant information as like MSDN of microsoft....
5 days ago5.1 years ago

Hi,I know how to use transform=oid:n in a CMD box using impdp. Is there a way to add that parameter to the import when using the Datapump Import Wizard in SQL Developer?Thanks....
6 days ago4.8 years ago

Hi all,It's first time post.We are facing a problem in 19c when generating a csv file.In 12c, results were as expected.Spaces are added after or before the content of the column.Please find attached the information about the environment.-- tables structureColu...
7 days ago7 days ago