Hi, Please find below procedure from which we are keep on getting "ORA-29270: too many open HTTP requests" error, Procedure: <code>CREATE OR REPLACE PROCEDURE test_task ( p_quote_number IN cct_quote.quote_number%TYPE, p_quote...

I have to load a csv file data into a table in oracle. One of the columns of csv file has data more than 4000 characters which has many values. These values can be distinguished from one another by keyword "http" or "https". I need to split them int...

Hi Tom, I have DB with one tablespace and many datafiles whereas tables are spread over many datafiles. I used below query to check fragmented tables list. select owner,table_name,blocks,num_rows,avg_row_len,round(((blocks*8/1024)),2) "TOTAL_SIZE...

Hi Team, I have a table Employee as below <code>Employee_ID Employee_Name 1 Usha 2 Soma 3 Uma</code> . . . and so on I have 5000 records in the table I have a defined count only 1000 reco...

Hi Tom ! As of Oracle 12c there exists FAST SPLIT PARTITION. Is there something similar for MERGE PMO? The exact problem is this. As currently there is no way to increase HIGH VALUE of RANGE PARTITION (at least I'm aware of), the only way t...

Hi AskTom Team, I am having some trouble figuring out a query to do the following: I have a staging table populated by an external system. This table stores information about how much an item sold during a day. If an item hasn't sold anything d...

I've been grappling with this problem for almost a week. Other threads on this site have gotten me close but not all the way. I created a table and populated it using sqlldr. The queries for that are below this question. I want dateValidFrom ...

Hi Team, Could you please have a look at below scenario: I have 3 tables: select * from tab_login_details; select * from tab_request; select * from tab_access; Basically i need output as below: FK_TB_LOGIN_MASTER FK_TB_COMPANY_DETAILS FL...