AskTom - Hot Questions

Subscribe to AskTom - Hot Questions feed AskTom - Hot Questions
These are the questions on Ask Tom that have the most comments
Updated: 56 min 17 sec ago

GETTING ORA-29270: too many open HTTP requests error

Wed, 07/26/2017 - 00:00
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...

Load CSV into table and split column into different rows

Sat, 07/22/2017 - 00:00
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...

Not able to recover Space even after Shrink space

Thu, 07/20/2017 - 00:00
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...

Break the results in select and put them in an XML

Wed, 07/19/2017 - 00:00
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...

"Fast" MERGE PARTITION

Wed, 07/19/2017 - 00:00
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...

How to Create Missing Records with Analytical Functions

Fri, 07/14/2017 - 00:00
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...

How to group timestamps in 10 minute buckets and aggregate

Thu, 07/13/2017 - 00:00
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 ...

SQL over PL/SQL

Tue, 07/11/2017 - 00:00
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...

my oracle database load is particularly high

Thu, 06/29/2017 - 00:00
Dear Mr Connor, my oracle database load is particularly high,and I don't connect it ,finally application developer reboot their application server to solve it! I export an AWR report for failure diagnosis in peroid time, <code> WORKLOAD REPOSIT...

DENSE_RANK - AGGREGATE function

Tue, 06/20/2017 - 00:00
Below is the the employee table, EID NAME SALARY COMM_PCT 100 Steven 24000 101 Neena 17000 0.6 102 Lex 17000 0.8 145 John 14000 0.4 If I do the below select to employee table I get the output as 3. SELECT DENSE_RANK(17000,0.6) W...

Unload Javascript web page contents to a text file to load in database table

Mon, 06/19/2017 - 00:00
Hello Experts, I have a requirement wherein I need to unload/export web page contents whose data is populated by javascript to a text/csv file; which in turn will be be loaded in the database table. I am not sure if utl_http will get the job d...

Range Partitioning Query

Fri, 06/16/2017 - 00:00
Hi Connor, After following Partitioning videos from KISS series started practicing on my own and have a query: In a Range partition, I want to create the partioining based on Country column and all values that belong to AU should go to AU_01 P...

Updating Table Using with Clause or Analytical Function

Fri, 06/16/2017 - 00:00
Hi, Good Day ! From last few days I came across many situations where I need to update a table based on some analytical function output. Since, my table don't have any primary key I am having limitation on update using SQL and hence I left with...

How to hidden password of connect to oracle database someone user is needed in shell script file?

Tue, 06/13/2017 - 00:00
<code> ;;; Export: Release 11.2.0.4.0 - Production on Tue Jun 13 04:00:02 2017 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. ;;; Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Pr...

best way to derive deltas when there is nothing set up on source

Mon, 06/12/2017 - 00:00
We are looking at a gradual migration of a legacy system running on 11gR1. We do not have control over the source system (although their DBAs are willing to accommodate <i>small</i> requests we might have). The data model is being changed drastical...

Query to get the count of records every two hours

Wed, 06/07/2017 - 00:00
I have a record creation time stamp in my table . I need to write a query to get the count of records every two hours between two specific dates. Starting from 1st January 2017 till today. I have the following table USER USER_ID CREATION_D...

ROWNUM Bugs

Fri, 05/19/2017 - 00:00
Hi, i read this below question https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:948366252775 in latest follow up a reader posted like this <code>( 5 years later... select * from X where rownum in (select 1 from dual) sti...

Toggle column value for alternate set of rows

Thu, 05/18/2017 - 00:00
Tom & team, I want to toggle the value in a column to 0 or 1 for alternate set of rows, can you please let me know the optimal way to accomplish this? select empno,dept.deptno, 0 counter from emp, dept where emp.deptno = dept.deptno orde...

Question on materialized view when concatenating several columns as a new column - cannot REFRESH FAST ON COMMIT

Mon, 05/08/2017 - 00:00
There is an error when my view is when concatenating several columns as a new column, it cannot REFRESH FAST ON COMMIT. CREATE MATERIALIZED VIEW LOG ON EXP_DC_HST WITH SEQUENCE, ROWID (ACTIVITY_DESCRIPTION, ACTIVITY_TYPE, CD1, CD2, CD3, CD4, C...

How to create tables automatically from multiple csv files in oracle database?

Mon, 05/08/2017 - 00:00
How to create tables automatically from multiple csv files in oracle database? For Example: I have a client requirement that load data from several csv files into an oracle database.I have 50 files with different structures.so ,i want create table ...

Pages