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

Question is simple Is there any way where I can get primary keys of a table which have been updated by update statements ? By doing that I want to leverage a select for an update Example There is a table EMPLOYEE with EmployeeID,EmployeeName .I want to update ...
37 seconds ago2.9 years ago

I`ve try to start integrated Extract:<code>REGISTER EXTRACT EXTR_R DATABASEADD EXTRACT EXTR_R, INTEGRATED TRANLOG, begin nowADD EXTTRAIL ./dirdat/lt, EXTRACT EXTR_RSTART EXTRACT EXTR_R</code>with param file:<code>Extract EXTR_RUSERIDALIAS GGUSERSRCexttrail ./d...
5 minutes ago20 hours ago

Hi Team,I was just playing around with some stuff so thought sharing with you.My understanding for Primary key was that Oracle uses Unique Index to enforce primary key constraint on table's column to be unique.Below is the code that I tried, in which I created...
21 minutes ago2.2 years ago

Hi,I'm calling REST web services using PLSQL UTL_HTTP package, in JSON, with no problems.However, now i need to invoke a WS but attaching a file.I can do it with Postman in “form-data” mode.In PLSQL, I've tried the same thing in the body of the request:<code>{...
48 minutes ago15 hours ago

Hello Ask Tom, Team.I am struggling with distributed transactions. Oracle RAC 18c (18.6) and .NET app. I want to know a few things:The RECO background process of an Oracle Database instance automatically resolves failures involving distributed transactions. At...
51 minutes ago23 hours ago

Hello Tom,We have acquired an Exadata Server and would like to clarify some issues that I believe are product myths.1 - After removing indexes, can queries get faster?2- I have always used indexes on the columns identified as FKs. Is this still a good practice...
52 minutes ago3.1 years ago

Hello Tom,I have been straggling a few days with issue of connecting to Oracle Enterprise Manager.Please see my configurations:OS: Oracle Linux 7Database: Oracle Base 12C R2product/12.2.0/dbhome_1/network/admin/tnsnames.ora<code>LISTENER_ORCL = (ADDRESS = (PR...
53 minutes ago3 weeks ago

Hello people,I would like to ask for your help with a simple issue. I am srry if this is too common, but for me it is not easy at all: I have a table like this - p.sometable:<code>ID AMOUNT YEARcusomter1 42476281.61 2015cusomter1 11187102...
10 hours ago2 days ago

Bello, Ask Tom Team.I need to build a report that connects to a 18c Oracle database. There are big tables and I need to paginate the results. I want to show 50 rows per page in the report.I have read about Fetch, Offset features since Oracle 12. I also have th...
11 hours ago22 hours ago

Hi,We have partitions in our table. We want to build index for just one partition. If we do that, then does it affects the application? One time we got an error like index in unusable state.First we create index in unusable state like:<code>Create index idx_na...
15 hours ago19 hours ago

Why can't you find data in an XML when I have proof of its existence?...
15 hours ago3 days ago

I am using UTL_FILE.FOPEN('Unix_Directory_path','FileName.txt','w') in my Pl/Sql package and the file is getting written successfully but the User and permission are different than the file generated using SPOOL, both are using the same batch file in UNIX-rw-r...
24 hours ago3 days ago

The question I have is regarding the ADD_MONTHS function. The live sql link for the test case is as below:- https://livesql.oracle.com/apex/livesql/s/JT1FDGOHXMRWN3LG94GEYLMPJIf we have a look at this link it has 3 components:- 1. A function that takes an old ...
24 hours ago3 days ago

In oracle databse 12c it says it suppirt ethiopian calander.in my database I have one employee table in that I have one column hiredate which date data type until i want to insert ethiopian calander date type data how it is possible?...
25 hours ago2 weeks ago

Hello, Ask Tom Team.I have several DELETE statements and I want them all within a stored procedure to simplify execution. All these statements would use different string values in the where condition. DELETEFROM user1.table4 t4WHERE t4.id IN (SELECT t3.id ...
26 hours ago3 days ago

Hello Team,Would really appreciate any help in this one. Every day our DBMS Stats job runs at around 10 GMT which is around 4pm CST. We have a table that holds close to 10M records and keeps inserting into the table almost every second.Recently during the time...
26 hours ago1.3 years ago

I have 7M rows from legacy system. <code>insert /*+ append */ into TGT_DATA (LST_NAM,FRST_NAM,MDL_NAM)SELECT /*+ parallel(10)*/ func_text_clean(LST_NAM),func_text_clean( FRST_NAM),func_text_clean( MDL_NAM) FROM P_ONST;</code>If function is removed from selec...
3 days ago3 days ago

Where in v$ views is hiding info about PROXY_USERNAME ?I'am aware of little piece of information in v$session_connect_info and dbproxy_username column in unified_audit_trail.Most appropriate place will be in v$session, but i didn't find it.Regards Dejan...
3 days ago3 days ago

I would like to extract DDL of indexes to store it outside the database. The purpose of this effort is to save the DDL to use it on fly when we need. I could use export/import tool but it requires editing when we want to run the text from SQL. I am planning to...
3 days ago19.1 years ago

Team,Was reading about Band join from the below link <u>https://docs.oracle.com/en/database/oracle/oracle-database/12.2/tgsql/joins.html#GUID-24F34188-110F-4245-9DE7-43954092AFE0</u><u>https://jonathanlewis.wordpress.com/2017/02/13/band-join-12c/</u>and tried ...
3 days ago5 days ago