Questions

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...

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. ...

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 ...

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 ...

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...

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...

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...

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!...

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...

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...

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...

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...

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-...

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...

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 ...

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....

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....

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...

Hi Tom and Team,I have a SELECT query that runs fine if submitted the 1st time (takes about 3 seconds), but if I submit it right after again, it could take anywhere from 22 to 37 seconds (on a pretty consistent basis). If I wait a few hours (or if I issue the...

Hi TomWant to understand how and where memory is allocated in an instance to evaluate decode, regexp functions in oracle? If we are reading data from a table and writing it any other location(not oracle), then what would be better-->while firing the query wit...