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

Some times an aleatory select statement stop working without a clear reason.Some times the statement is inside procedure, some times it is executed directly from ODAC FOR .NET 4Then only thing in common it was always executed by ODAC client, so I never got thi...
5 days ago12 days ago

We have looked at dbms_flashback and dbms_wm but both don't deliver what we actually want: Is there a possibility to make an entire session transient?We would like to use this for our testing scenario's:1. Start the session in "transient mode"2. execute ...
5 days ago7 days ago

Hi Connor, Chris,I have a FOR UPDATE SQL used to lock certain rows in ORDERS table but it seems to be bit slow (takes around 1 min).I tried getting plan from dbms_xplan.display_awr. Could you please give me some lead from your past experience and I can look fo...
5 days ago7 days ago

I do have a question about Oracle Indatabase archiving in Oracle 19c,given below table has a XMLtype columnalter table HTS_SUMMARY_DATA_CELL row archivalError report -SQL Error: ORA-38353: This table type is not supported by the ROW ARCHIVAL clause.This error ...
5 days ago11 days ago

I have a simple stored procedure, that I would like to have a passed in string(varchar2) for used in select from where col1 in (var1) in a stored procedure. I've tried everything but doesn't work. Followed is my proc. Thanks CREATE OR REPLACE PROCEDURE WSRE...
5 days ago20.5 years ago

The server machine on which the DB resides has 32 CPUs. (2 sockets * 8 cores per socket * 2 threads per core)I notice many oracle processes (both non-background and background) consuming high (sometimes 100%) of the CPU.Now, this CPU % is only for 1 CPU out o...
5 days ago7 days ago

Hi Chirs, Connor,Could you please help or suggest a way to generate string based on patternPattern - <b>^[a-f0-9]{8}-[a-f0-9]{4}-[a-f0-9]{4}-[89ab][a-f0-9]{3}-[a-f0-9]{12}$</b>I need to generate millions of string like <b>f9f8c8e2-0b20-4160-8f74-e836f4661fc5<...
6 days ago7 days ago

I want to return headers of column along with data while returning result using refcursor.<code>create table fetch_header_rows(company_name varchar2(500),Company_id number,ammount number(20,8),data_commnets varchar2(500));insert into fetch_header_rows values('...
6 days ago7 days ago

Purchase_Mas contains data of purchase master and payment_amt contains data of payment received from party.Cursor c2 does not return any value when not found in payment but still i want to some calculation happen even data not found in payment table.run follow...
6 days ago7 days ago

Hi TeamWe are running Non-RAC Oracle 11.2.0.3.0 and the TNS poison attack vulnerability (Oracle Security Alert for CVE-2012-1675 - https://www.oracle.com/security-alerts/alert-cve-2012-1675.html) looks affected this version of Oracle.What we have done:* Have a...
7 days ago7 days ago

Hi,In my procedure I'm trying to check whether a database link and a directory exist. If they don't I wanted to display a nice message about them needing to be created etc.I thought of using dbms_assert.sql_object_name, this seems to do the trick for tables, v...
7 days ago3 weeks ago

Hi,i want to iterate all rows in table and do some operations on them, but i don't want to get data with some select statement. In order to do that i tried to export data as .dbf and read it with Java and do some stuff. But it seems Oracle .dbf format differs ...
7 days ago12 days ago

Hello Tom,Please, I need a big help.I have a job scheduled in Enterprise Manager 12c. This job do a full export, but two days ago I started to get the error below:ERROR at line 1:ORA-31626: job does not existORA-06512: at "SYS.DBMS_SYS_ERROR", line 79ORA-06512...
7 days ago3.8 years ago

Greetings,How can we make our bi-yearly password update of accounts used by hundreds of application servers as easy as possible?  Running the "alter user <username> identified by <newpassword" is easy.  The hard part is updating and encrypting the new password...
7 days ago2 weeks ago

I've a requirement to convert hardocdings in below case statement used in sql to a lookup reference table .The case statement refers to 4 columns i.e enterprise,pbm_vendor,bhc_relationship_type,payer_entityI would like to create a lookup table using these 4 co...
7 days ago13 days ago

I want to insert data from excel or csv file (Id, Name, Address, Amount) into database table by using data load but during the insert of this data i want to decide this data is related to HSBC Bank (Because i have many bank and each bank have thousand of custo...
10 days ago13 days ago

Hello,Is it possible to write a single SQL query that would concatenate multiple rows into a single row with multiple columns?For example, I have a table with the following data:<code>TYPE DATE AMOUNT--------------------------------B 30.6.2019 ...
10 days ago9 months ago

Hello Tom, How to do a Full DB exp and Import.I do say exp system/manager@xyz FULL=Y FILE=FULL.DMPThen If I want to do a full Import to a new freshly created DB which only has the default schemas sys , system , etc.1) Please correct me :- I would n...
11 days ago11.7 years ago

I have a table with two columns that need to be defined as primary keys, order_number and item_number. A table can have only one primary key, but I can define composite primary keys in the table_constraint syntax. How do I define two columns as composite pri...
11 days ago20.5 years ago

I have inserted the same primary key data but the Second Session is locking forever! Is there an option to alter user session to raise timeout after 60seconds or NOWAIT for the second sessions INSERT command.In our environment session 1 is a long running batch...
11 days ago1.6 years ago