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: 2 hours 51 min ago

Load and update summarized data to a table

Sun, 04/19/2020 - 00:00
Hello, Ask TOM Team. I have two tables: <code>CREATE TABLE USER.DOC_DETAILS (CLIENT_ID NUMBER NOT NULL, DOC VARCHAR2(13 BYTE) NOT NULL, REGISTER_DATE DATE NOT NULL, TAX1_AMMOUNT NUMBER(18,2), TAX2_AMMOUNT NUMBER(18,2), TAX3_AMMOUNT N...

Filters order in SQL query

Thu, 04/09/2020 - 00:00
Hello, Ask Tom Team. I want to know to put the correct order in the filter in a SQL query. I mean, in the WHERE condition. 1. How can we help the optimizer in order to have the best performance? I know that it tries to execute the best plan ba...

Oracle 11g select query with Json field

Thu, 04/02/2020 - 00:00
I want to fetch data from below table. Table Name: Insight <code>Id | Name | JSON_DATA ----+------------+------------------------------------------------------------- 1 | Sitansu. | {"country_codes": ["IND"], "regions": ["ASIA"]...

Uploading files in a Rest webservice using PlSql UTL_HTTP

Mon, 03/30/2020 - 00:00
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...

Pass string values to stored procedure

Fri, 03/27/2020 - 00:00
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. DELETE FROM user1.table4 t4 WHERE t4.id...

many to many joins

Wed, 03/18/2020 - 00:00
Hi there, Firstly, Thank you to you all for an amazing service you provide here. Now onto business, I am a complete novice at understanding the ins and out of Oracle, though I have been dabbling with it for years. I am currently working on...

Pages