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 26 min ago

Standby Redo Logs Required For All Protection Modes ?

Fri, 09/01/2017 - 00:00
Hi TOM, Why do we need standby redo logs on standby database when the protection mode is MAX PERFORMANCE? Oracle documentation ( says : "You must add standby redo log files on a...

Tuning Question

Wed, 08/30/2017 - 00:00
Hi I have the following query: <code> SELECT cust_id, cosmos_cust_id, prot_id, customer_name, protocol_name, dist_order_no, cust_ivr_ref_no, ship...

JSON object access using JSON_TABLE

Sun, 08/27/2017 - 00:00
Hi I have a JSON object containing complex MVA, and would like to have relational access to my JSON object using JSON_TABLE + View. The way I am doing it right now, gives me 4 rows when I query the View, and I would like the SQL to return two r...

Using Dynamic Table Name in Select Statement To Prepare Extract File

Fri, 08/25/2017 - 00:00
Hi. We use to prepare extract file from oracle using extract script. There are few tables whose name gets change every month. Need to handle these table names dynamically. <code>SELECT TICKET_ID ,SOURCE_ID ,SERV_ID ,...