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...

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...

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

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...

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...

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...