Skip to Main Content

Can't see the Ask Question button?

Connor and Chris will be back taking questions again soon. Click Notify Me to be emailed when we're back taking new questions.

In the meantime, you can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

Questions

QuestionUpdatedAsked

Hello, Ask Tom Team.I have like 20 tables using identity column for pk. Right now, I'm using returning clause to retrieve the pk (identity column using Oracle 12c feature) to be used as fk in the child tables. I have been asked to use stored procedures to popu...
83 minutes ago1.7 years ago

Got a SQL from the table with 100,000 + records , one particular varchar2 field contains strings like '12345', '56789', '1111'. I would like to create a table with split / chunks with appropriate comma seperate example in the live link ::: select listagg(id, '...
16 hours ago27 hours ago

Hi,I created a table with a date column in an Oracle 18 database and I filled it with some date values: create table test_date (col1 date); insert into test_date values (sysdate); insert into test_date values (sysdate); select * from test_date; COL1 ...
20 hours ago27 hours ago

how to use profiler (similar to MS SQL Server) in Oracle SQL Developer ...
20 hours ago45 hours ago

I wish to generate reports from my Oracle 11g database in an MS excel document(multiple tabs).Do we have a solution or a product from Oracle for this task?Thank you, Sunil...
21 hours ago2 days ago

Hello,I create a table and grant ALL privileges on it to user B. User B can delete, select, insert, update on the table, but When user B uses ALTER TABLE ... ADD CONSTRAINT...PRIMARY KEY OR UNIQUE, it has a SQL Error: ORA-01031: insufficient privileges. How ca...
21 hours ago2 days ago

Hi Tom,Could you please clarify why the following simple sql is returning the result?<code>select a.dummy, b.dummy, decode ( a.dummy, 'X', null, b.dummy ) from dual a, dual bwhere decode ( a.dummy, 'X', null, b.dummy (+) ) = a.dummy;</code>At first it looks l...
47 hours ago2 days ago

Hello, I've noticed that sometime a query of an Insert statement written in ANSI SQL runs slightly slower than a query constructed using Oracle native syntax. But recently I had a case when a native SQL executed within seconds, while the ANSI SQL could not com...
2 days ago2 days ago

Team, Very Good Monday Morning !! The Version of Oracle we use is :<i>Oracle Database 11g Release 11.2.0.4.0 - 64bit </i> No peculiar data or table design requried over here .This request is on behalf of Data and DB Objects Migration in our project.<i>we hav...
2 days ago2 days ago

Hi,The objective is to unload data using external table (oracle_datapump) from Oracle package.But, when trying to execute from a package using execute immediate it fails with below error message.It works fine when running as anonymous pl/sql block or from sqlp...
2 days ago4 weeks ago

Which one is recommended in terms of performance(time taken to perform this activity) from below for a table with 18 GB data?https://oracle-base.com/articles/misc/partitioning-an-existing-table-using-exchange-partitionor https://oracle-base.com/articles/misc/p...
2 days ago2 days ago

Hello, I researched your Q/A bank before asking this question. What are some of the things to keep in mind, where a benefit to using a sql profile turns into a curse. What are the things that can cause the use of sql profile to go bad or problems that can go u...
3 days ago7 days ago

My question has been asked already athttps://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:9533980100346684832Anyway I cannot understand why I can create in that directory a file using FOPEN, why I can copy it, why I can remove itbut cannot FRENAM...
3 days ago3.5 years ago

Hi I have a rman full backup and I want to restore single table due to drop that table how can I do this.I can not create a clone due to space and resources issue..Thanks...
3 days ago3.7 years ago

Hi Tom,On your website I didn't find anything about this topic that could help me, so I decided to write.We detect a situation in the execution of a procedure that is not expected to happen. The output parameters are returned with values, when it was not suppo...
3 days ago7 days ago

<code>CREATE OR REPLACE PACKAGE BODY INTLECM.PRODUCT_UTF_CHECK ASG_FILE UTL_FILE.FILE_TYPE; DEBUG_PROCESS_ID LOG_PARAMETERS.PROCESS_ID%TYPE; PROCEDURE NL ISBEGIN UTL_FILE.NEW_LINE(G_FILE);END NL;FUNCTION ITE (B BOOLEAN, T NVARCHAR2, F NVARCH...
3 days ago7 days ago

Tom, your site has been very usefull, and usually I can get an answer by looking at past responses. However, this time I need to ask you a question.An application analyst wants to track the total number of SQL executed per day in Prod database, and look at lon...
5 days ago9.4 years ago

Typically companies that can afford the high cost of a multiple node RAC license, they can afford to have an enterprise SAN solution. The SAN solution like a Netapps is an appliance with it's own software and CPUs to process data quickly. They also usually h...
6 days ago7 days ago

Hi,We executed several SQL queries via SQL Developer and SQL*Plus on Windows 10 but got the following error.<b>Error: </b><code>ORA-27102: out of memoryIBM AIX RISC System/6000 Error: 12: Not enough spaceAdditional information: 7195Additional information: 1677...
6 days ago12 days ago

I have several scripts that are hard wired when creating a database link and all works well. The time has come though to take them to the next level and expand the user community. To do that the CREATE DATABASE LINK statement needs to be dynamically determin...
6 days ago2.9 years ago