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

Hi tom,when i tried use this wm_concat() function in 12c i'm getting this error can you briefly explain?ORA-00904: "WM_CONCAT": invalid identifier00904. 00000 - "%s: invalid identifier...
27 minutes ago4.3 years ago

Hi,The attribute clustering works only for the direct path inserts? Will it support the normal inserts? If not whats the way to have the data in table stored in an ordered way especially for normal inserts (not direct path).Can you explain whether index cluste...
27 minutes ago2 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, '...
17 hours ago5 days ago

For the last 17 years I've been focused on real-time apps where the number of rows retrieved from Oracle is usually 1 and almost always less than 10. I have a good reputation in being able to write very performant real-time applications, but suddenly I'm face...
3 days ago8 days 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...
4 days ago3.7 years 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...
4 days ago2 weeks ago

Clients complain that Application on the Oracle 12c DB is running slow. I do see some 100% CPU consumption for oracle processes with the top command. Now, because the oracle is standard edition, it does not have the diagnostic+tuning packs. In this situation,...
4 days ago7 days ago

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...
4 days ago1.7 years 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 ...
5 days ago5 days ago

how to use profiler (similar to MS SQL Server) in Oracle SQL Developer ...
5 days ago6 days 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...
5 days ago7 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...
5 days ago7 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...
6 days ago7 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...
6 days ago7 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...
6 days ago7 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...
6 days ago5 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...
7 days ago7 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...
8 days ago12 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...
8 days ago3.5 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...
8 days ago11 days ago